autofilter – Tarik Billa

ShowAllData method of Worksheet class failed

July 17, 2023 by Tarik

AutoFilterMode will be True if engaged, regardless of whether there is actually a filter applied to a specific column or not. When this happens, ActiveSheet.ShowAllData will still run, throwing an error (because there is no actual filtering). I had the same issue and got it working with If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then ActiveSheet.ShowAllData … Read more

Setting filter on headers of an Excel sheet via POI

April 15, 2023 by Tarik

Save the first and last cell from filter area, and execute: sheet.setAutoFilter(new CellRangeAddress(firstCell.getRow(), lastCell.getRow(), firstCell.getCol(), lastCell.getCol())); For example, from the below sheet. >x (x, y) 0123456 0|–hhh–| h = header 1|–+++–| + = values 2|–+++–| – = empty fields 3|–+++–| 4|——-| first cell will be the header above the first + (2,1) cell. The last … Read more