Cfspreadsheet?


#1

I’m on Lucee 5.1.3
it does not seem to have cfspreadsheet tag. Is there a way to get it


#2

#3

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.


#4

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#">