Writing to Excel file is very slow. How can I speed this VI up?

[MikeS81]

Hi Kirit,

yes please clarify. What do you try to do?

Mike

[Eric1977]

Old thread revival time! I seem to be having the same issue as the orignal poster. Each time I use the Excel Easy Text item, it bogs my program to a crawl. Can I use a 1D array to acheve the same thing by using the Eas Text function?

[Kira_T]

Hey Eric,

Yes you should be able to create a 1-D array then push that whole array to the Excel and only use that function once, thus speeding up your program.

Kira T

Applications Engineer

[Eric1977]

OK thanks.

I tired to do that and I get an error because it expects a string and I am sending an array to it. I apologize for my ignornace. I am a novice when using the Report Generation Tools as I haven't used it at all.

[Aldo_A]

Hi,

sounds like you might need to typecast what you are feeding to your Excel Easy Text vi. You can take a look at the examples given in the Report Generation Toolkit manual http://www.ni.com/pdf/labview/us/report_generation_toolkit.pdf You may want to take a close look at the "Advanced Operations and Formatting" section where it implements string concatenation and array string/number conversions.

If you are still having the same issue, post back with your code so we can take another swing at it. Thanks!

[Eric1977]

I can't seem to figure this out....

[GerdW]

Hi Eric,

open the context help and move the mouse over the red cross on the wire to "figure it out".

[Eric1977]

I believe I have figured it out, but I need to test it.

I've placed the array in the Array to Spreadsheet function and then placed the output to the Excel Easy Text vi.

[Eric1977]

All,

SUCCESS!!! But...while I have gotten the code to work, it appears that when the data is placed in the Excel file, the data is condensed to one cell and not the cells within the workbook. Is there something that I am doing incorrectly?

[Ryan-C]

Hi Eric,

There's a good example in the Example Finder called "Excel Macro Example.vi".  Does this help?

Thanks!

Ryan