Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Internal table to EXCEL

Former Member
0 Kudos

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.

6 REPLIES 6

Former Member
0 Kudos

Hi

Go through the link given below :

With Regards

Nikunj Shah

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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