ExporttoExcel Issue

[Former Member]

Hi,

This is regarding the Export to Excel Application.I have an ExporttoExcel Webdynpro application which will fetch the data from the backend and display in the Excel sheet.But the data fetched from the backend is huge(>65000 records).Excel sheet will not support such huge amounts of data.So when i save the Excel sheet and try to open it, im getting the "XML Import Error". Is there any workaround or alternate solution to avoid this?

Regards,

Padmalatha.K

Points will be rewarded.

[Former Member]

Hi,

Iam using XML to import the data.

Can anyone please explain me how to split the data using the JXL api? Any links related to this?

Regards,

Padmalatha.K

[Former Member]

Hi Padmalatha,

what are using for exporting the content to excel sheet.

Us JXl for exporting this data o excel.

as above mentioned if the data is to split in to sheet using JXL it is very easy.

regards

Sharan

[Former Member]

Hi Padmalatha,

If you are getting a XML parsing error, then check that if the data that you are exporting contains an "&" or "<" or ">" or " ' " characters.

The Excel export Component is sensitive to thse XML Special characters.

Regards,

Alka.

[Former Member]

Hi,

Can you tell me how to split the data into two sheets?

Regards,

Padmalatha.K

[Former Member]

Hi,

Go through this link if you are using POI

http://poi.apache.org/hssf/quick-guide.html#NewSheet

Regards

Ayyapparaj

[Former Member]

Hi,

If you are sure that excel doesnt support this much data then try to split this data to two sheets

As one sheet can have rows= 65536 and cols=256

regards

Ayyapparaj