ReoGrid includes comprehensive data management features for binding, filtering, validating, and protecting worksheet data. These features work together to build data-driven spreadsheet applications.
Quick Reference
// Load a DataTable
sheet["A1"] = myDataTable;
// Add auto filter to column headers
sheet.CreateColumnFilter("A", "E", 0, AutoColumnFilterUI.DropdownButtonAndPanel);
// Add data validation
sheet.Ranges["B2:B100"].Validator = new NumericValidator("^[0-9]+$");
// Protect the worksheet
sheet.SetSettings(WorksheetSettings.Edit_Readonly, true);
In This Section
- Data Source — Bind .NET DataTable, collections, or custom data sources to worksheets
- Data Filtering — Filter worksheet data programmatically with custom conditions
- Built-in Auto Filter — Excel-style dropdown filters on column headers
- Conditional Filter — Filter rows based on complex logical conditions
- Conditional Styles — Apply styles dynamically based on cell values
- Group & Outline — Row and column grouping with expand/collapse controls
- Data Validation — Validate user input with type, range, and custom rules
- Protection & Locking — Protect worksheets and lock/unlock individual cells