recording in 3 cells of the excel file

[Monireh]

Hello,

 I am trying to measure some physical quantity and record them day by day into an Excel file and I want to display the recorded data with their corresponding date and time in the Excel file within 3 different cells but my program displays the recorded data with their corresponding date and time in 1 cell of the excel file; I was wondering if you can please help me in this manner

<I have attached my progam>

 Looking Forward to recieving From You

[shrekt]

Hi,

Actuallly you have not attached the sub vi, so i was not able to see the logi.

but i think you can get by following ex.

regards

Shrek

[Monireh]

Hi,

Actually I could not open cell.vi because I am using LabVIEW version 8.5 so I was wondering if you could please save cell.vi for version 8.5 and send it to me; also I have attached my program with its subvi.

Thanks for your help

Looking Forward to hearing from You

[smercurio_fc · Accepted solution]

1. You are using the Write Characters to File VI. This does not create an Excel file. An Excel workbook is a proprietary format. LabVIEW does not read/write Excel workbooks. To read/write Excel workbooks you need to use ActiveX. Search the forum for examples, and look for links for examples in the Excel thread.
2. You are creating a file with a .csv extension. This is considered to be standard extension for a CSV file. A CSV file is a text file. The default delimiter for columns in CSV files is a comma, not a tab. When you try to directly open a .csv file with Excel by double-clicking the file on your hard disk, it tries to use a comma as a delimeter for columns. Since there are none, it puts everything in the first cell. Either change the delimeter to a comma or change the extension to .txt. If you change the extension to .txt then from within Excel you can select File->Open and tell it to use a tab as a delimiter. This is by design. It's not a bug.
3. I have no idea why you're even using the Write Characters to File VI in the first place, unless this was code that was written in an earlier version of LabVIEW. Using Write to Spreadsheet File will probably be easier. It's polymorphic.
4. I have no idea why you're using the Convert From Dynamic Data VI to create an array out of a single float. That's what Build Array is for. 
5. You have no way to stop the program unless you click on the Abort button in the toolbar. Replace the Boolean constant wired to the loop's control terminal with a Stop button.