Write string columns to Spreadsheet

[piotrek1349]

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

[Bob_Schor · Accepted solution]

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

[RTSLVU · Accepted solution]

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

[piotrek1349]

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.

[RTSLVU · Accepted solution]

Use a loop

[lodhi33]

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? 

[GerdW]

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…