Excel versus Labview CPU time

[Nick_S]

I have LV 7.1 code that calls up Excel which then formats a spreadsheet nicely.  This is done with a VI inside an event structure within a while loop.

The problem I'm having is LV seems to be using the CPU approx. 99% of the time.  So I have to wait about 2.5 minutes for the Excel formatting to complete.  After formatting completes I can flip between the Excel and LV programs quickly.

Of course running the VI by itself only takes about 5 seconds to complete.

Can anyone tell me if its the event structure, the loop, the VI inside the event structure, or just the way the OS handles both programs at the same time that's causing this bog down?

[unclebump]

Try Tools, Advanced, Profile vi's.

[mfitzsimons]

Are you doing a single call of multiple call to Excel to format the sheet?  LabVIEW uses ActiveX that if you are doing multiple calls could be the issue.  Another way to deal with highly formated Excel would be to precreate a template (*.xlt) and fill in just the data.

Matt