I’m on Lucee 5.1.3
it does not seem to have cfspreadsheet tag. Is there a way to get it
1 Like
Good to know.
For now, I just need to read an XLS file, SpreadsheetRead.cfm seems the right guy for it.
But how do we dump the read output of
<cfreturn CreateObject(“component”, “org.cfpoi.spreadsheet.Spreadsheet”).init( argumentCollection=arguments ) />
Thanks.
If you are using this extension you can use very much like in cf docs.
<cfspreadsheet
action = "read"
src="#expandPath('your-file.xls')#"
query="qXLSRead" headerrow="1" rows="1-500"
excludeHeaderRow="true"
>
<cfdump var="#qXLSRead#">