Please run Write Table to XL.vi and let me know how long it takes to write a 40*100 array

[IBAHKA]

I am wondering if it is my computer that is slow or is communication between XL and LabVIEW always so slow.

Thanks,

Ivanka

[Dennis_Knutson]

I can tell you communication to Excel is slower than other ways of writing to files. Using Write To Spreadsheet File is faster and doing a binary file write is the fastest. I've looked at your program and I wonder why you need to write your files in Excel format on a continous basis. It would be much faster to use another mthod as the program is running and then if you truly need an Excel format (as opposed to comma or tab separated files that Excel can open), then maybe you should do the Excel conversion as the end when all of your acquisition is complete.

[JenK]

Here is an example that writes a 1D or 2D array to a file. It should be faster than the Write Table to XL.vi that you were using. It takes an array and converts it to a table in string form and then sends this data to a Write Characters to File.vi. You can choose to use Excel to open this file. Let me know if this helps.

Jennifer
National Instruments
www.ni.com/support

[IBAHKA]

Hi Jen,
Thanks for the program. It is extremely Quick ! Do you think it is possible to choose starting location for writing, ei. one B1 in Excel?
Thank-you!
Ivanka

[JenK]

Hi Ivanka,

If you have the Report Generation Toolkit you can choose exactly where you want the data to start in Excel. I've attached an example of how this is done. If you do not have the toolkit it won't be very helpful. In the example that I posted previously (Using Spreadsheet Format.vi) you can append the data to the file by wiring a boolean true to the Write Characters to File.vi. This will append the data to the file if there is existing data that you do not want to overwrite.

If you are interested in the Report Generation Toolkit you can find information about it here:
http://sine.ni.com/apps/we/nioc.vp?cid=5769〈=US

Jennifer
National Instruments
www.ni.com/support