cfspreadsheet and xlsm

[helenmhudson]

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?

[Dan_Bracuk]

What happened when you simply tried it?

[raybednar]

I am also having problems using  coldfusion 10 cfspreadsheet with xlsm files.  xlsx work fine but xlsm are causing errors like

An error occurred while reading the Excel: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException.       

I updated the poi jar files in the coldfusion lib folder to the latest versions and the problem still exists.   

[jsoenke34521]

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.