-
-
Notifications
You must be signed in to change notification settings - Fork 39
ColdFusion spreadsheet functionality support
Spreadsheet CFML supports all of the functionality offered by Adobe ColdFusion, although implementation details may vary in some cases.
Below is a list of ColdFusion spreadsheet functions with the corresponding library method:
- IsSpreadsheetFile -> isSpreadsheetFile
- IsSpreadsheetObject -> isSpreadsheetObject
- SpreadSheetAddAutofilter -> addAutofilter
- SpreadsheetAddColumn -> addColumn
- SpreadsheetAddFreezePane -> addFreezePane
- SpreadsheetAddImage -> addImage
- SpreadsheetAddInfo -> addInfo
- SpreadSheetAddPagebreaks -> addPageBreaks
- SpreadsheetAddRow -> addRow
- SpreadsheetAddRows -> addRows
- SpreadsheetAddSplitPane -> addSplitPane
- SpreadsheetCreateSheet -> createSheet
- SpreadsheetDeleteColumn -> deleteColumn
- SpreadsheetDeleteColumns -> deleteColumns
- SpreadsheetDeleteRow -> deleteRow
- SpreadsheetDeleteRows -> deleteRows
- SpreadsheetFormatCell -> formatCell
- SpreadsheetFormatCellRange -> formatCellRange
- SpreadsheetFormatColumn -> formatColumn
- SpreadsheetFormatColumns -> formatColumns
- SpreadsheetFormatRow -> formatRow
- SpreadsheetFormatRows -> formatRows
- SpreadsheetGetCellComment -> getCellComment
- SpreadsheetGetCellFormula -> getCellFormula
- SpreadsheetGetCellValue -> getCellValue
- SpreadsheetGetColumnCount -> getColumnCount
- SpreadsheetInfo -> info
- SpreadsheetMergeCells -> mergeCells
- SpreadsheetNew -> new
- SpreadsheetRead -> read
- SpreadsheetReadBinary -> readBinary
- SpreadsheetRemoveSheet -> removeSheet
- SpreadsheetSetActiveSheet -> setActiveSheet
- SpreadsheetSetActiveSheetNumber -> setActiveSheetNumber
- SpreadsheetSetCellComment -> setCellComment
- SpreadsheetSetCellFormula -> setCellFormula
- SpreadsheetSetCellValue -> setCellValue
- SpreadsheetSetColumnWidth -> setColumnWidth
- SpreadsheetSetFooter -> setFooter
- SpreadsheetSetHeader -> setHeader
- SpreadsheetSetRowHeight -> setRowHeight
- SpreadsheetShiftColumns -> shiftColumns
- SpreadsheetShiftRows -> shiftRows
- SpreadsheetWrite -> write
In Adobe ColdFusion, the SpreadsheetRead() function is limited to just returning a spreadsheet object, whereas the <cfspreadsheet action="read"> tag has a range of options for reading and returning data from a spreadsheet file.
The read() method in this library allows you to read a spreadsheet file into a query and return that instead of a spreadsheet object. It includes all of the options available in <cfspreadsheet action="read">.
<cfscript>
myQuery = spreadsheet.read( src=mypath, format="query" );
</cfscript>
The read() method also features the following additional options not available in ColdFusion:
fillMergedCellsWithVisibleValueincludeHiddenColumnsincludeRichTextFormattingcsvDelimiterqueryColumnTypes