What is the considered best practice for enabling cfspreadsheet commands like spreadsheetnew in Lucee 6.1.1.18? Is it already included? Is it the cfsimplicity extension?
I ask because we are updating our codebase to be Lucee 6.1.1.18 compliant, and the installation of the cfspreadsheet extension for version 5 results in failure.
Thank you!
Lucee: 6.1.1.18
Java: 11.0.23
OS : Windows Server 2019 (64bit)
Tomcat: 9.0.89
the fix is in this thread: Cfspreadsheet.cfc Error after upgrade 6.0.0.585 - #10 by Leftbower
“The archive column is prepopulated. You need to fill in the resource column when you change the type. I checked the Search Subdirectories setting at the top of the page and then just used the cfspreadsheet directory (/opt/lucee/tomcat/lucee-server/context/archives/cfc/cfspreadsheet/) on my server. Otherwise you probably need to point directly to the CFC file that down a few directories.”
Though if you are just creating a simple spreadsheet, concider just making a CSV file out of it.
Or if you want to be “cool” data tables
https://datatables.net/extensions/buttons/examples/initialisation/export.html
Thanks Terry! I’ve got it working now, specifically having done this. I really appreciate it old friend!
I highly recommend this library:
It’s a totally feature-complete replacement for the cfspreadsheet tag, and has a bunch of great convenience functions like .download() etc.