Spreadsheet / Data Analysis / Sorting

Blazor Spreadsheet Example - Sorting

Loading Syncfusion Blazor Server Demos…

A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN

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

Player Name	Position	Jersey Number	DOB	Club	Appearances	Goals Scored	Assists Provided	Dribbles(per 90 mins)	Interceptions(per 90 mins)	Tackles(per 90 mins)
Caram Williams	Midfielder	63	1993-01-18	Chelsea	4	26	16	3.04	5.84	7.61
Jones Brown	Defender	42	1993-05-17	Manchester City	17	1	0	2.55	8.43	5.94
Smith Johnson	Forward	77	1982-03-16	Liverpool	23	4	2	6.59	0.44	3.46
Lewis Brown	Midfielder	26	1993-10-25	Real Madrid	44	26	20	5.49	5.57	7.49
Caram Lewis	Goalkeeper	56	2002-05-15	Arsenal	33	12	4	4.1	9.61	6.27
Williams Williams	Defender	51	1991-07-02	Chelsea	1	29	11	5.52	9.1	7.51
Anderson Miller	Midfielder	98	1988-11-25	Liverpool	42	4	6	3.01	8.7	6.94
Jones Williams	Defender	96	1980-02-20	Paris Saint-Germain	24	8	13	9.52	3.67	5.28
Jones Lewis	Midfielder	42	1995-02-06	Arsenal	48	18	20	8.1	8.98	2.76
Garcia Brown	Midfielder	63	1980-10-15	Real Madrid	24	2	19	1.45	8.3	8.25
Johnson Brown	Midfielder	27	1997-02-21	Paris Saint-Germain	4	23	5	1.39	6.09	8.51
Anderson Johnson	Midfielder	24	2003-07-24	Liverpool	19	22	17	1.66	7.15	8.2
Caram Williams	Defender	52	1981-07-11	Paris Saint-Germain	45	8	1	4.89	0.52	5.71
Caram Smith	Forward	39	1987-11-19	Barcelona	20	8	15	5.55	6.1	4.36
Caram Jones	Forward	65	1981-04-02	Paris Saint-Germain	17	19	12	3.64	6.02	1.86
Garcia Miller	Midfielder	2	1992-09-18	Liverpool	34	29	6	7.4	8.73	2.06
Garcia Lewis	Midfielder	8	1991-11-14	Chelsea	18	10	19	7.86	0.94	3.56
Caram Miller	Midfielder	23	1983-02-09	Manchester City	23	4	2	8.52	6.55	1.66
Caram Brown	Goalkeeper	20	1987-08-13	Liverpool	25	22	5	8.86	2.24	4.31
Nichols Davis	Forward	13	2000-06-28	Barcelona	45	0	13	5.06	7.61	2.2
Nichols Davis	Forward	41	2005-12-17	Manchester United	5	16	15	0.46	8.28	6.21
Caram Anderson	Goalkeeper	49	1992-04-16	Manchester United	50	6	4	6.45	5.63	3.19
Anderson Johnson	Forward	74	1980-11-15	Manchester United	5	25	5	9.89	4.31	6.4
Smith Anderson	Defender	38	1991-08-07	Manchester United	45	23	11	3.82	1.61	4.41
Smith Williams	Forward	89	1995-01-08	Barcelona	10	12	14	3.69	0.91	8.47
Johnson Lewis	Defender	23	2003-08-25	Arsenal	2	12	15	6.38	7.32	2.78
Smith Lewis	Midfielder	42	2000-04-05	Arsenal	13	29	1	8.41	4.11	2.54
Caram Miller	Defender	27	1983-07-24	Manchester United	46	20	1	9.02	4.04	9.05
Caram Lewis	Defender	91	1984-10-07	Paris Saint-Germain	3	23	12	7.43	4.53	5.5
Lewis Anderson	Forward	33	2000-07-27	Liverpool	20	21	9	6.68	7.3	2.07
Smith Smith	Defender	52	1987-07-26	Juventus	7	11	17	4.12	5.02	4.09
Smith Williams	Forward	14	1986-10-17	Manchester United	15	23	0	7.44	5.06	2.91
Johnson Brown	Defender	36	2001-06-12	Juventus	29	24	5	5.64	6.58	3.26
Nichols Smith	Defender	29	1995-04-14	Manchester United	43	5	7	3.41	2.34	0.9
Caram Smith	Goalkeeper	55	2001-08-20	Arsenal	27	3	6	0.21	2	8.94
Johnson Brown	Forward	74	1998-03-17	Manchester United	43	4	20	1.67	8.82	9.71
Jones Smith	Goalkeeper	97	2003-06-21	Bayern Munich	2	9	0	7.04	1.92	6.13
Williams Anderson	Defender	75	2005-08-07	Chelsea	2	30	6	8.52	8.96	3.7
Johnson Smith	Midfielder	48	2005-10-01	Manchester City	26	14	8	1.19	3.68	7.78
Nichols Davis	Goalkeeper	8	2002-02-23	Arsenal	39	18	13	3.95	4.25	2.84
Johnson Johnson	Midfielder	78	1995-05-07	Juventus	12	27	14	3.89	1.05	8.85
Johnson Davis	Midfielder	18	1990-05-25	Real Madrid	3	8	18	7.74	4.16	9.7
Jones Miller	Midfielder	41	1996-09-10	Manchester City	6	12	0	5.76	2.59	3.46
Anderson Smith	Midfielder	54	1994-04-23	Manchester United	19	30	19	4.14	4.13	9.63
Garcia Anderson	Forward	28	1995-07-11	Manchester City	12	28	3	5.59	7.21	6.3
Nichols Johnson	Midfielder	61	1984-01-06	Liverpool	21	6	3	1.06	4.12	2.01
Caram Williams	Goalkeeper	32	1991-09-17	Chelsea	22	18	0	2.9	8.47	6.88
Nichols Lewis	Goalkeeper	46	1988-11-10	Paris Saint-Germain	10	2	12	8.97	7.98	9.41

This sample demonstrates the sorting capabilities of the Spreadsheet using a football player statistics dataset. It highlights how large datasets can be organized by attributes such as player name, club, appearances, or goals to streamline analysis and comparisons.

The Spreadsheet sorting feature enables you to organize data in a specific order. To enable sorting, set the AllowSorting property to true.

Sorting Data:

Select a cell or range of cells or column containing data
Access sorting options through the Home tab in the ribbon or right-click to open the context menu
Choose Sort Ascending to arrange data from lowest to highest (A to Z, 0 to 9)
Choose Sort Descending to arrange data from highest to lowest (Z to A, 9 to 0)

In this demo, you can sort the player statistics by selecting any column and applying ascending or descending order to analyze the data based on different attributes like goals scored, appearances, or player names.

For more detailed information about Sorting, refer to the Sorting documentation.