Improve Performance while using OLE Object

[Former Member]

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,

RS

[Former Member]

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

[former_member189059]

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]

Hi,

Please check the following link:

Hope it will solve your problem.

Thanks & Regards

Rocky