Problem while downloadind data from ALV in excel format.
I have developed one ALV Report.
it have 53 columns. when i tried to download it in excel format using standard functionality, all columns are not coming in one line i.e 50 cloumns in one line and rest columns to the next line.
Row 1 Header-> Fld1 Fld2 Fld3 Fld4 Fld5
Row 2 Values-> Val1 Val2 Val3 Val4 Val5
how i will get all these 53 columns in one line in EXCEL..
Usefull answer will be rewarded...