LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Save data coming from VISA READ in excel file

Solved!
Go to solution

 

Dear All, 

I have voltmeter data coming serially from voltmeter to the PC through Rs-232 cable continuously. 

I am able to continuously observe the reading from the voltmeter. 
Now , i want to save this incoming data in an excel sheet. 

Can anyone help me with it. 

I am attaching my VI here.

Thanks in advance

 

0 Kudos
Message 1 of 6
(1,406 Views)
Solution
Accepted by topic author RaoJaved

Hi Rao,

 


@RaoJaved wrote:

Now , i want to save this incoming data in an excel sheet. 

Can anyone help me with it. 


Save the strings you receive from your device to a text file.

Excel is able to open text files!

 

Please watch this video to learn how to improve your simple serial VI…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 6
(1,388 Views)

I have tried two configurations and I am facing error (screenshots attached herewith) when i try to save the data coming from VISA read into a .txt file. Please help me to rectify. 

I am attaching the code as well.

 

Download All
0 Kudos
Message 3 of 6
(1,326 Views)

Hi Rao,

 


@RaoJaved wrote:

I have tried two configurations and I am facing error (screenshots attached herewith) when i try to save the data coming from VISA read into a .txt file. Please help me to rectify. 

I am attaching the code as well.


See this simplified snippet:

Error 7 has a meaning: did you read the error explanation and did you verify your file operations actually can access the file in the expected location?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 4 of 6
(1,320 Views)

Dear Sir, 

I am looking at the errors. 

Can you please tell me the name of the icon in the attached snippet?

(What should i type in the search box to pick this module.)

Thanks for help sir.

 

0 Kudos
Message 5 of 6
(1,302 Views)
Solution
Accepted by topic author RaoJaved

Hi Rao,

 


@RaoJaved wrote:

Can you please tell me the name of the icon in the attached snippet?


CompoundArithmetic (set to OR inputs)…

 

I gave you a snippet, which you could drag and drop into your block diagram to receive the underlying code. Please read the LabVIEW help for "snippets"!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 6 of 6
(1,295 Views)