labView send data from wireless node to excel file

[PGRAY10]

Hello All,

I have used the basic tutorial for the NI Wireless Sensors Network. http://www.ni.com/tutorial/8890/en/. I have completed it with one node. The next step in my project is to send the data from the node and the date and time to an excel file every hour. Are there any tips I can get for atleast sending the date and data to the excel file? I am using labView 2012

I edit it because I put text file instead of excel

[Dennis_Knutson]

Your subject says text file but you mention excel. The simplest way is to use the Write to Spreadsheet File or the Express VI Write to Measurement File. The first creates a text file that Excel can open. The second can create either a text file or native Excel with the most recent LabVIEW. If you have the Report Generation Toolkit, you can create native Excel. Using low level ActiveX, you can create native Excel. All of these have examples and if you search the forums for Excel, you'll find thousands of discussions on the topic.

[PGRAY10]

I tried to have it write to excel but the wires will not connect. I am not in the lab currently but I will put a screen shot up tomorrow to give a better idea of what is going on

[natasftw]

Please post your actual code instead of a screenshot.  It's easier to work with.

[KHartley]

Hey Pgray,

You should be able to right click on the IO Node from the end node on the host and enable time stamps. As Dennis mentioned using a write to spreadsheet will be easiet.

First figure out the structure of your spreadsheet column 1 being time stamp, column 2-5 being node 1 channels 0-3, etc...

You probaly need to convert the numeric values to a string, you can use the format into string function. You'll need to do a similar step for the time stamp. Then you'll be able to bundle the strings into an array and write to the spreadsheet and it will map as a row.

Hope this helps.

[PGRAY10]

Why wont the wire connect

[Dennis_Knutson · Accepted solution]

You can't connect a scalar to the array input that is required. A fix would be to insert a Build Array before the Write to Spreadsheet.