Lucee spreadsheet
From Hostek.com Wiki
Revision as of 17:12, 11 March 2018 by Briana (Talk | contribs) (Created page with "How to properly instantiate the "lucee-spreadsheet" class. Reference: https://github.com/cfsimplicity/lucee-spreadsheet#usage <pre> <cfscript> spreadsheet = New spreadshee...")
How to properly instantiate the "lucee-spreadsheet" class.
Reference: https://github.com/cfsimplicity/lucee-spreadsheet#usage
<cfscript>
spreadsheet = New spreadsheetLibrary.Spreadsheet();
path = ExpandPath("sample1.xls");
myQuery = spreadsheet.read( src=path, format="query");
</cfscript>
<cfdump var="#myQuery#" abort>