I want to extract one the content of cell A1 from a .ods file. This value is being updated every 5s. I am able to extract the value from the cell from the last saved version of the file. However, when the value is updated, I want to be able to extract that updated value. [image]

You could use a Watch node to tell you when the file has been updated and use that to trigger the read.

Hello Colin. Thanks for the reply. I have tried to use the watch node. However, I am getting an error. [image] [image]

The error is because the Watch node should be configured to watch a directory, not an individual file.

I use it to watch individual files.

Which node is that coming from? Hover over it and the node should highlight. Even better give your nodes names. [Edit] If it is coming from the Excel node then it is probably that the flow is responding too quickly to changes and trying to read the file while it is still being updated. Try putti…

that error is coming from the watch node

That is odd, it works fine for me. What version of node-red are you using? Also what version of nodejs. Run node -v to find that.

v1.0.5 for node red v12.16.3 for nodejs

I think you have selected Watch Subdirectories in the Watch node, and it is complaining that the ods file is not a directory. Uncheck that checkbox.

How to extract data from a file of type .ods

General

eddy23 1 July 2020 11:49 9

I am using version 12.16.3
I have tried using the trigger node with the configurations as requested. I still receive the same error.

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
Excel send latest data to another computer running node red on Docker FAQs	18	1886	22 July 2020
Importing the latest file(s) from a file folder into Node-RED General	8	284	20 June 2023
Flow doesnt read data from xlsx General database	10	597	7 May 2022

How to extract data from a file of type .ods

Related topics