OLE performance issue

[Former Member]

Hi,

In one of my programs I have used OLE automation to donwload the contents into an EXCEL File.The Program as well as the File is getting downloaded properly. BUt the only issue that is coming is that OLE is taking a lot of time and the performance has reduced.

In my requiremnt I have all the contents in an Internal Table.And I am passing the Values Cell by Cell to the Excel. Is there any way I can directly pass the Table or the Lines. Or can anyone suggest any other way of increasing the Performance.

Thanks in Advance

Arunava

[RichHeilman]

Have you try using the GUI_DOWNLOAD function module or the GUI_DOWNLOAD method of the class CL_GUI_FRONTEND_SERVICES? Behind the scenes, these probably do OLE anyway, but may be faster.

Regards,

Rich Heilman

[Former Member]

Hi Rich,

I think GUI_DOWNLOAD is not an ideal FM to meet my requirement. Because

1. I need Colours

2. There are some Cells having Numbers and they can have leading Zero Which can be done in EXCEL only when the Format is TEXT.And I dont think we can specify the Format of the File in GUI_DOWNLOAD.

Please guide if I am wrong.

Thanks again,

Arunava

[RichHeilman]

No, you are right. You can only do these manipulations with OLE. I really don't think that there is anything that you can do to speed it up. Sorry. How many records are we talking about?

Regards,

Rich Heilman

[Former Member]

Hi Rich,

The Number of Records can be quite large and even in minimal runs the Excel can have around 1000 Row with 18 columns in one Worksheet.

Is passing the Values Cell by Cell to the EXCEL the only way of passing the Internal Table contents.

Also need a help I want to Autofit my Columns. I recoded the Excel MAcro and went to the VBA editor..The Code is

SELECTION.ENTIRECOLUMN.AUTOFIT -- I think It is only an attribute . But CAn we assign any Value( that will force it to autofit). I tried using SET PROPERTY of <ENTRIRECOLUMN> <AUTOFIT> and tried to pass a Value. It doesnt work and the Sy-subrc NE 0.

Can you guide on this Autofit issue.

Thanks again

Arunava