LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

simple "data write in spreadsheet excel 95" question

Hello everyone,

I am facing some problems on my program. Please first read the jpg and my vi.

My ideal program is to add a row and a column into the matrix, and then save the output with [2 decimal points] into [excel 95]

Now the program you see is able to add a row and a column into the matrix, and then save the output [only Int] in to txt format

I try to change from %s to %d to %f, all of them give me [Int] only what I can do?
How can I save it in excel 95 format?

Thanks
0 Kudos
Message 1 of 4
(2,640 Views)
0 Kudos
Message 2 of 4
(2,633 Views)
0 Kudos
Message 3 of 4
(2,632 Views)
Just replace the Number to Decimal String function with Number to Fractional String. The decimal function only returns an integer with a specified width, and the fractional returns a fractional string with specifed width and precision.

The correct format string for the Array to Spreadsheet function is %s.
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.1, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
0 Kudos
Message 4 of 4
(2,620 Views)