The data filter on excel works flawlessly but is there a way to ignore case during filter?.
The code that I am using to filter excel data is as below:
// completeBook is my workbook AutoFilter autoFilter = completeBook.getWorksheets().get(0).getAutoFilter(); int maxColRange = completeBook.getWorksheets().get(0).getCells().getMaxDataColumn(); autoFilter.setRange("A1:" + CellsHelper.columnIndexToName(maxColRange) + "1"); int columnIndex = //some column index String pattern= //is some filter string. **autoFilter.filter(columnIndex, pattern);** // I wish to make this filter case insensitive. autoFilter.refresh(); workbook.save("someFileName");
The highlighted line above filters the data based on the pattern string, but this is case sensitive filter. I need something to make it ignore the case and filter the column.
Any pointers is much appreciated.