Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about Teams
Anyone here worked on adding a VBA macro to an existing excel sheet using python or Javascript??
I have an application build on top of HapiJs, and have a requirement to download an excel, which consists of a VBA macro
We used exceljs library on node to generate the excel sheet from data, unfortunately it does not support .xlsm format.
Also tried to xlsx(SheetJS) library which supports .xlsm but it’s does not support cell styling as of now.
Finally I also manually unzipped a macro enabled excel and copied stuff into our excel but even that fails.
Also tried using Various python libraries but had no luck. (openpyxl, xlrd, xlsxwriter etc.)
–
Thanks for contributing an answer to Stack Overflow!
-
Please be sure to
answer the question
. Provide details and share your research!
But
avoid
…
-
Asking for help, clarification, or responding to other answers.
-
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our
tips on writing great answers
.
