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 MOBBUS-RTU. For a single register configured to be read at 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 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 toobtain on excel file the coresponding for ITEM1 selected but all that obtain is columns with FULL_DATA_PACKET, DATA_PACKET, MODBUS_DEVICE_ID, MODBUS_FUNC. If I’m deleting all items and I let only ITEM1 on A1 column, nothing will be displayed.

Please help me to make the correct configuration in order 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 in order to continue with the others register data.