Skip to main content
H
helenmhudson
Participating Frequently
January 29, 2013
Question

cfspreadsheet and xlsm

  • January 29, 2013
  • 2 replies
  • 1642 views

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?

This topic has been closed for replies.

2 replies

J
jsoenke34521
Participant
January 11, 2019

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.

D
Dan_Bracuk
Inspiring
January 29, 2013

What happened when you simply tried it?

raybednar
raybednar
Participant
March 20, 2015

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.   

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices