topic Re: Performance problem in OLE in Application Development and Automation Discussions

Performance problem in OLE

Former Member — Mon, 26 Apr 2010 12:12:46 GMT

Hi All,

I need to display certain text objects and the fields from the master tables based on the different select options entered by the user. Based on the input crieteria, I need to download the information into the differnet sheets of an single excel file. Say for example, if the user enters the FY as 2000 to 2010, I need to generate the single excel file which will contain the 10 different sheets for each FY information. For this, I have used the OLE technology and is working fine But it takes more time for processing and downloading the file especially the user gives more ranges. Already all the performance measures have taken in the program. Is there any other way to achive the above mentioned functionality without compromising on the performance?. Any other technology ? Any other approach?. Please advise .

Thanks,

Selva.

Re: Performance problem in OLE

Former Member — Tue, 27 Apr 2010 16:13:49 GMT

If your data retrieval is efficient, and you're certain it's OLE, consider how OLE is working. I haven't worked with OLE very much, but I think I remember from my Excel to SAP via OLE, that OLE processes every single cell on every single row. If that's true, your program is quite obviously going to run a while for one sheet and a heckuva long time for multiple sheets.

Re: Performance problem in OLE

Former Member — Fri, 30 Apr 2010 04:39:45 GMT

Yes. It writes the data in each and every cell during the run time. We have given the explanation to the customer and they have accepted. Thanks .