puneet kumar
asked on
Create XLSX file in java
my requirement is like generate xlsx file through java where sheet name and sheet data should be dynamically .it should come from data base please let me know if
not clear .
Test Case - one XLSX file generated it contains 3 sheets and some column wise data in all the sheets . sheet name and sheet data should come from database.
not clear .
Test Case - one XLSX file generated it contains 3 sheets and some column wise data in all the sheets . sheet name and sheet data should come from database.
Your best bet is to use the Apache POI.
ASKER
please give some sample code which generate file having dynamic sheets .
Look at the web site I posted, it has several samples: https://poi.apache.org/components/index.html
ASKER
i He generated the file but itt gives error while opening it please refer screenshot .
Error.PNG
Error.PNG
Can you post the code you use?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.