Field length shows more in excel sheet which is sent via email

[Former Member]

I am sending excel sheet through email. I have data in internal table which i move to the email internal table and data is been sent via email using a excel sheet.

Now, when I open the excel sheet, i see that all fields get displayed but the last field is shown as too much length meaning field length is 15 chars but in excel sheet it shows as almost 40 - 50 chars.

[Former Member]

Decalre one more field in your internal table ,which should be last field.

and do not pass header for this field and just pass the empty value to this field.

if not use this FM : EXCEL_OLE_STANDARD_DAT

Reward Points if it is helpful

Thanks

Seshu

[Former Member]

solved in alternative way...

[Former Member]

Care to share your resolution?

[Former Member]

as per user requirement added a enter character at the last which has solved the problem.