topic Data export to Excel in Application Development and Automation Discussions

Data export to Excel

Former Member — Thu, 04 Nov 2010 11:57:53 GMT

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.

TIA.

Regards,

Mark K

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

Re: Data export to Excel

Clemenss — Thu, 04 Nov 2010 13:19:48 GMT

Hi Mark,

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

Regards,

Clemens

Re: Data export to Excel

Former Member — Thu, 04 Nov 2010 13:30:27 GMT

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

Re: Data export to Excel

Former Member — Tue, 09 Nov 2010 05:47:33 GMT

Dear Friend,

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

Regards,

Mark K

Re: Data export to Excel

Former Member — Tue, 09 Nov 2010 05:55:34 GMT

Dear Clemens,

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

Regards,

Mark K

Re: Data export to Excel

_IvanFemia_ — Tue, 09 Nov 2010 22:59:07 GMT

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