Skip to Content
Former Member
Feb 29, 2016 at 04:51 PM

Excel file size when download to Local File from ALV



An issue was founded in ALV GRID when user exports the data to Excel file via Local File button (Local File -> Spreadsheet) or via List menu (List -> Export -> Local File -> Spreadsheet). The problem in local file is a line break occurs and moves 1 row in ALV into 2 rows in Excel.

There is some discussions about this situation in SCN, and some SAP related notes like 855314 - Downloading a list from the ALV to Excel that explain this issue, but is not a fixed rule because this happens sporadically, (when the local file size grow up than 7 MB, and others).

Other issue is when you download the data from internal table of the ALV in debugging session (Tools -> Save Local File -> Spreadsheet), the file size is 1/3 of the file size when you download the file after shown the ALV data, via button or List menu (3,3 MB vs. 9,7 MB).

Anybody knows the reason of the size difference between debugging file and alv file?

Anybody knows the size limit of the excel files downloaded from ALV until the line break?

Thanks and regards.