Blazor Spreadsheet Example - Filtering

Spreadsheet / Data Analysis / Filtering

This sample demonstrates the filtering capabilities of the Blazor Spreadsheet component. Filtering helps you work with large datasets by showing only the rows that match specific criteria. This allows you to focus on relevant data without changing or deleting any original content.

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

Employee ID	Employee Name	Gender	Title	Birth Date	Sick Leave Hours	Salary
1001	Teresa Atkinson	Male	Engineering Manager	19-May-15	34	$5,074.93
1002	Mae Anderson	Male	Production Technician - WC45	17-Mar-13	58	$796.33
1003	Ronald Adina	Female	Information Services Manager	21-Mar-05	37	$173.32
1004	Chris Ashton	Female	Production Technician - WC50	27-Jul-14	28	$4,023.98
1005	Kim Akers	Male	Production Supervisor - WC50	22-Aug-11	68	$174.82
1006	Marvin Allen	Male	Production Technician - WC50	8-Aug-13	38	$3,543.86
1007	Francois Ferrier	Male	Shipping and Receiving Clerk	14-Jan-12	49	$3,703.02
1008	James Aguilar	Female	Human Resources Manager	15-Oct-10	31	$1,267.38
1009	Francois Ferrier	Male	Recruiter	6-Oct-10	40	$5,232.68
1010	Sabria Appelbaum	Male	Marketing Assistant	17-Jan-15	34	$529.39
1011	Stephen Ayers	Male	Tool Designer	15-Apr-05	51	$1,794.18
1012	Cecil Allison	Male	Production Technician - WC50	12-Mar-12	25	$3,136.16
1013	Phyllis Allen	Male	Senior Tool Designer	25-Apr-11	55	$3,282.42
1014	Phyllis Allen	Male	Production Technician - WC45	20-Jun-07	45	$670.53
1015	Carla Adams	Male	Tool Designer	7-Jun-11	64	$1,324.21
1016	Stephen Ayers	Male	Production Technician - WC45	22-Apr-12	50	$4,870.75
1017	Margar Smith	Male	Production Technician - WC40	22-Jul-11	56	$3,330.69
1018	Kim Abercrombie	Male	Senior Tool Designer	13-Jan-10	59	$2,285.87
1019	Frances Adams	Female	Engineering Manager	18-May-12	18	$4,784.37
1020	Pilar Ackerman	Male	Tool Designer	1-Jun-12	25	$1,469.76
1021	Emilio Alvaro	Female	Production Technician - WC50	27-Sep-05	45	$5,098.06
1022	Robert Ahlering	Male	Marketing Assistant	12-Mar-15	22	$21.34
1023	Amy Alberts	Male	Production Supervisor - WC60	26-Sep-11	39	$5,867.29
1024	John Ault	Male	Production Technician - WC50	2-Aug-13	18	$3,150.02
1025	Thomas Armstrong	Female	Production Technician - WC10	22-Oct-09	46	$3,672.40
1026	Maxwell Amland	Male	Production Technician - WC50	4-Jul-14	48	$1,024.35
1027	Ronald Adina	Female	Production Technician - WC50	16-Oct-09	41	$1,383.62
1028	Mae Anderson	Male	Human Resources Manager	22-Jan-12	22	$4,135.96
1029	Robert Avalos	Male	Production Technician - WC40	20-Feb-09	21	$99.04
1030	Phillip Bacalzo	Male	Production Technician - WC45	16-Nov-11	34	$1,693.53
1031	Phillip Bacalzo	Male	Senior Tool Designer	17-Mar-12	49	$4,572.03
1032	Tom Johnston	Female	Production Technician - WC10	24-Mar-08	48	$2,283.47
1033	Marvin Allen	Male	Production Control Manager	7-Jun-06	18	$5,845.36
1034	Michelle Alexander	Male	Production Technician - WC50	25-Feb-09	29	$3,741.86
1035	Ramona Antrim	Female	Vice President of Engineering	14-Sep-07	41	$4,938.14
1036	Milton Albury	Male	Tool Designer	23-Jun-05	58	$3,682.91
1037	Gregory Alderson	Male	Production Technician - WC40	7-Feb-12	56	$1,509.68
1038	Robert Ahlering	Male	Stocker	7-Aug-08	48	$2,384.37
1039	Amy Alberts	Male	Engineering Manager	11-Jul-15	49	$3,318.03
1040	Kim Akers	Male	Production Supervisor - WC50	2-Feb-12	42	$669.70
1041	Marvin Allen	Male	Production Supervisor - WC10	16-May-06	39	$34.57
1042	Kim Abercrombie	Male	Production Technician - WC30	4-Sep-12	24	$3,794.59
1043	Ramona Antrim	Female	Production Technician - WC10	24-Sep-14	68	$2,991.18
1044	John Ault	Male	Production Technician - WC40	2-Nov-11	20	$4,049.52
1045	Pilar Ackerman	Male	Production Supervisor - WC60	14-Sep-08	16	$1,529.45
1046	Selena Alvarad	Female	Production Technician - WC10	26-Nov-12	55	$4,006.57
1047	John Ault	Male	Production Technician - WC45	17-Oct-10	31	$1,058.49
1048	Chris Ashton	Female	Stocker	24-Aug-09	16	$2,862.37

In this sample, you can apply filters using the Filter option in the ribbon or by right-clicking a cell and selecting Filter from the context menu. Filter icons appear in column headers to indicate active filters. You can easily clear individual filters or remove all filters to view the complete dataset again.

More information on the Blazor Spreadsheet can be found in this documentation section.