Hi friends, I am using ExcelJS to write array to excel. and it's working fine when i run it using node exceltest.js const ExcelJS = require('exceljs'); exceltest() async function exceltest(){ try{ const workbook = new ExcelJS.Workbook(); const sheet = workbook.addWorksheet('contacts_company'); sheet.columns = [{ header: 'company', key: 'company', width: 10}, { header: 'contact', key: 'contact', width: 10}, { header: 'country', key: 'country', width: 10}] sheet.addRows([[ 'Alfreds Futterkiste', 'Maria Anders', 'Germany' ],[ 'Centro comercial Moctezuma', 'Francisco Chang', 'Mexico' ], [ 'Ernst Handel', 'Roland Mendel', 'Austria' ], [ 'Island Trading', 'Helen Bennett', 'UK' ], [ 'Laughing Bacchus Winecellars', 'Yoshi Tannamuri', 'Canada' ], [ 'Magazzini Alimentari Riuniti', 'Giovanni Rovelli', 'Italy' ]]); await workbook.xlsx.writeFile("./writtenbyexceljs.xlsx") }catch(err){ console.log("Error is ------------ ", err) } } Output: [image] But, when I put the same code in a function node (after adding the require in settings.js file and using it as global.get), It doesn't add the rows anymore Output: [image] Any help on why it doesn't work inside function node is appreciated

I tried with addRows and it doesn't work. I tried with addTable and it does work. Tables are better anyway when working with Excel.

General

Topic		Replies	Views
I am having trouble opening excel files when using the Excel Sheets node General	9	832	2 December 2021
Problems with creating CSV or excel General	15	1276	24 January 2022
To change the value of a specific cell in Excel file General	39	950	20 August 2023
Xlsx file to json using function General function-node	4	251	7 February 2024
Saving a JSON array in an excel file General	13	7284	7 March 2019

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.

Code does not work in function node but works fine when run separately

Related topics