Writing Obtained K-Type Thermocouple Temperatures On Excel

[Sarkis Sarkissian]

Hello, I have a JZ20-J-UA24. I'm reading temperatures by means of a thermocouple, and I want to record those temperatures on EXCEL, is there a way to do that through U90 Ladder?

[AlexUT]

Hi Sarkis,

Look at U90Ladder examples:

C:\Program Files (x86)\Unitronics\Unitronics U90 Ladder\Examples\Communication\
Printing data.U90
Send string with STX and ETX.U90

Use serial port at PC to collect data.

B.R.

 

[Sarkis Sarkissian]

I didnt get how it worked, I'm sorry i'm a bit new to u90 ladder, so can you give me a detailed help on to how to do it. I just want the values to be written in an excel spreadsheet

 

[AlexUT]

Sarkis,

You can download and test DataXport

https://unitronicsplc.com/software-visilogic-for-programmable-controllers/

https://unitronicsplc.com/Download/SoftwareUtilities/DataXport_3_1_23.exe

Install it, define communication channel and it will request information from JZ20 and save it as Excel spreadsheet at each preset time interval.

B.R.

 

[Sarkis Sarkissian]

I downloaded it, and its still not working. It is basically not reading the PLC. I have it connected by means to a USB to the PC. I tried to connect by all possible ports, and still it was working. Its just the below analog inputs I want to write them on excel. Is there any easier way to do that please?