Skip to Content
0
Former Member
Mar 27, 2015 at 02:51 AM

Export to excel in .XLSX format issue

1129 Views

Hello Experts,

Details : NWDS : 7.0.09,JDK 1.4 Portal 7.0 are used

I have used JXl.jar for Export webdynpro table data into excel sheet and it is generated fine but there is an issue in Excel data.

in my table we have nearly 400 columns but in the generated file only 256 columns

Excel generated in Format ".XLS" so columns are limited to 256

Can anyone please guide me How to generate ".XLSX" instead of ".XLS"(To have morethan 256 columns)

Note : in XLSX we have morethan 256 columns

Thanks in advance

Regards,

Fayaz Shaik.