08-10-2017 4:05 PM
I am developing a report which we give output in ALV format. The ALV has 140 columns and the number of records can be around 50K or more. So, when processed in background I want to export the ALV records in either XLS or CSV file. But I heard that XLS has a limitation of 50K records. Is there any such limitation on CSV file as well? If yes, what is the limitations?
Please help!!
08-10-2017 4:11 PM
Why don't you just test it? In the time it takes to write your post you could have written the 5 lines of code or so to fill it with 100k or however many lines you're interested in.
08-10-2017 4:58 PM
Hello,
.XLS format is limited to 256 columns and 65k rows.
.CSV format as no rows limits (but a size limit that you will not reach...probably around 2Go, depending on your OS). Note that you can encounter difficulties if you open it with a basic text editor.
If you can, you should try to create .XLSX file or a more simple XML Excel file. You should have a look there : ABAP2XLSX
+-----------------+-----------+--------------+---------------------+
| | Max. Rows | Max. Columns | Max. Cols by letter |
+-----------------+-----------+--------------+---------------------+
| Excel 365* | 1,048,576 | 16,384 | XFD |
| Excel 2013 | 1,048,576 | 16,384 | XFD |
| Excel 2010 | 1,048,576 | 16,384 | XFD |
| Excel 2007 | 1,048,576 | 16,384 | XFD |
| Excel 2003 | 65,536 | 256 | IV |
| Excel 2002 (XP) | 65,536 | 256 | IV |
| Excel 2000 | 65,536 | 256 | IV |
| Excel 97 | 65,536 | 256 | IV |
| Excel 95 | 16,384 | 256 | IV |
| Excel 5 | 16,384 | 256 | IV |
+-----------------+-----------+--------------+---------------------+