Output to Excel

[Former Member]

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

[guillaume-hrc]

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]

Hi,

Use FM

MS_EXCEL_OLE_STANDARD_DAT

EXCEL_OLE_STANDARD_DAT

Regards,

Amole

[Former Member]

Hi All,

Thanks for the replies.

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

With regards,

Kiran I

[guillaume-hrc]

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]

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]

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.