LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel sheet modification in a program.

Solved!
Go to solution

Hi smercurio,

I used  part of your parse.vi and used a simple spread sheet as you have suggested. It worked.

Thanks

 

0 Kudos
Message 11 of 14
(775 Views)

OK... Except that format isn't the same as what you mentioned in your last reply. Your last reply had

 

time
channel 101 channel 102channel 103 ...

 

as column headers. The spreadsheet you attached has something entirely different.

0 Kudos
Message 12 of 14
(771 Views)

Hi smercurio,

Sorry, I have attached the wrong xls file. Here it is.

thanks you.

 

Download All
0 Kudos
Message 13 of 14
(752 Views)

OK. That looks better.

 

A few tips on your VI:

  •  As I indicated before, it's pointless to always initialize and configure and close the instrument each iteration of the loop. Initialize, configure, and close outside of the loop. The only thing you need inside the loop is just the reading part. 
  • The writing of the column headers for the table also does not need to be done each time through the loop.
  • You've hard-coded the writing of the first row, but you have a channel list control. So, is the channel list fixed, or is it user selectable? If it's the latter, then the first row of the output file must match what the channel selection list is. That's the point of the code that creates the column headers for the table indicator. 
0 Kudos
Message 14 of 14
(740 Views)