LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to spreadsheet file modifications...

I would like to change the program from writing the data to a spreadsheet across rows, as it presently does, to down columns in Excel. How do I do that?
 
I have the program attached.
Thanks, I appreciate your help,
Bethany
0 Kudos
Message 1 of 4
(2,694 Views)
Wire a boolean TRUE dagram constant to the 'transpose" input if the "write to spreadheet file".
Message 2 of 4
(2,689 Views)

Thanks! Also, my data was overextending the spreadsheet's limit, how would I cut down on that?? Would I change the frequency (in the program) or do something with the settings somewhere??

Thanks,

Bethany

0 Kudos
Message 3 of 4
(2,670 Views)

Bethany,

One thing that would help with the data amount would be to add some sort of wait function (Wait or Wait Until Next ms Multiple) to your while loop.  This will cause the loop to run less often, giving you less data and freeing up some CPU usage.  You could also build in some sort of upper iteration limit as well that would stop the loop to prevent the overextension.  Hope this helps!

Andy F.

-----------------------------------------------------------------
National Instruments
0 Kudos
Message 4 of 4
(2,652 Views)