topic Export ALv Output in Excel in Application Development and Automation Discussions

Export ALv Output in Excel

Former Member — Tue, 08 Oct 2013 05:05:08 GMT

Hi all,

I am facing problem while exporting ALV output in excel sheet,,,,,,i have around 300 above record but when i do export->local file->spreadsheet->.xls

then i am getting near about 100 records only.....please let me know if there is any restriction that i have to remove for the same

Regards,

Deepak kansal.

Re: Export ALv Output in Excel

Former Member — Tue, 08 Oct 2013 05:54:36 GMT

No, alv can export upto 65536 rows and 256 columns.

Check SAP Note 700206.:

Increased the Max Size Limit to 65536 rows and 256 columns. For Table and Pivot Table option of Excel Export. This change is available for office integration technology only and no adaption is possible to old SAP

Macros. Import the relevant ABAP patch.

NOTE: If you Export a Large list object there could be a performance problem and the same will be dirctly proportional to the amount of DATA (size of list object) Exported. The Maximum limits with XXL Export: Number of Rows - 65536. Number of Columns - 256. Size of individual cell - 255 Characters.

This problem can occur, if you certain fields have any special character. Check the description and other character fields for any special characters in the output table.

Re: Export ALv Output in Excel

Former Member — Tue, 08 Oct 2013 06:07:06 GMT

Can you check downloading as a text file..

Re: Export ALv Output in Excel

Former Member — Tue, 08 Oct 2013 06:21:34 GMT

Hi Deepak,

Check this 1854956 - Common issue with Export to excel

As per your Case # 11. Export to Excel generate a very big file

Regard's

Smruti

Re: Export ALv Output in Excel

RaymondGiuseppi — Tue, 08 Oct 2013 06:34:39 GMT

If you do not specify either the version of SAP or the version of Excel, I am afraid I can supply only very general information.

As Susmitha suggested, look for OSS notes relative to your version. Start with Note 1517329 - ALV Spreadsheet Export: Format Overview and its attachments Overview_Export_Formats.pdf and Compatibility_Format_vs_Appl.pdf, or Note 1178857 - Additional information: Export to Excel functions.

Look also for SAP Knowledge Base Article like 1854956 - Common issue with Export to excel mentioned by Smruti.

Also insure you already executed every basic control of your ALV like the Consistency Check.

Regards,

Raymond