Hi,
I need to change the value on a specific cell in an Excel file using a function.
I already searched for the solution in many topics, but I didn't find it.
Is this possible on Node Red?
thanks in advance
Antonio
Have a look at node-red-contrib-excelsheets (node) - Node-RED , never used it myself so can't confirm if it will do the job.
I think this question came up recently before. Maybe also try searching the forum for previous answers.
Hi... this node only create a excel file, not to update data.
thanks.
could you try to help me?
I didn't founded the solution.
thanks
node-red-contrib-spreadsheet-in will read in a spreadsheet.
Thanks... but there not a solution for change the value on a specific cell from a Excel file.
That is the wrong node. Read my post again. More carefully this time.
You're right! sorry.
But, I don't need to read a file, but I need the write a value in a specific cell in a Excel file.
Yes you do, you need to read the file, replace the cell, and write it out again.
I understood, but it is a very complex spreadsheet, even so thank you very much.
An alternative strategy might be to look for a command line utility that can do what you want. Then you could run that from node-red using an exec node. I don't know whether there is such a tool, but I am sure your favourite search engine will help.
Thanks Colin!
I'm tring to look for that solution, but is not easy because Excel it's hard to manipulate from external programs.
Pretty much why most people make reports in web pages or pdf. Writing to excel is a pain. Macros get damaged, cell references don't get updated, charts stop working.
If your spreadsheet is an xlsx it should be possible to unzip it, modify the XML, re-zip and save.
Tbf, it's been a while since I had to do this - the node packages may have improved by now.
Really?
Sorry, Steve but I have to disagree here. Excel is one of the best defined and understood file formats. There are dozens of libraries capable of manipulating xlsx files and manipulating tabular data in xlsx or CSV formats is one of the most common data manipulation tasks in many industries.
Sadly, JavaScript isn't as good as Python for manipulating Excel. If it were, Node-RED would be even more useful in many enterprise, health, government and scientific settings. But there are still plenty of options.
I will admit to having not done this for some time. And I did say things may have improved.
A 5~10 years back, I tried about 8 different libraries. They all worked to a certain degree. You could write to cells or bind an array etc, but they all had one or more of the issues I mentioned. Admittedly, this was before xlsx became the default (everyone was still using xls (bof format)). In the end, I wrote my own.
Ultimately, everything became web or pdf. Problem solved.
Well, we agree that JavaScript doesn't have the mature libraries that Python does sadly. A source of ongoing annoyance in my line of work. But there are ones that work.
Web/PDF isn't an answer for structured tabular data though. CSV and xlslx remain king there. And Excel will remain the tool of choice for most business users needing tabular data manipulation.
