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

// Bind a data source
sheet.DataSource = new DataTableSource(myDataTable);

// Add auto filter to column headers
sheet.CreateColumnFilter("A", "E",
    new AutoColumnFilterUI());

// Add data validation
sheet.SetRangeDataValidation("B2:B100",
    new DataValidationAttribute {
        InputType = DataValidationType.Integer,
        MinValue = 1, MaxValue = 100
    });

// 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