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

If you showed us the error, it would be immediately obvious what (part of) the problem was The console would show something like: [NR] 20/08/2023 14:48:06 [info] 20 Aug 14:48:06 - [red] Uncaught Exception: [NR] 20/08/2023 14:48:06 [error] Error: File not found: C: asmclientesInovadoorPasta1.xlsx at XLSX.readFile (C:\opt\flowforge-device\project\node_modules\exceljs\lib\xlsx\xlsx.js:51:13) at which point we would recognise the file name you used was not was attempted to be written. Try this - it writes a file but I dont have / dont use MS Office so cannot test. const inputFile = 'C:/temp/template.xlsx' const outputFile = 'C:/temp/new_workbook.xlsx' try { const workbook = new exceljs.Workbook(); await workbook.csv.readFile(inputFile) const worksheet = workbook.getWorksheet(1); const cell = worksheet.getCell('A5'); cell.value = new Date(1968, 5, 1); await workbook.xlsx.writeFile(outputFile) msg.payload = `Success. Read in '${inputFile}', modified cell A5 and wrote it to '${outputFile}'` return msg } catch(e) { msg.error = e node.error(`Error writing to file '${outputFile}'`, msg); } PS: You were crashing node-red because you were not handling errors (you did not have a catch on the promise. I re-wrote it with async/await & wrapped it in a try catch to avoid crashing Node-RED Proof: [explorer_mg5H7u4Ra7]

General

Topic		Replies	Views
How to read or write to individual cells in excel using node red General node-red-contrib-excel	1	1007	26 June 2023
If excel cell value changes, copy value to node red General	3	1067	26 June 2020
Node red and excel Dashboard node-red-dashboard , function-node , home-assistant	1	348	2 October 2023
Excel send latest data to another computer running node red on Docker FAQs	17	2034	8 July 2020
Excel: how to write in desired cell General	3	1810	5 April 2020

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.

To change the value of a specific cell in Excel file

Related topics