https://issues.apache.org/bugzilla/show_bug.cgi?id=52660

--- Comment #4 from Sushil Kumar <[email protected]> 2012-02-14 
08:31:38 UTC ---
I am trying to read an excel file (attached) with filter. This excel contains
only one workbook. Without implementing any filter, following records will be
visible - 
Age    Name    Class
1    qq    fgh
2    qq    fgh
3    as    a
4    fr    a
5    gf    a

When we apply filter on workbook on Name column, and select "qq" as filter,
then following records will be visible-
Age    Name    Class
1    qq    fgh
2    qq    fgh

Now, when I am trying to read filtered excel sheet using Apache POI (version
3.7), then my code is able to read all 6 rows (including header). While my
understading was because sheet is filtered, only 3 recodrs should be read by
POI.

The sample code, I am usinf to read attached excel sheet is also attached.

Thanks

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to