download data to excel2007

[Former Member]

Hi, everyone:

How to download data of an internal table to excel2007 with extension .XLSX ?

Thanks.

[Former Member]

You can use abap2xlsx.

This community project is shared on SAP Code Exchange.

Here is the link.

[/people/community.user/blog/2010/07/12/abap2xlsx--generate-your-professional-excel-spreadsheet-from-abap|/people/community.user/blog/2010/07/12/abap2xlsx--generate-your-professional-excel-spreadsheet-from-abap]

[https://cw.sdn.sap.com/cw/groups/abap2xlsx|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

[Former Member]

hi manish,

attaached link is not openend

[former_member244215]

HI...

To download Data from Internal Table you have to go in debugging mode. If the the debugger is in Classic mode then its perfect otherwise change the debugger to classic mode( Debugger=>Switch to classic mode).

In the top you will find a button for Table, Click on the Table button.

Now after that double click on the internal table from ur program of which you want to download data.

Above Breakpoints button you will found a small green button having a right arrow sign, Just click on that.

Enter the path where you want to download ur Excel sheet and hit enter.

The file will be downloaded.

[Venkat_Sesha]

If you are using classic report from the output > goto-> system Menum> List-> save--> local file there you can select spread sheet and download.

from the ALV just select Export button in the ALV toolbar > to spread sheet> Table radio button -->Microsoft Excel

Or else you can do it in debugging also by selecting the internal table and excel and then select the format 2003-2007 format.

Hope this helps,

Thanks ,

Bhargav

[Former Member]

Hi,

Ram.

[Former Member]

Sorry for everyone, I mean how to download internal table data to excel2007 with ABAP code.

[Former Member]

Please check the link Ram has posted you will get the answer.

[Former Member]

I have read the context of like , I can't understand it and it confused me. Can someone give me a fraction of example code pls, thank you very much and thanks for everyone!

[koolspy_ultimate]

hi donnie126

insert this code in your report

  CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      FILENAME = 'c:/EXCEL.DAT'"your desired locatio
      FILETYPE = 'DAT'
    TABLES
      DATA_TAB = it_data."your internal table

[Former Member]

Hi Donnie126,

Did you check the link i gave about abap2xlsx?

It is a separate program/library which can export data from SAP to Excel 2007 format.

Gui_download produce plain text files, whose extension can be set to xls so that the file opens directly in excel.

However, this does not mean that file format is excel.

OLE technique can be used to create .xls format files.

.xlsx is newer format which is probably not yet supported by OLE.

Abap2xlsx is a third-party solution which creates true xlsx files from SAP.

[Former Member]

Hi, Manish Kumar , can you support me how to get abap2xlsx library (it's said to use SAPLink, but I don't know how to use it), and how to use it? thank you very much. There are some problems when I browse some pages of SDN.

[Former Member]

Hi Donnie126

Steps to install SAPlink

[http://wiki.sdn.sap.com/wiki/display/ABAP/SAPlinkUserDocumentation|http://wiki.sdn.sap.com/wiki/display/ABAP/SAPlinkUserDocumentation]

Once SAPlink is installed, you need to install the abap2xlsx nugget (.nugg file is xml format source code which SAPlink will use).

Steps to install abap2xlsx are given in below link.

[https://cw.sdn.sap.com/cw/docs/DOC-137513|https://cw.sdn.sap.com/cw/docs/DOC-137513]

Download links:

[saplink|http://saplink.googlecode.com/files/SAPlink_install-0.1.4.zip]

[abap2xlsx|http://code.google.com/p/saplink/downloads/list]

[Former Member]

Hi, Manish Kumar , The link to abap2xlsx is 'http://code.google.com/p/saplink/downloads/list', there three items: SAPlink_install-0.1.4.zip ZAKE.nugg.zip SAPlink_install-0.1.5alpha.zip. Is ' ZAKE.nugg.zip ' abap2xlsx ? I search 'abap2xlsx' there, but can't find it. I'll try it tonight. Thank you for your warm-hearted supporting again.

Edited by: Donnie126 on Jul 4, 2011 11:37 AM

[Former Member]

You need to download SAPlink_install-0.1.4.zip

This is the recent stable version.

The zip file has abap2xlsx_Daily.nugg file.

[Former Member]

I have downloaded SAPlink_install-0.1.4.zip, it contains three files: COPYING NUGG_SAPLINK-0.1.4.nugg zsaplink_installer.txt. FIle 'abap2xlsx_Daily.nugg' is not there. Thanks a lot.

[Former Member]

Okay. Tutorial links posted above are corrected but abap2xlsx download link is incorrect.

Here is the correct link for latest stable release.

[abap2xlsx|https://cw.sdn.sap.com/cw/releases/21?container=1016]

[Former Member]

Hi, Manish Kumar , thanks for your effective solution, I have solved the problem with your method. And Thanks for everyone for your supporting.

[former_member197696]

hi can u give me some sample code to download itab to excel which u used and worked file.

thanks in advance

SSK