How do I generate an excel report with string and numbers?

[gubobshow]

Hello,
I tried to use "Write To Measurement File". The objective is to write "Pass" or "Fail" in the measured data, in an attempt to make it easy to read the results. So far I've been able to write "0" or "1". I'm using Linux.

[GerdW]

Hi gubobshow,

WriteToMeasurementFile will only write numeric values to your file.

When you want to write "Pass"/"Fail" into your file you should use WriteDelimitedFile instead… (Or use ArrayToSpreadsheetString and WriteTextFile.)

What's the point in using a string to hold a numeric value? Why is this "Pass" local variable a string? (Why do you use local variables here instead of a shift register?)

[Bob_Schor]

An "Excel Report" is a file written in the proprietary format used by Microsoft Excel, and has the extension .xls or .xlsx.  Another file format that LabVIEW supports, the (<tab> or comma) delimited Spreadsheet, with a .csv extension, can be created by the "Write Delimited Spreadsheet" function on the File I/O Palette, or simply by doing the appropriate series of writes to Text Files.

Bob Schor