I have an excel file with a lot of scripts (office scripts). These scripts are linked with buttons inside the body of the excel file. I have written an Javascript app that I execute thought 'NodeJS'. This javascript reads the excel file, it makes some calculations and later the app put some results in the excel file (I use exceljs). The problem is that when I open the excel file, the buttons with the scripts have disappeared!. Can anyone help me! Thanks in advance.

      const ExcelJS = require('exceljs');
      const wb = new ExcelJS.Workbook();
      const fileName = 'Book.xlsx';

      (async () => {

        await wb.xlsx.readFile(fileName);
        const ws = wb.getWorksheet('RenM1ACont');
        const S_Bruto_00 = Number(ws.getCell('I69').value);


        ws.getCell('E61').value= tipoNumber;
        await wb.xlsx.writeFile(fileName);

})

Excel file with buttons

As can be seen in the image, before the program is run, the Excel file contains buttons with associated scripts. When the program is run through NodeJS, everything is correct except that the buttons, all of them, have disappeared and with them the scripts associated with each button.

I have an excel file with a lot of scripts (office scripts). These scripts are linked with buttons inside the body of the excel file. I have written an Javascript app that I execute thought 'NodeJS'. This javascript reads the excel file, it makes some calculations and later the app put some results in the excel file (I use exceljs). The problem is that when I open the excel file, the buttons with the scripts have disappeared!. Can anyone help me! Thanks in advance.

      const ExcelJS = require('exceljs');
      const wb = new ExcelJS.Workbook();
      const fileName = 'Book.xlsx';

      (async () => {

        await wb.xlsx.readFile(fileName);
        const ws = wb.getWorksheet('RenM1ACont');
        const S_Bruto_00 = Number(ws.getCell('I69').value);


        ws.getCell('E61').value= tipoNumber;
        await wb.xlsx.writeFile(fileName);

})

Excel file with buttons

As can be seen in the image, before the program is run, the Excel file contains buttons with associated scripts. When the program is run through NodeJS, everything is correct except that the buttons, all of them, have disappeared and with them the scripts associated with each button.

• javascript
• node.js
• excel
• xlsx
• exceljs

Share Improve this question Follow asked Mar 8 at 1:45 PcouperPcouper 1111 silver badge44 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

It’s likely that ExcelJS doesn’t recognize buttons, so it ignores them when parsing your file. As a result, when it writes the file back, it includes everything except the buttons