Skip to Content
0
Former Member
Apr 27, 2009 at 01:22 PM

Exporting data from ALV to Excel...

32 Views

Hi All,

I am trying to export report to Excel with ALV Excel option on status bar, it works fine for 3 months data with 80 columns in the report. But when I run the report for one year data then report displays data fine in R/3 but when I download to Excel it's empty. The eroor is Dataset can't be processed by Excel.

Then I tried with option Download ->Local file->spreadsheet. which doesn't save headers in it. And colums coming in two lines But user wants all columns with header if i do with this option it's not pulling headers.

Please let me know if anybody had the same issue and came up with solution. That would be really great!

Thank you.