Error while exporting ALV to excel?

[bhuvanpaliwal]

Hi Gurus,

I'm stuck at a weird error.

For a particular Z report, when I'm exporting ALV report through Menu List->Export->Spreadsheet, and then selecting "Star Office 8 Calc / OpenOffice.orf 2.0 Calc", what is happening is that, sometimes the ALV downloads, sometimes it gives a dump (INTERNAL_ERROR, i've attached the short dump) and sometimes it gives an error while opening the downloaded excel.

This error comes in OpenOffice, but I'm also unable to open the file in MS Excel.

I'm using  REUSE_ALV_FIELDCATALOG_MERGE for preparing fieldcatalog. Earlier the fieldcatalog was prepared manually, but still the error was coming.

Any suggestions please?

Thanks!

Bhuvan Paliwal

[Former Member]

The normal ods files are binary when opened in Notepad.

ODS exported by SAP is xml internally. It doesn't open in Excel 2010 too.

I think this option will never work.

[bhuvanpaliwal]

Hi Manish,

Thanks for your reply.

Actually, for other reports, this mode of download is working. Infact, for this report also, sometimes it works.

I think the problem is related to the data being displayed, but cannot understand how.

When I reduced some columns from the fieldcatalog, the file got exported correctly.

Thanks

Bhuvan Paliwal

[ThangaPrakash]

Hello Bhuvan.

it is visible in your message that error occurs at row 2 and column 6290106.

If you check in the below link, the limit of columns is Openoffice 2.0 is 256.

OpenOffice Calc - Simple English Wikipedia, the free encyclopedia

So I guess there is some problem during the export to Openoffice 2.0.

Might be there is some delimiter problem which leads to increase in column size.

Please check from this point of view.

Regards,

Thanga

[ThangaPrakash]

Also have you tried the below option.

Regards

TP

[bhuvanpaliwal]

Hi Thanga,

Yes, I've tried that option as well.

The reason this error is puzzling me is that, sometimes the ALV downloads correctly and also opens the file in OpenOffice immediately. When I ran the report again for the second time, for the same selection criteria, and tried to export it to spreadsheet, a short dump occured.

And the third time, the file got exported, but the above openoffice error occured .

This is seriously unfathomable error for me..

Thanks.

[ThangaPrakash]

Hi Bhuvan,

As I mentioned before it is getting a huge number of columns and the openoffice is not having that much column to accommodate. May be you can check during debugging, before download.

I guess there might be some problem in the buffer or memory.

Regards,

Thanga

[Former Member]

Hi Bhuvan,

I had similar problem while downloading excel file from alv.

Hope the below procedure helps you. Try changing the settings in the EXcel.

Thank you,

Regards

Subha