• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse

Chart

This sample demonstrates the Spreadsheet component and its features such as editing, formulas, formatting, importing, and exporting.

DEMO
SOURCE

The Spreadsheet component is used to organize and analyze data in a 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 rangeSettings of sheet. The cellFormat and numberFormat methods are used to apply format to a range of cells in the dataBound event.

More information about the Spreadsheet component can be found in this documentation section.