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.
- Data Editing - Enter, update, and manage tabular data directly within the spreadsheet.
- Formulas & Calculations - Perform Excel-style calculations such as totals and summaries using built-in formulas.
- Cell & Number Formatting - Apply text styles, alignments, currency formats, and date formats for better readability.
- Data Binding - Bind worksheet data using data sources configured through sheet ranges.
-
Import & Export - Open existing Excel files and save spreadsheets using the
openUrlandsaveUrlserver endpoints.
More information about the Spreadsheet component can be found in this documentation opens in a new tab section.