B4J Question jPOI - How do I set and apply a filter and only get the rows affected?


Licensed User
Hi there

I want to be able to apply a filter on a particular column, let's say C and then apply a filter that excludes all blanks on that column and then the rows that I will access are only the ones applicable to that filter?

Is that possible?



Well-Known Member
Licensed User
No it's not possible. Filters in Excel just hide the data visually. That's why if you sum up a column of numbers using the SUM function in Excel and then hide some of the rows using the AutoFilter the the value of the SUM doesn't change. There is a SUBTOTAL function that excludes hidden rows but that effectively just goes down every row including the hidden ones and says if the row is hidden don't include it in the total.