cfspreadsheet and xlsm

3 replies
1655 views
Translate

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?

Advanced techniques

This topic is closed to new replies. Start a new post to keep the conversation going.

J

jsoenke34521

Participant

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.

Translate

D

Dan_Bracuk

Inspiring

What happened when you simply tried it?

Translate

raybednar

Participant

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.

Translate

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.