Internal table to EXCEL

[Former Member]

Hi all,

I need to down load data from internal table to anExcel sheet.Presently Iam using GUI_DOWNLOAD which stores all the data ina Excel sheet in a specified file path.I want the Excel sheet to be opened as well, after executing the Function Module.

Thanks in advance,

Chandra Sekhar.

[Former Member]

Hi all,

I need to down load data from internal table to anExcel sheet.Presently Iam using GUI_DOWNLOAD which stores all the data ina Excel sheet in a specified file path.I want the Excel sheet to be opened as well, after executing the Function Module.

Thanks in advance,

Chandra Sekhar.

[Former Member]

Hi

Go through the link given below :

With Regards

Nikunj Shah

[Former Member]

Hi,

1. We can use the FM

GUI_RUN

2. In the command parameter, just give

the full name with path of the excel file.

eg. D:\abc.xls

3. The system will AUTOMATICALLY open the file

in excel.

regards,

amit m.

[Former Member]

Hi,

Gothrough the following links,

https://forums.sdn.sap.com/click.jspa?searchID=15033828&messageID=4606271

https://forums.sdn.sap.com/click.jspa?searchID=15033828&messageID=2029334

Regards,

Harish

[Former Member]

hiii

you can use

CALL FUNCTION 'WS_EXECUTE'

EXPORTING

INFORM = 'X'

PROGRAM = 'EXCEL'

COMMANDLINE = 'C:\EXCEL.XLS'.

if this is absolute then you cna use GUI_RUN FM.

regards

twinkal

[Former Member]

Hi,

Try using FM 'SAP_CONVERT_TO_XLS_FORMAT'. this can be used to download internal table to presentation server xls file. Provide the file address and internal table in the parameters.

Hope this solves your problem.

Thanks,

Hitesh

[Former Member]

All the methods listed above will work through your program

a) Downloading the file, then

b) Starting Excel and directing it to open the file.

A far different approach is to use OLE where by the ABAP program drives excel.

For Example:

1) Attach Excel to ABAP

2) Set Visible property

3) Get Workbooks property

4) Add a new workbook

5) Get active workbook properties

6) Loop through internal table and set cell values and properties

It is also possible with OLE to generate graphs after the data has been exported to excel.

I have a complete set of library routines for doing these functions.

Cheers

David Cooper