topic Re: Header is missing in Excel sheet. in Application Development and Automation Discussions

Header is missing in Excel sheet.

Former Member — Fri, 23 Dec 2011 11:06:38 GMT

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

Re: Header is missing in Excel sheet.

Former Member — Wed, 28 Dec 2011 06:18:48 GMT

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

Re: Header is missing in Excel sheet.

Former Member — Wed, 28 Dec 2011 08:49:13 GMT

Hi..,

I think you have to give the headers explicitly..