export to excel issue

[Former Member]

Hi All,

I am using export to excel funcationality to display the data. But the number of records is more 65000 which cannot fit into the excel sheet. When I download the excel sheet which has 5000 records also not imported into the excel sheet and its giving xml import error. Can anyone suggest me an alternative solution to overcome this problem.

Points will be rewarded.

Regards,

Subashini

[Former Member]

Hi,

Is there any other option to create a new excel file if the record size is >65000 ?

Regards,

Subashini

[Former Member]

hi,

This can be handled with the JExcelAPI method. I guess you were using the BInary Cache method. Follow the links to get everything in details:

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4210] [original link is broken] [original link is broken] [original link is broken];