AutoFilter有AddFillColorFilter以及AddFontColorFilter函数,请问如何使用这两个函数对AutoFilter进行筛选,类似office中的无填充以及自动.
Workbook workbook = new Workbook(dir + "example.xlsx");
AutoFilter filter = workbook.Worksheets[0].AutoFilter;
CellsColor color = workbook.CreateCellsColor();
color.Color = Color.Black;
filter.AddFontColorFilter(0, color);
color = workbook.CreateCellsColor();
filter.AddFillColorFilter(0,Aspose.Cells.BackgroundType.None, color, color);
filter.Refresh();
//workbook.Save(dir + "dest.pdf");
workbook.Save(dir + "dest.xlsx");