I want to use cfspreadsheet to update the data in an xlsm file.
From the docs, it seems that cfspreadsheet can handle the "updating"... does anyone know if it has a problem with xlsm files in excel?
What happened when you simply tried it?
I am also having problems using coldfusion 10 cfspreadsheet with xlsm files. xlsx work fine but xlsm are causing errors like
For anyone finding this now, the newer versions of Coldfusion can read and write .xlsm files and preserve the macros. I've tested it on ColdFusion 2016.