/**
* POI AutoFilter.getFilterColumn(i) sometimes returns null. A POI FilterColumn object only exists
* when we have set a criteria on that column. For example, if we enable auto filter on 2 columns,
* but we only set criteria on 2nd column. Thus, the size of filter column is 1. There is only one
* FilterColumn object and its column id is 1. Only getFilterColumn(1) will return a FilterColumn,
* other get null.
*
* @param poiSheet source POI sheet
* @param sheet destination sheet
*/
protected void importAutoFilter(Sheet poiSheet, SSheet sheet) {
AutoFilter poiAutoFilter = poiSheet.getAutoFilter();
if (poiAutoFilter != null) {
CellRangeAddress filteringRange = poiAutoFilter.getRangeAddress();
SAutoFilter autoFilter =
sheet.createAutoFilter(new CellRegion(filteringRange.formatAsString()));
int numberOfColumn = filteringRange.getLastColumn() - filteringRange.getFirstColumn() + 1;
importAutoFilterColumns(poiAutoFilter, autoFilter, numberOfColumn); // ZSS-1019
}
}
public static void main(String[] args) throws Exception {
// The path to the documents directory.
String dataDir = Utils.getDataDir(AutofilterData.class);
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xls");
// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
// Creating AutoFilter by giving the cells range
AutoFilter autoFilter = worksheet.getAutoFilter();
CellArea area = new CellArea();
autoFilter.setRange("A1:B1");
// Saving the modified Excel file
workbook.save(dataDir + "output.xls");
// Print message
System.out.println("Process completed successfully");
}
// ZSS-1019
protected void importAutoFilterColumns(
AutoFilter poiFilter, SAutoFilter zssFilter, int numberOfColumn) {
for (int i = 0; i < numberOfColumn; i++) {
FilterColumn srcColumn = poiFilter.getFilterColumn(i);
if (srcColumn == null) {
continue;
}
NFilterColumn destColumn = zssFilter.getFilterColumn(i, true);
destColumn.setProperties(
PoiEnumConversion.toFilterOperator(srcColumn.getOperator()),
srcColumn.getCriteria1(),
srcColumn.getCriteria2(),
srcColumn.isOn());
}
}
