topic Re: Error while exporting ALV to excel? in Application Development and Automation Discussions

Error while exporting ALV to excel?

bhuvanpaliwal — Tue, 04 Mar 2014 07:01:41 GMT

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

Re: Error while exporting ALV to excel?

Former Member — Tue, 04 Mar 2014 07:36:25 GMT

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.

Re: Error while exporting ALV to excel?

bhuvanpaliwal — Tue, 04 Mar 2014 11:18:41 GMT

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

Re: Error while exporting ALV to excel?

ThangaPrakash — Tue, 04 Mar 2014 12:26:34 GMT

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

Re: Error while exporting ALV to excel?

ThangaPrakash — Tue, 04 Mar 2014 12:31:45 GMT

Also have you tried the below option.

Regards

Re: Error while exporting ALV to excel?

bhuvanpaliwal — Thu, 06 Mar 2014 06:47:31 GMT

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.

Re: Error while exporting ALV to excel?

Former Member — Thu, 06 Mar 2014 07:02:57 GMT

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

Re: Error while exporting ALV to excel?

ThangaPrakash — Thu, 06 Mar 2014 16:06:59 GMT

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