This sample 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 an array of JavaScript objects or an instance of Data Manager to thedataSource property under the ranges of sheet. The cellFormat andnumberFormatmethods 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 section.