How can i make COM port selection in LabView

[$anman23]

Hello Mansi here.

I am working on "warehouse monitoring system using wireless loadcell" project.For that i am using zigbee technology. I have the ETRX357-LRS USB stick made by TELEGESIS company. This zigbee device is work as receiver and connected to the PC. Tlegesis terminal software will display the data comming from the transmitter side.

1.Now i want to display that data directly in to Excel sheet.For that i have choose the LabView. The ETRX357-LRS USB stick having COM17 id shown in device manager. I want to select this com port device in labview and that display data into the excel sheet.

Is that possible? 

2. Can anyone help in interfacing of  ETRX357-LRS USB stick with labview?. 

I m new in this field. tell me the steps so that i can rich to the my goal.

[Albert.Geven]

use a VISA control to select the com port.

All ports should be displayed.

Which operating system and LabVIEW version do you have?

[$anman23]

I m using window 7 os and LV 10 version.

How can i export the data from COM port device to excel sheet? Data from the COM port is digital numerical value.

[crossrulz]

Convert the data into an array of the data and then use the Write To Spreadsheet File.vi to save the data in a tab delimited text file.  Excel can open those easily enough.

[$anman23]

I have made 1 VI to transfer data from com port device to excel sheet. but out put is different. I want output 2.49, 2.49 continuously. But getting 2.49,0,2.49,0.

Dont want this extra 0. 

Attaching the vi and excel sheet have look at it.

Help me out.

[$anman23]

sorry i have attached the incomplite vi. the complete one is here.

[Albert.Geven]

Hi

two remarks

1) the clr and the close should not be connected in parallel. In fact you can omit the Clr, because you are closing anyhow.

2) why not use an endcharacter instead of reading the number of bytes.

And if that ,0 is sent you always can throw it away after reading