Data export to Excel

[Former Member]

Dear Friends,

I have developed a report using ALV. The report display is coming correctly, but when I export the report to excel, the document number is not getting exported fully. The last digit of the document is missing.

The document number is taken from BSEG table.

The problem is shown below with an example.

Document number displayed in the ALV report : 0713001486

0713001762

0713001873

The data expoted to excel are : 71300148

71300176

71300187

(The last digits are missing in the excel sheet).

Kindly let me know the reason for this problem and guide me with the solution.

<removed by moderator>

TIA.

Regards,

Mark K

Edited by: Thomas Zloch on Nov 4, 2010 1:47 PM

[Clemenss]

Hi Mark,

so many ways to export the report to excel. My way works fine.

Regards,

Clemens

[Former Member]

Dear Clemens,

Could you please let me know the reason and solution for this problem.

Regards,

Mark K

[Former Member]

did you widen the column in Excel to see if the data is there?

[Former Member]

Dear Friend,

I tried by expanding the column in Excel, but still the last digist is missing.

Regards,

Mark K

[_IvanFemia_]

Hi,

try to read these blogs

[abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

[xlsx2abap - Read and edit your Excel files from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20791] [original link is broken] [original link is broken] [original link is broken];

Code of this SCN Community project is shared on [Code Exchange|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Regards

Ivan