Quick Help

Knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.

Display the ITEM1 value, obtained by reading the MODBUS RTU at COM1 port on Excel

Problem

The PC is coupled with a PLC with MODBUS-RTU. For a single register configured to be read at the 40001 address, I obtain on the screen the following format:

#01#03#00#00#00#01#0A

#01#03#02#01#01#78#14 (bolded char are the data in register 40001),

For different decimal values in the 40001 register. I’m obtaining the following responses on screen:

For 40001 = 0 on PLC

#01#03#00#00#00#01#0A

#01#03#02#00#00#44

For 40001 = 10 on PLC
#01#03#00#00#00#01#0A
#01#03#02#00#0A#38#43

For 40001 = 100 on PLC

#01#03#00#00#00#01#84#0A

#01#03#02#00#64#B9#AF

For 40001 = 1000 on PLC

#01#03#00#00#00#01#84#0A

#01#03#02#03#E8#B8#FA

and so on…, with "View characters with code" options:

0x00h – 0x1Fh As Hex #XX code

0x20h – 0x7Fh As Hex #XX code

0x80h – 0xFFh As Hex #XX code

I’m trying to obtain on Excel file the corresponding value for ITEM1 selected but all that obtain is columns with FULL_DATA_PACKET, DATA_PACKET, MODBUS_DEVICE_ID, MODBUS_FUNC. If I delete all items and I let only ITEM1 on A1 column, nothing will be displayed.

Please help me to make the correct configuration to display the ITEM 1 value, obtained by reading the MODBUS RTU at COM1 port. I want to have at least this registered value on Excel to continue with the others registers data.