Header is missing in Excel sheet.

[Former Member]

Hi Everyone,

In my scenario, i need to send the ALV output as excel sheet attachment.There i 'm successful, but the field names are missing in the Excel sheet. So, do we have any standard function module for sending the headers to excile file or we need to hardcode all the field names and append it to the internal table , which we are using it for sending mail?

Thanks & Regards,

Akshay

Edited by: akshay0222 on Dec 23, 2011 12:06 PM

[Former Member]

Hi,

You try to expand the columns and download.

The program which you have coded may be manually the conversion between internal and external units which you shouldn't have done. And the ALV grid tries to convert internal to external units as well at export time and since it was already in external format it lead to an error. For example pieces is 'ST' in internal format and may be 'PC' in external. And you should pass the internal value to the grid.

All The Best.

Warm Regards,

PavanKumar.G

[Former Member]

Hi..,

I think you have to give the headers explicitly..