From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
05-09-2016 09:19 AM
Hi,
I have problem.
I have a device which generates 3 data, eg. voltage, current, frequency.
When I run the program, all values are put under him, but I would like to were in the 3 columns.
For example:
Voltage Current Frequency
2 1 5
4 4 5
5 3 6
The second problem is related when i run program continously. Values are not added to the column but overwritten.
What do I need to change the program to act as my premise?
Regards
Solved! Go to Solution.
05-09-2016 09:27 AM
Don't use Save Spreadsheet String, but use the Write Delimited Spreadsheet function from the File I/O Palette. Incidentally, I hope you realize that "Spreadsheet" in "LabVIEW-Speak" means "A text file where data are arranged in rows (with New Lines) and columns (with some to-be-specified separator character). It does not mean "An Excel .xls or .xlsx file".
Bob Schor
05-09-2016 09:42 AM
Yer doin' it wrong...
First write your column headers to the file ONCE at the beginning.
Then write your numeric values in ROWS as a single demention array
05-09-2016 10:05 AM
Ok,
First problem solved:) Thanks!
But,
How to add next values to the spreadsheet when i run program continously?
At this moment the values are overwritten.
05-09-2016 10:22 AM
Use a loop
11-02-2020 08:27 PM
how are you writing your row of strings in the first array?
I do not understand where you get that string format of many columns from?
11-03-2020 01:59 AM
Hi lodhi,
@lodhi33 wrote:
I do not understand where you get that string format of many columns from?
When you write "columns" you should think of "array"!
Use a string array constant…