topic Re: Export to Excel problem in Application Development and Automation Discussions

Export to Excel problem

NunoSilva — Mon, 06 Apr 2009 11:18:38 GMT

Hello,

I am having a very strange problem.

I have an ALV with diferent fields. When i do "Export to File --> Spreadsheet" the first firld is missing the last digit.

Any ideas on why this happens?

Thank you

Nuno Silva

Former Member — Mon, 06 Apr 2009 11:21:32 GMT

check the foll. and correct it accordingly

1. optimize the column widths

2. check its output lengths

3. check its format type

Former Member — Mon, 06 Apr 2009 11:35:08 GMT

Hi Nuno,

you should change the 'Width of Output List', this can be done in SE11 on the selection screen for the table you are working woth.

Regards,

Simon

Former Member — Mon, 06 Apr 2009 11:44:03 GMT

Hi Nuno,

This problem is there for all in currency and date fields.

so down load the file with CSV format and open and try to save as Excel format.

or after down loading the excel format select the column and change the options to Currency.

Regards,

Prabhduas

Former Member — Mon, 06 Apr 2009 12:24:24 GMT

Set:

W_fieldcat-datatype = ' '.
OR.
W_fieldcat-Outputen = ' '.

Hope this resolves your issue.

Regards,

Gurpreet

Former Member — Mon, 06 Apr 2009 16:02:11 GMT

Check the OSS note also as its a know problem data truncated/missing in while transporting to Excel.

Regards,

Atul

Former Member — Sat, 30 May 2009 06:20:56 GMT

Hi,

I have the same problem. when i export ALV to spreadsheet, first coloum doesn't have last digit.

Did u solve ur problem?

if u solve plz tell me

Regards,

Anuradha