• DR-IT Software
  • Products
  • Documentation
  • Product page
  • Examples
  • API reference
  • Support

Filter

Output: Filter.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];
    worksheet.Columns[0].WidthCharacters = 15;

    worksheet["A1"].Value = "Column A";
    worksheet["A2"].Value = "ABC";
    worksheet["A3"].Value = "BCD";
    worksheet["A4"].Value = "CDE";
    worksheet["A5"].Value = "DEF";

    worksheet["A7"].Value = "ABC";
    worksheet["A8"].Value = "BCD";

    worksheet.Filter("A1:A8").Values(0,true, "ABC","DEF");
    workbook.SaveAs("Filter.xlsx");
}
  • Improve this Doc
Back to top

DR-IT Software documentation

DR-IT Software · Products · Documentation index · Product page · Downloads · Support · Licensing

Generated by DocFX