Example of Cell Formatting in ASP.NET Core Spreadsheet Control

Spreadsheet
Formatting
Cell Formatting

This sample demonstrates the Spreadsheet cell formatting feature by applying different styles to a range of cells.

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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
OrderIDCustomerNameOrderDateAddressCityPostalCodeCountryStatusFreight
10248Paul Henriot7/4/199659 rue de l AbbayeReims51100FranceDelivered$32.38
10249Karin Josephs7/5/1996Luisenstr. 48Münster44087GermanyDelivered$11.61
10250Mario Pontes7/8/1996Rua do Paço, 67Rio de Janeiro5454876BrazilShipped$65.83
10251Mary Saveley7/4/19962, rue du CommerceLyon69004FranceDelivered$41.34
10252Pascale Cartrain7/8/1996Boulevard Tirou, 255Charleroi6000BelgiumShipped$51.30
10253Carlos Hernández7/1/1996Rua do Paço, 67Rio de Janeiro5454876BrazilCancelled$58.17
10254Yang Wang7/18/1996Hauptstr. 31Bern3012SwitzerlandPending$22.98
10255Antonio Moreno7/7/1996Starenweg 5Genève1204SwitzerlandDelivered$148.33
10256Paula Parente7/10/1996Rua do Mercado, 12Resende8737363BrazilShipped$13.97
10257Michael Holz7/9/1996Carrera 22 con Ave. Carlos SoubletteSan Cristóbal5022VenezuelaDelivered$81.91
10258Roland Mendel7/3/1996Kirchgasse 6Graz8010AustriaCancelled$140.51
10259Francisco Chang7/22/1996Sierras de Granada 9993México D.F.5022MexicoPending$3.25
10260Henriette Pfalzheim7/12/1996Mehrheimerstr. 369Köln50739GermanyDelivered$55.09
10261Bernardo Batista7/15/1996Rua da Panificadora, 12Rio de Janeiro2389673BrazilShipped$3.05
10262Paula Wilson7/8/19962817 Milton Dr.Albuquerque87110USADelivered$48.29

Cell formatting allows you to highlight cell data that appears in the Spreadsheet. It can be enabled or disabled using the allowCellFormatting property.

In this sample, gridlines are hidden using the showGridLines property and the styles are applied using the style property and cellFormat method.

More information about cell formatting 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