Example of Default Functionalities in ASP.NET Core Spreadsheet Control

Spreadsheet
Default Functionalities

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

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
CustomerNameModelColorPaymentModeDeliveryDateAmount
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
CustomerName

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 dataBound event.

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

Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab