Example of Default Functionalities in ASP.NET MVC Spreadsheet Control
This ASP.NET MVC Spreadsheet exampleopens in a new tab demonstrates the default, Excel-like capabilities of the ASP.NET MVC Spreadsheet component, including data editing, formulas, formatting, and file import/export. It showcases how common spreadsheet operations can be performed interactively within a web application.
The Spreadsheet component is used to organize and analyze data in tabular format.
It has a built-in calculation library that supports most commonly used formulas. Excel workbook files can be
imported and exported by providing openUrl &
saveUrl property.
Data binding can be achieved by setting a list objects or an instance of Data Manager to the
dataSource property under the ranges of sheet. The cellFormat and
numberFormat
methods are used to apply format to a range of cells in the created event.
Key Features
- Data binding - Populate worksheets by binding data from JavaScript objects, arrays, or DataManager sources.
- Formula calculation - Perform calculations using the built-in calculation engine that supports commonly used Excel formulas and functions.
- Cell and number formatting - Apply styles, alignment, currency, date, and custom number formats to enhance data presentation.
- Import and export support - Open, edit, and save Excel workbook files while preserving worksheet data and formatting.
- Excel-like spreadsheet experience - Organize, analyze, and manage tabular data with familiar spreadsheet features and interactions.
Learn how to bind data, apply format, calculate formulas, and import or export Excel files using the Spreadsheet component features demonstrated in this sample.
Documentation Links
More Resource