I'm currently working on a project where I'm using Node-RED to read data from a PLC using the FINS protocol. I've been successful in receiving numeric data from the PLC, but now I want to map this data to specific text entries in an Excel file.
My Excel file is structured with two columns: Column A contains part numbers (numeric data), and Column B contains corresponding descriptive text. Here's an Example
My goal is to take the numeric input from the PLC, match it with a part number in the Excel file, and output the corresponding text in Node-RED. For instance, if I receive '10' from the PLC, I'd like Node-RED to output 'AB'.
So far, I've tried using the
node-red-contrib-spreadsheet-in node to read the data from the Excel file, but I'm not quite sure how to map the data from the PLC to the part numbers in the Excel file and then output the corresponding text.
Has anyone done anything similar or could provide some guidance on how to achieve this? I would really appreciate your help!
Thank you in advance.