pietersv
commented
8 years ago Macros are not currently supported in js-xlsx (or the styles branch of it). Excel is really ZIP file with a directory structure of XML and other documents. You may be able to extend the xlsx code base to enable that, adding the appropriate files.
You might just open the file generated by js-xlsx, unzip it using JSZip, use cheerio to parse, modify and regenerate the appropriate XML files with the VBA added, and use JSZip to generate the modified workbook.
A workflow I suggest is
- save an Excel workbook to a directory, (E.g.
~/myprojects/lab/book1/book1.xlsx) - unzip it (e.g.
jar -xvf book1.xlsx) - open the directory in a modern IDE like WebStorm (open
~/myprojects/lab/for convenience) - open the workbook files using the IDE's project tree
- Use the Code->Reformat Code... utility to make the XML human readable
- Find out what Excel did to create the VBA
- Do that manually using JSZip and Cheerio
connectsoft-smartdata
foltz
Hi, i'm using your library which works perfectly. I was wondering if it was possible to insert a macro in the workbook.
I want to create 2 worksheets, the first being a pivot table of the second. For that I want to insert a vba macro that will create the first worksheet as pivot table created from the second worksheet.
Is there a way to insert vba script in the workbook generated by the library ?
Thanks in advance