topic Improve Performance while using OLE Object in Application Development and Automation Discussions

Improve Performance while using OLE Object

Former Member — Wed, 04 Nov 2009 11:29:59 GMT

Hi,

I have a report which create the excel through OLE object with coloring options, fonts,wrap text.... But it takes more time to create the excel.

Can anyone tell how to improve the performance while uisng the OLe object?

Thnaks and Regards,

Former Member — Wed, 04 Nov 2009 11:53:41 GMT

Using OLE will be slow. Try using modules in TXXL function group.

former_member189059 — Wed, 25 Nov 2009 04:21:46 GMT

Hello,

OLE will be relatively slow as compared to other options.

But you can do certain things to improve performance such as applying the coloring to a range of cells instead of one cell at a time etc.

Rocky1 — Wed, 25 Nov 2009 04:28:02 GMT

Hi,

Please check the following link:

Hope it will solve your problem.

Thanks & Regards

Rocky