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: 

Output to Excel

Former Member
0 Kudos
254

Hi All,

We have a requirement of downloading output to excel . We created using Excel.Application.

My internal table contains more than 25 fields and also huge data.

It is taking lot of time to upload to Excel. Iam uploading to Excel Cell by cell.

Is there any way to upload quickly or uploading row wise instead of cell wise.

Regards,

Kiran I

1 ACCEPTED SOLUTION

vinod_gunaware2
Active Contributor
0 Kudos
105

RPPC HR/PC interface <b>EXCEL_OLE_STANDARD_DAT </b> Just calls MS_EXCEL_OLE_STANDARD_DAT

SLPC OLE - PC interface <b> MS_EXCEL_OLE_STANDARD_DAT </b> Downloads internal table and opens it in MS Excel.

KCDE Data transfer from PC files <b>KCD_EXCEL_OLE_TO_INT_CONVERT </b> Uploads an *.xls file to internal table (max cell length = 32). Example. This function uses a range selection and copy-paste technique, therefore it quite fast.Q

There is another Example 2 that reads data from Excel file cell by cell.b

ALSMEX FI-AA Legacy Data Transfer w/ Excel <b>ALSM_EXCEL_TO_INTERNAL_TABLE </b> the same as KCD_EXCEL_OLE_TO_INT_CONVERT but max cell length = 50

FTBU_CONV General conversion <b>FTBU_START_EXCEL </b> just [download internal table to file and] start Excel (w/o OLE).

regards

vinod

6 REPLIES 6

guillaume-hrc
Active Contributor
0 Kudos
105

Hi,

Any reason why you are using OLE for this?

Are you performing some formatting on the cells or things like that?

Maybe you should have a look at this weblog.

/people/sergio.ferrari2/blog/2006/06/11/downloading-data-into-excel-with-format-options-from-sap-web-applications

I think it would be faster to format on the ABAP part and simply donwload the file.

Best regards,

Guillaume

Former Member
0 Kudos
105

Hi,

Use FM

MS_EXCEL_OLE_STANDARD_DAT

EXCEL_OLE_STANDARD_DAT

Regards,

Amole

0 Kudos
105

Hi All,

Thanks for the replies.

Can i use those FM for creating different tabs in a one Excel sheet.

With regards,

Kiran I

0 Kudos
105

Hi,

Apart from using XML approach (see the following post: ), I think you are stuck with using OLE for this kind of requirement.

Have a look at the following for an OLE solution :

Best regards,

Guillaume

PS: Please, award points for useful answers and close the thread if solved.

vinod_gunaware2
Active Contributor
0 Kudos
106

RPPC HR/PC interface <b>EXCEL_OLE_STANDARD_DAT </b> Just calls MS_EXCEL_OLE_STANDARD_DAT

SLPC OLE - PC interface <b> MS_EXCEL_OLE_STANDARD_DAT </b> Downloads internal table and opens it in MS Excel.

KCDE Data transfer from PC files <b>KCD_EXCEL_OLE_TO_INT_CONVERT </b> Uploads an *.xls file to internal table (max cell length = 32). Example. This function uses a range selection and copy-paste technique, therefore it quite fast.Q

There is another Example 2 that reads data from Excel file cell by cell.b

ALSMEX FI-AA Legacy Data Transfer w/ Excel <b>ALSM_EXCEL_TO_INTERNAL_TABLE </b> the same as KCD_EXCEL_OLE_TO_INT_CONVERT but max cell length = 50

FTBU_CONV General conversion <b>FTBU_START_EXCEL </b> just [download internal table to file and] start Excel (w/o OLE).

regards

vinod

Former Member
0 Kudos
105

Hi,

You can use the good old FM : GUI_DOWNLOAD, pass the itab and filetype will be 'DAT'. So each field will come in a induvidual cell, this is the simplest approach.