User Guide Cancel

spreadsheetIsStreamingXMLFormat

 

Description

Checks if a streaming spreadsheet is in XML format.

Returns

True, if streaming spreadsheet is XML, else, false. 

History

  • ColdFusion (2025 release): Added the function.

Syntax

spreadsheetIsStreamingXMLFormat(spreadSheetObject)
spreadsheetIsStreamingXMLFormat(spreadSheetObject)
spreadsheetIsStreamingXMLFormat(spreadSheetObject)

Parameters

Name

 

 

Required

 

 

Type

 

 

Description

 

 

spreadSheetObject

 

 

Yes

 

 

ExcelInfo 

 

 

The Excel spreadsheet object to check whether the row is hidden.

 

Example

<cfscript>
theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "SpreadsheetIsStreamingXMLFormat.xlsx";
obj =streamingSpreadsheetNew("Course")
SpreadsheetSetCellValue(obj,"Test1",1,2)
spreadsheetWrite(obj, "#theFile#", "", "yes", "no")
format=SpreadsheetIsStreamingXMLFormat(obj)
writeOutput("StreamingXML Format: "& format)
</cfscript>
<cfscript> theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "SpreadsheetIsStreamingXMLFormat.xlsx"; obj =streamingSpreadsheetNew("Course") SpreadsheetSetCellValue(obj,"Test1",1,2) spreadsheetWrite(obj, "#theFile#", "", "yes", "no") format=SpreadsheetIsStreamingXMLFormat(obj) writeOutput("StreamingXML Format: "& format) </cfscript>
<cfscript>
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "SpreadsheetIsStreamingXMLFormat.xlsx";
    obj =streamingSpreadsheetNew("Course")
    SpreadsheetSetCellValue(obj,"Test1",1,2)
    spreadsheetWrite(obj, "#theFile#", "", "yes", "no")
    format=SpreadsheetIsStreamingXMLFormat(obj)
    writeOutput("StreamingXML Format: "& format)
</cfscript>

Get help faster and easier

New user?