Multiple Spreadsheets, One Pattern

[Steve.Briggs]

Hello everyone,

Using the Write to Spreadsheet File.vi I thought it'd be quite simple to create new files with String as my 1d data and Double as my 2d Data.  However, LabVIEW does not seem to like that so at this moment I am ok with reading a premade .xls file with the column headers I'd like and append the 2d Data to that file.  Coming up to massive testing periods, it will become a burden to create multiple files manually when I'm certain there is an easier way for this to be done in LabVIEW.

Here is what I need help with...

Vertical #

V Width

V Location

V Severity

Horizontal #

H Width

H Location

H Severity

Dig #

D Width

D Location

D Severity

...are the 12 column headers I use for my testing (attached file athe.xls).  I'm trying to utilize the spreadsheet functions and use this as my template, and have any files thereafter written with this set .xls file, but not saving over it, simply creating a new file through a prompt.

The next files attached are the .xls files of the data alone, and the data with column headers.

[RavensFan]

Try this.  This creates .csv files which Excel will be able to open.  It is easier to do this then to work with premade and actual .xls files.

Message Edited by Ravens Fan on 03-05-2008 05:02 PM

[smercurio_fc]

What exactly does LabVIEW not like? There should be no issue in using that function to write a new file using the template. See attached for an example using the Write to Spreadsheet File.


Here I used the Read From Spreadsheet File to simulate your 2D data.


Message Edited by smercurio_fc on 03-05-2008 04:04 PM