generate excel in java

3
votes

I want to generate excel with enabling auto-filter option.For that I have create one template excel file by enabling auto-filter option but when I write something into that template excel file auto-filter option disabled again.

Is there any solution to create excel file by enabling auto-filter option.

2
javaexcelapache-poi
As for now, you won't have success with POI, the feature is not implemented yet... see issues.apache.org/bugzilla/show_bug.cgi?id=35125 – Erich Kitzmueller
jexcelapi won't help you either, see andykhan.com/jexcelapi/changehistory.html - they tried to, but couldn't get it to work – Erich Kitzmueller

2 Answers

2
votes

Not sure if this is what you are looking for (and you don't really describe how you write the file today). "create excel file by enabling auto-filter option" doesn't really make sense to me.

There is the Apache POI that I have used for generating excel files and it works pretty well. Is that was you are using to write excel files today?

0
votes

I'd have a look at Andy Khan's JExcel. I think it's the best library out there for working with Excel in Java.