Whatever message this page gives is out now! Go check it out!
spreadsheetIsXMLFormat(spreadSheetObject)Name | Required | Type | Description |
spreadSheetObject | Yes | ExcelInfo | The Excel spreadsheet object whose format needs to be checked. |
<cfscript>
theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "SpreadsheetIsXMLFormat.xlsx";
obj =SpreadsheetNew("Course",true)
SpreadsheetSetCellValue(obj,"Test1",1,2)
spreadsheetWrite(obj, "#theFile#", "", "yes", "no")
format=SpreadsheetIsXMLFormat(obj)
writeOutput("XML Format: "& format)
</cfscript>