Provide an Excel-like experience to your ASP.NET web application users with FlexSheet for MVC, a fast and lightweight control which extends the features of the FlexGrid. The control introduces basic spreadsheet functionality to your MVC application, enabling you to work with formulas and load or export excel files. It extends server side operations for remote data binding and loading of excel files from server. Moreover, it gives your end users the flexibility to display, edit and save the excel files on the client side.
Easily create (unbound or bound) FlexSheet applications and explore endless possibilities for effectively viewing, editing and analyzing your business data.
Key Features
- Built-in Formula Support: Work with nearly 100 built-in formulas supported by FlexSheet's calculation engine, together with the advantage of auto-completion. Our formula operations are aligned with Microsoft Excel, including the operations for aggregation, mathematics, logic and text.
- Multiple Sheets: Add multiple separated worksheets to your application, which are represented by tabs that flip between pages.
- Cell Style: Customize your FlexSheet cells by applying styles to each cell. You can easily set desired data format, font, horizontal alignment, fore color, fill color, etc. to the cells in FlexSheet.
- Merge Cells: Easily merge two or more adjacent cells of your FlexSheet control. The merged cells will contain data from upper-left most cell only. FlexSheet enables you to merge any group of adjacent cells, unlike FlexGrid which allows content-driven merging only.
- Undo/Redo: Undo/redo multiple operations of editing cells, inserting/removing rows or columns, applying cell styles, merging cells, resizing rows/columns, dragging and dropping rows/columns, etc.
- Drag and Drop: Drag and drop rows/columns to move or copy current rows/columns to another rows/columns.
- Column Selection: Select an entire column by simply clicking the column header.
See Also