cfspreadsheet and xlsm

New Here ,
Jan 29, 2013 Jan 29, 2013

Copy link to clipboard

Copied

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?

TOPICS
Advanced techniques

Views

1.4K

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 29, 2013 Jan 29, 2013

Copy link to clipboard

Copied

What happened when you simply tried it?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 20, 2015 Mar 20, 2015

Copy link to clipboard

Copied

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.   

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 10, 2019 Jan 10, 2019

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines