Example of Default Functionalities in Javascript Spreadsheet Control

/
/
Default Functionalities

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

More Details...

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Customer NameModelColorPayment ModeDelivery DateAmount
Romona HeaslipTaurusAquamarineDebit Card7/11/2015$8,529.22
Clare BattertonSparrowPinkCash On Delivery7/13/2016$17,866.19
Eamon TraiseGrand CherokeeBlueNet Banking9/4/2015$13,853.09
Julius GornerGTOAquamarineCredit Card12/15/2017$2,338.74
Jenna SchoolfieldLXYellowCredit Card10/8/2014$9,578.45
Marylynne HarringCateraGreenCash On Delivery7/1/2017$19,141.62
Vilhelmina Leipelt7 SeriesGoldenrodCredit Card12/20/2015$6,543.30
Barby HeislerCorvetteRedCredit Card11/24/2014$13,035.06
Karyn BoikRegalIndigoDebit Card5/12/2014$18,488.80
Jeanette PamplinS4FusciaNet Banking12/30/2014$12,317.04
Cristi EspinosTLAquamarineCredit Card12/18/2013$6,230.13
Issy HummClub WagonPinkCash On Delivery2/2/2015$9,709.49
Tuesday FautlyV8 VantageCrimsonDebit Card11/19/2014$9,766.10
Rosemaria ThomannCaravanVioletNet Banking2/8/2014$7,685.49
Lyell FuentezBravadaVioletDebit Card8/5/2016$18,012.45
Raynell LayneColoradoPinkCredit Card5/30/2016$2,785.49
Raye Whines4RunnerRedDebit Card12/10/2016$9,967.74
Virgina AharoniTSXPinkCash On Delivery10/23/2014$5,584.33
Peta CheshirPathfinderRedNet Banking12/24/2015$5,286.53
Jule UrionChargerVioletDebit Card11/20/2013$13,511.91
Lew GilyattBonnevilleCrimsonCredit Card11/19/2013$6,498.19
Jobey FortunB-SeriesBlueNet Banking10/30/2014$10,359.67
Blondie CrumpVoyagerTurquoiseCredit Card4/6/2018$8,118.39
Florentia BinnsGrand PrixOrangeCash On Delivery10/13/2016$10,204.37
Jaquelin GaltoneSunbirdRedNet Banking10/22/2013$6,528.06
Hakeem EassebyMirageCrimsonDebit Card9/12/2014$5,619.25
Nickolaus GidmanXKOrangeDebit Card5/12/2016$5,091.43
Jenine IglesiaAccordOrangeDebit Card9/3/2018$14,566.08
Customer Name
Description

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 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 section.