Skip to main content Skip to footer

FlexSheet: Excel-like Spreadsheet Control for ASP.NET MVC

Give your users the flexibility to view and edit spreadsheets like Microsoft Excel in your MVC 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.


Why Choose FlexSheet for ASP.NET MVC?

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 XLSX files client-side, bind FlexSheet to an external JSON 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.

ASP.NET MVC FlexSheet Key Features

Import and Export Data

  • Import, edit, and export Microsoft Excel files (.xls, .xlsx) asynchronously from the server
  • Save and load spreadsheets as a JSON workbook object using client-side methods
  • Bind FlexSheet to an external data source or go unbound
  • When unbound, start with a blank sheet and programmatically set cell values using pure JavaScript or C#


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
  • Turn a range of cells into a Table to better manage and analyze related 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 (autofill), that follows a pattern, by dragging the bottom right corner of the cell.
  • Sort the spreadsheet by any column to better visualize the data set