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 Trial

Why 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