Hi there,
I am currently using POI-HSSF (
POI-HSSF - Java API To Access Microsoft Excel Format Files) to get access to Excel files and manipulate them. Now I have to get all cells of a Worksheet, which are selected by the autofilter. Unfortunately, I cant find a way to get access to the autofilter. I already searched for it but all I found were problems, in which the autofilter caused a lot of exceptions.
Is someone using POI here and can help for me somehow? I just currently read about JExcel. Is this more sophisticated than POI? And is the access to Autofilter possible?
Would be nice if somebody could give me a hand. Thanks!
Nefarius