Hello , i have problem whit how can i display data from EXCEL in real time to node red and build an dashboard ?? how can i show data from Excel in node red

Hi Hicham, Can you explain a bit more, you have a spreadsheet, and you'd like to load data from it and display it in a dashboard? Do you need to just read the file, or edit/save to it as well? For displaying tables on the node-red-dashboard, take a look at node-red-node-ui-table: https://flows.nod…

thank you so much Afelix, yea I want to write data in Excel file and at the same time be displayed in a dashboard in node red

[image] HICHAM22: write data in Excel [image] HICHAM22: at the same time How real time is real time? Because keep in mind that in order to display it, the file needs to be saved in Excel first. After all, it doesn't exist in the file yet if it isn't saved in Excel prior to it.

You should note that Excel uses a complex file format that is absolutely NOT suitable for real-time display. Even when using Microsoft's Office 365 cloud service, you don't actually get real-time updates of data (despite Microsoft claiming you do). Microsoft actually "cheat", you don't see updates u…

This is the third topic in only a couple weeks where inputting data in excel, then reading it in node-red (preferably without having to save the file). Where google spreadsheets offers a kind of real time display/editing, Excel is not suitable for it.

It certainly does look like a college exercise. I'll provide some clues as to how i would attempt this... Create a HTTP endpoint in node red that will receive data & populate the dashboard controls In Excel, Using VBA, create a couple of macros... That receives a value & POSTs it to the node red…

Node-RED

Node-RED Forum

Excel to node red

General

afelix 16 February 2020 20:33 5

Also, are you by chance working on the same school project as Send data from excel to dashboard?

Topic		Replies	Views
Node red and excel Dashboard node-red-dashboard , function-node , home-assistant	1	334	2 October 2023
Send data from excel to dashboard Dashboard	2	1536	16 February 2020
Reading excel file Dashboard node-red-dashboard , database	1	333	30 January 2023
Excel send latest data to another computer running node red on Docker FAQs	17	1976	8 July 2020
Create a formatted Excel Report with node red Dashboard	2	842	19 August 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 to node red

Related topics