Export to Excel from ALV (columns come on second line)
my ALV report contains 76 columns, if i try to download it in an excel sheel its not getting displayed in correct format.
Few columns are automatically displayed in the second row and also all my values are getting collapsed due to this display.
In the print preview also i am getting the same problem.
Is there any column limit in ALV display or i can make it to get display correctly as it is in the exact output.
ALv reports contain various options such as sort,filter,print preview, download to excel etc....in this if i use the download to excel option in the excel sheet its getting displayed as col1,col2,col3.......col54
col55,col56.................col75 but i need the output to be in a single line such as col1,col2,col3,.........col75