Hello, i would like to do one thing , when the excel update new row of data , then the excel can send the new row data to node red. please give me some suggestion for this issue, thanks a lot in advance...

Hello, i can post data from excel to node red now. Below is my VBA code, I post data to node red cell by cell. Sub BasicPOSTRequest() Dim req As New MSXML2.XMLHTTP30 Dim reqURL As String Dim i As Integer Dim m, n As Long m = ActiveSheet.UsedRange.Rows.Count n = ActiveSheet.UsedRange.Columns.Cou…

If the sheet does not need to use fancy fonts/graphs, one approach would be to save the sheet as CSV file. You could then configure a watch node to monitor changes in the CSV file, read it in using a file node and then pass the data though a CSV node to make the data easier to process.

thanks Ristomatti, for node red watch the excel file, i have two issues 1, the excel file is located in other PC which is in the same local network with node red PC 2, the node red is located in docker. i don't know how node red can watch and get data from the excel.

Well you did not mention Excel is run on another computer. To get the data to Node-RED, you will either need to automatically transfer the file to the computer were Node-RED is running when it's modified or setup file sharing on the computer running Node-RED. Which method would sound better to you …

I've edited the message title to better describe the issue so people who might have ideas might find this easier. We're celebrating Midsummer Eve here in Finland today so I might not be reading the forum in a couple of days (depending on the level of hangover that will result from all this :grin:). …

Maybe something like this "Excel Internet of Things Connector" [Excel IoT Connector - Excel Internet of Things Connector] With this you can connect your excel to a mqtt broker. The broker will publish the data and is available in node red.

both computers run windows system, and i am a newbie with docker :joy:

[image] lee1: i am a newbie with docker Unless you have a good reason then I suggest not using Docker. It is excellent in the right circumstances but just causes headaches in situations where it is not needed.

Docker will massively complicate things. I'll ignore it here I'm afaid. You have a number of options to update Node-RED from Excel. A lot is going to depend on how much control you have over the Excel workbook and whether you are permitted to run macro's on the workbook. If you can let us know that…

Hello TI, i have tried to write macros in excel with HTTP POST request to node red web server. for now i can post the data inside one cell to node red, i am trying to send the the last row data(several columns) to node red now.

If you get it working, please share the macro. Some others might be interested also. Even I might find use for it one way or another. :slightly_smiling_face:

Node-RED

Node-RED Forum

Excel send latest data to another computer running node red on Docker

FAQs

lee1 22 June 2020 06:27 12

ok , no problem. after i finish, i will share the marco

1 Like

Topic		Replies	Views
If excel cell value changes, copy value to node red General	4	1028	25 August 2020
To change the value of a specific cell in Excel file General	40	686	3 September 2023
Node red and excel Dashboard node-red-dashboard , function-node , home-assistant	2	312	1 November 2023
Excel to node red General	8	4246	16 April 2020
Sending data from node-red to xlsx file on windows 10 General	9	1851	25 September 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Excel send latest data to another computer running node red on Docker

Related topics