topic Internal table to EXCEL in Application Development and Automation Discussions

Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 05:59:45 GMT

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.

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 06:02:18 GMT

Go through the link given below :

With Regards

Nikunj Shah

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 06:02:22 GMT

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.

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 06:02:24 GMT

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

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 06:09:50 GMT

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

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 07:49:31 GMT

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

Re: Internal table to EXCEL

Former Member — Mon, 11 Aug 2008 08:20:40 GMT

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