ReadFilter Question

Topics: Developer Forum
Nov 18, 2008 at 11:13 PM
I want to create a readFilter to ignore the entire row if all the values are empty.  I am not sure how I would do that.  It seems as though only the row and column are available.  I want to do this because the row is returned if there is any formatting on the row even though the cells are empty.

Thank you for creating a great product.
Developer
Nov 18, 2008 at 11:55 PM
The readFilter is probably not what you need for this. It can only be used to filter cells based on cell coordinates.

What you need may instead be setReadDataOnly(true) on the reader. Styles are then ignored, and blank cells will be skipped. Not sure exactly what you are trying to avoid, though.
Nov 19, 2008 at 2:39 AM
Thank you for the quick answer.  I have a multi-worksheet spreadsheet I am reading and not every sheet has data, but they all have formatting which causes the cells to be read.  The setReadDataOnly should work for me.