V4 V5

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

Was this article helpful?