Speeding Up Load Array From Excel subVI

[Chris Johnson]

Hi there,

I've got a subVI that loads a 2D double array from an Excel file. Currently, it needs about 500ms between runs to not cause a variant error, something to do with getting everything opened and closed. I was wondering if anybody could see anything obvious that's slowing it down. If you could help me optimise this a little that would be great. Even if I could shave it down to 200ms.

[Chris Johnson]

Sorry,

forgot to attach the subVi.

[vt92]

What do you mean "between runs?".  Are you running this subVI multiple times?  If so, you should open the app reference outside the subvi and leave the reference open between runs (and don't quit Excel). 

[Chris Johnson]

I pass an array of filenames into the subVI. It might contain 1, or it may contain 10. So I don't know whether or not I'll need to run it multiple times.

[vt92 · Accepted solution]

Here is a quick example of what I'm talking about.  Placing the App reference open/close outside the loop gets you down to around 300 ms.

[Chris Johnson]

Hey, sorry to be a pain, for some reason I can't download that file, something to do with my network I'm sure. Any chance you could email it to me? chris84948@gmail.com

Thanks

[Chris Johnson]

That worked great. Now the total cycle time is down to about 300ms. I was worried that if everytime I added a new file to the array we would add 500ms, I would be taking 5-10 seconds on a larger recipe setup.

Thanks again.