Created attachment 28326 [details] test excel sheet with auto filter. I have filtered some rows.
Please explain what is wrong with POI: post sample code you are using, what you expect and what is the actual result. Also, please try with the latest POI 3.8-beta5. Many bugs have been fixed since POI-3.7, involving support for auto-filters. Yegor
Created attachment 28327 [details] Testing excel sheet
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
Created attachment 28328 [details] Java sample code
As far as I understood how POI handles auto-filter-settings is that it will allow to read/write the settings, i.e. enable or disable auto-filters, but it will not apply those auto-filters on the data when you are using POI as you still will need to work on all data-items usually. The filtering is only applied in Excel when visualizing the content, things like formulas et.al. still use all rows, so POI also needs to.