Winforms Spreadsheet Getting Started
The WinForms Spreadsheet Control is an Excel-inspired control that allows you to create, edit, view, and format Microsoft Excel files without having Excel installed. It provides an integrated ribbon to cover any possible business scenario and easily maximize it. In addition, it supports built-in calculation engine with more than 400+ of the most widely used formulas. It is built with .NET Excel library(Essential XlsIO), which features a full-fledged object model similar to the Microsoft Office Automation libraries.
Features and Benefits
Read, edit, and write Excel files, compatible with versions 97 to 2016
Read and write all popular Excel file formats, including XLS and XLSX. A file can be opened in one format and saved in another format.
Experience Excel like Ribbon UI
- The spreadsheet ribbon provides a familiar, Excel-like user interface to help end users work with Excel files.
- The ribbon can easily be customized to manipulate Excel workbooks based on application requirements.
- Allows you to create your own ribbon or toolbar to manipulate Excel workbooks using predefined commands of the control.
High performance
Instant loading - Load and manipulate Excel-like workbooks with a large amount of data and any number of worksheets in less time with minimal memory consumption.
Smooth scrolling - Provides a smooth scrolling experience even with many cells in the view.
Data editing
Data editing - Allows adding, editing, and removing formulas in a cell. Additionally, users can select the range reference directly using a mouse or keyboard when entering formulas, just like Excel.
Data validation - Validate the edited values based on the data validation rules defined for a cell or range of cells. Data validation can be applied with operators, alert messages, custom formulas, and drop-down lists.
Undo and redo - Undo and redo changes can be made in an Excel workbook. Similarly, there is no limit to the number of undo and redo operations in spreadsheet.
Clipboard operations - Allow users to enable Excel-like paste option to paste a value or formula with or without formatting.
Hyperlinks and bookmarks
Provides built-in support for hyperlinks and bookmarks. Additionally, supports navigation through bookmarks to a specific cell or range of cells in a workbook like Excel.
Efficient formula calculations
A wide range of formulas is available with cross-sheet references, named ranges, table formulas, and array formula support.
Built-in functions - The built-in calculation engine is preloaded with more than 400+ Excel-compatible functions covering a broad range of business scenarios.
Auto calculation - Cell values are recalculated when a precedent cell is edited.
Styles and data formatting
Font - Import and modify various font formatting options like font size, font family, font styles, font color, and fill color.
Align and merge cells - Import and modify various alignments, merged cells, and wrap settings from Excel.
Number formats - Import and modify number formats such as currency, percentage, short date, long date, time, fraction, scientific, and custom number formats similar to Excel.
Conditional formatting
Helps you to visually explore and analyze data, detect critical issues, and identify patterns and trends.
Conditional styling - Format the appearance of cells based on their value or values of other cells.
Data bars - Use gradient or solid data bars to easily spot the largest to the smallest numbers.
Outline (Group)
Import outlines and group or ungroup rows and columns at runtime.
Data shapes
Charts - Import charts from Excel that can be defined at runtime. This helps visually enhance the represented data.
Sparklines - Import sparklines from excel to visually represent data in a row.
User friendly UI Interactions
Touch optimized - The spreadsheet control is touch-optimized for all user interactions like Excel.
Excel-like selection - Select a range of cells, rows, columns, and tables. The spreadsheet control also supports all keyboard interactions with cell selections.
Data management
Import and export data from various sources with the help of .NET Excel library (Essential XlsIO) as an intermediary.
Worksheet management
Insert, delete and rename - Insert and delete worksheets in a workbook. You can rename the worksheet by editing the UI or programmatically.
Hide and unhide - Hide and unhide worksheets in a workbook.
Gridlines - Customize the visibility and color of gridlines.
Headings - Control the visibility of row and column headers in a worksheet.
Protection and encryption
Protect worksheets with or without a password, and restrict user actions like row and column insertion, deletion, resizing, and more.
Protect the structure of a workbook.
Encrypt workbooks with a password to prevent users from opening them.
Conversion and printing
PDF - Convert a spreadsheet workbook or worksheet to PDF format. Various customization options are provided, like embedding fonts, ignoring empty pages or worksheets, and showing or hiding headers and footers.
Image - Worksheets can be converted to BMP, JPEG, PNG and other image formats, with content such as data, formatting], charts, tables, and shapes.
Localization
Localize all static text in the ribbon and built-in dialogs to any desired language.
Related Links
Learn More about WinForms Spreadsheet
Suggest a feature or report a bug
About Syncfusion WinForms UI Controls
Syncfusion's WinForms UI controls library is the only suite that you will ever need to build an application since it contains over 100 high-performance, lightweight, modular, and responsive UI Components in a single package. In addition to Spreadsheet, we provide popular WinForms Controls such as DataGrid, Charts Scheduler, and Syntax editor
About Syncfusion
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 27,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.
Today we provide 1700+ controls and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP, JavaScript, and (MAUI(Preview)), and desktop development (WinForms, WPF, WinUI, UWP, Flutter, and (MAUI(Preview)). We provide ready-to-deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.
sales@syncfusion.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET
