Writing single data type of sppeciif bits to excel

[Jaspal]

Hi,

I want to write a number of arrays to an excel file when the user chooses to. I want one of the arrays to specifically output a single data type and two digits after the decimal point.Currently I am using the express VI and when I connect teh data lines, they are converted ot dynamic data type.

If this cannot be achieved using express VI, how would it be done?

Thanks

[GregFreeman]

---

Jaspal wrote:

Hi,

I want to write a number of arrays to an excel file when the user chooses to. I want one of the arrays to specifically output a single data type and two digits after the decimal point.

---

I believe when data is written to a file you have to write as a string...do you mean convert it to a string with two decimal points first then write it?

Message Edited by for(imstuck) on 11-05-2009 11:34 AM

[smercurio_fc]

You should be aware that Write to Measurement File does not create an Excel file. It creates either a text file or a binary file. The text file will have tab delimited data so you could open it with Excel, but it's still just a text file. Thus, instead of using the Write to Measurement File and taking the dynamic data detour, I would suggest simply using the Write to Spreadsheet File. This also produces a delimited text file, but doesn't go the dynamic data route. You can specify the formatting for the data if you need to.