LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Saving Raw Sweep Data and Summary Parametric Data in Same file

Lay On, McDuff!  I definitely agree that breaking the Write Delimited Spreadsheet VI into a simpler series of Text Writes (which follow the "normal" convention of writing to the end of an open file, so you don't need the lower Boolean Shift Register and the silliness of opening and closing the file each time the While loop loops) makes more sense.  I was just trying to duplicate Gregory's RGT/Excel example using Write Delimited Spreadsheet just to show "what's possible" ...

 

Bob Schor

0 Kudos
Message 11 of 15
(515 Views)

@Bob_Schor

 

I don't like the Write Delimited Spreadsheet VI because there is always a buffer copy no matter what. Nothing against your VI, I thought it was a good example.

 

"Lay On", is that upsate New York vernacular? Smiley Wink

 

mcduff

0 Kudos
Message 12 of 15
(503 Views)

@mcduff wrote:

"Lay On", is that upsate New York vernacular? Smiley Wink

 

mcduff


Nope, that's a phrase I learned as a junior in my (California) high school English class (I know McDuff gets it ...)

 

BS

0 Kudos
Message 13 of 15
(499 Views)

I had a similar problem with 20 columns of 5000 points of data.  Every point had to be corrected by a simple formula. 

 

I choose the multi-tab Excel file for my solution.  The data was written directly to the first tab.  The second tab contained just one row of the correction formulas.  A simple Excel macro expanded the formulas to match the number of rows on the first tab when the file was first opened.  The data files consumed the least amount of space until opened.


Excel Auto_Open
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
0 Kudos
Message 14 of 15
(487 Views)

@Bob_Schor wrote:

@mcduff wrote:

"Lay On", is that upsate New York vernacular? Smiley Wink

 

mcduff


Nope, that's a phrase I learned as a junior in my (California) high school English class (I know McDuff gets it ...)

 

BS


Sigh -- never so stupid as when trying to look smart!  The correct phrase is "Lay on, Macduff", from Shakespeare's "Macbeth".

 

BS

0 Kudos
Message 15 of 15
(481 Views)