tian_rose wrote:
Hello gurus
I met a critical performance issue in calling
methods/properties of Excel.Application(ActiveXObject) for
creating excel files in a Curl applet.
The first thing you should do is to run this using the profiling tool in
the Pro IDE. This should tell you were the time is being spent. If you
don't find the explanation in your own code, then you should save the
profile output using "Save As" from the File menu of the Profile Viewer
and send the file to [EMAIL PROTECTED] so we can take a look at it.
- Christopher
This applet is converted from a Visual Basic(6.0)
application, so the methods/properties used by the Curl
applet is completely the same with the original VB
application.
With the VB application, creating the xls file costs about
twenty seconds, while in Curl, creating the same xls file
(containing the same data, the same formatted style) costs
about 120 seconds.
So, calling methods/properties in Curl applet used about
six times long time comparing with the VB application.
Attached files are copied from the project codes in VB and
Curl accordingly.
Note the two applications in VB and Curl are identical in
the meaning of function and codes logic.
Codes in attached files are called in a for loop of
another method/sub.
Also note that it has been proved that procs like
Variant-to-Boolean, vb-var-diff are not related with this
performance issue.
Does anyone know any reason about this big difference ?
Are there any way to accelerate my Curl applet on
outputting excel files with Excel.Application
ActiveXObject ?
The attached files are encoded in utf-8.
Thank you.
