Example of Default Functionalities in ASP.NET MVC Spreadsheet Control
This ASP.NET MVC Spreadsheet exampleopens in a new tab demonstrates the Spreadsheet component and its features such as editing, formulas, formatting, importing, and exporting.
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.
More information about the Spreadsheet component can be found in this documentation opens in a new tab section.