FlexSheet: .NET Spreadsheet Control

View and edit spreadsheets like Microsoft Excel in your .NET applications with ComponentOne FlexSheet.

Import spreadsheets, evaluate formulas, and apply cell styling
Deliver Excel file management within your custom business application
Supported in WPF, ASP.NET MVC and Wijmo JavaScript

FlexSheet is part of ComponentOne Studio Enterprise.

Why Choose ComponentOne FlexSheet?

Mimic Microsoft Excel

Deliver Excel-like spreadsheet behavior in your datagrid for the desktop or the web using FlexSheet in any of the supported platforms: WPF, ASP.NET MVC, and JavaScript.

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.

Familiar, Fast, and Flexible

FlexSheet extends FlexGrid and provides lightweight spreadsheet functionality for ComponentOne Studio Enterprise. For more advanced spreadsheet features, see Spread .NET.

.NET FlexSheet Key Features

Import and Export Data

Import, edit, and export Microsoft Excel files like .xls and .xlsx
Bind FlexSheet to an external data source or go unbound
Start with a blank sheet and programmatically set cell values using code when unbound
Save and load spreadsheets as additional formats, such as CSV and JSON
Asynchronously load files on the server via the web

Manage Multiple Worksheets

Manage multiple worksheets with an Excel-like, tabbed interface
Switch between worksheets, edit content directly on the sheet, and update content via code
Manipulate sheets within a workbook by creating, deleting, and renaming sheets
Reference other sheets or cell values
Insert, delete, freeze, and reorder rows and columns
Protect sheets and lock cell ranges to prevent editing

Analyze and Evaluate Formulas

Analyze and evaluate Excel-style formulas with FlexSheet's powerful formula engine
Utilize nearly 100 built-in functions, including Logical, Math, Statistical, Text, Lookup, and DateTime
Receive an error message from FlexSheet when it recognizes 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 Autofill Data

Apply conditional and value-based filtering just like Excel
Fill cells automatically with data by dragging the bottom right corner of the cell (ASP.NET Web Forms Edition)
Organize rows of data within a worksheet by grouping (WPF Edition)
Sort the spreadsheet by any column to better visualize the data set