Hello,
Anyone know of a workaround to export data to a macro enabled excel template (extension .xltm)?
It would save few steps and keep data clean if i let it dynamo move the data around and not my users?
Hello,
Anyone know of a workaround to export data to a macro enabled excel template (extension .xltm)?
It would save few steps and keep data clean if i let it dynamo move the data around and not my users?
OK, so i wrote a class in c# to open an XLTM file, Find or create a spreadsheet, enter data overwriting original content, then save it as XLSM.
The code uses openXML and is created using the many examples that i found here and other forums.
I only tested it for what i need it for, so test it for your own implementation as well.
XLTM-XLSM-Overwrite.txt (16.8 KB)