Skip to main content Skip to footer
FlexSheet .NET Spreadsheet Control

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?

Excel-Like Design

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: WPFASP.NET MVC, and JavaScript.

Existing Data

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

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