GrapeCity.Documents.Excel.IWorksheet.ShowAllData

ShowAllData Method

ShowAllData()

Makes all rows in the currently filtered range visible.

If AutoFilter is in use on the worksheet, this method clears the applied filter criteria and changes the filter drop-down arrows to show All.

Declaration

void ShowAllData()

Sub ShowAllData()

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200},
    {"C", 120}
});
worksheet.Range["A1:B4"].AutoFilter(1, "<150");
worksheet.ShowAllData();