LabVIEW
Excel Easy table.vi returns wrong number format and rounds off.
Solved!
The error message specifies that the error is with Excel Set Cell Format.vi. I would guess your format string is not a valid Excel format.
Ben64
The MS Office Parameters are described in the Help. In particular, the first part is the Excel position of the first cell being written. By default, you start at row 0, column 0, so you can ignore this if you are writing "all at once".
Here I write three times. The first write has a Header. The second write has no header and is positioned right under the first (I increment the End Row and use this as the Row position for the next write). The third write is to the right of the first, leaving a blank row where the Header could go (but I'm not writing a header).
Incidentally, this is a VI Snippet. If you are using LabVIEW 2016 (see upper right corner), you can open a blank Block Diagram, drag this image into it, and it will automagically become LabVIEW Code you can run (you might want to edit the File Path).
Bob Schor
