FlexSheet: Excel-like Spreadsheet Control for WPF
View and edit Microsoft Excel spreadsheets in your desktop apps. With ComponentOne FlexSheet you can:
- Import, edit, and export Microsoft Excel files
- Create custom forms and spreadsheets bound to external data sources
- Manage worksheets, evaluate formulas, and apply cell styling
FlexSheet is part of ComponentOne Studio Enterprise.
Download Free TrialWhy Choose FlexSheet for WPF?
Provide a Familiar Interface
FlexSheet provides a familiar Excel-like experience so there is minimal learning curve for your users.
Work With Your Existing Data
Import and export existing XLSX files, bind FlexSheet to an external data source or work unbound. Take advantage of .NET code to power the backend of your users' spreadsheets.
Lightweight Spreadsheet Control
FlexSheet extends FlexGrid and provides lightweight spreadsheet functionality for ComponentOne Studio Enterprise. For more advanced spreadsheet features, see Spread .NET.
WPF FlexSheet Key Features
Import and Export Data
- Import, edit, and export Microsoft Excel files (.xls, .xlsx)
- Save and load spreadsheets from basic text files (.txt, .csv, .html)
- Bind FlexSheet to an external data source or go unbound
- When unbound, start with a blank sheet and programmatically set cell values using C# or VB.
- Print or save FlexSheet to a PDF document with margin support and scaling options
Manage Multiple Worksheets
- Manage multiple worksheets with an Excel-like tabbed interface
- Switch between sheets, edit content directly on the sheet, and update content via code
- Manipulate sheets within a workbook: create new sheets, delete sheets, rename sheets, and so on
- Include references to other sheet or cell values
- Insert, delete, freeze and reorder rows and columns
- Protect sheets and lock cell ranges to prevent users from editing
Analyze and Evaluate Formulas
- Analyze and evaluate Excel-style formulas with FlexSheet's own powerful formula engine
- Work with nearly 100 built-in functions including Logical, Math, Statistical, Text, Lookup, and DateTime
- FlexSheet displays an error message when it catches an invalid formula
- Customize the formula bar UI using the separate C1FormulaBar control
Apply Cell Styles and Formatting
- Customize cell styles, including font, color, placement, and borders
- Specify the display format for numbers, currency, percentage, and date
- Apply styles and formatting to the whole sheet, including rows, columns, cells, and cell ranges
- Merge cells together to enhance the readability of your data
- Show or hide header and grid lines
Filter, Sort and Group Data
- Apply conditional and value-based filtering just like Excel
- Organize data within a worksheet by grouping and collapsing rows
- Sort the spreadsheet by any column to better visualize the data set
