Pages

addAutofilter

Last updated May 21, 2025

addColumn

Last updated May 21, 2025

addConditionalFormatting

Last updated May 21, 2025

addDataValidation

Last updated May 2, 2023

addFreezePane

Last updated Sep 20, 2021

addImage

Last updated Aug 12, 2025

addInfo

Last updated Sep 20, 2021

addPageBreaks

Last updated Sep 20, 2021

addPrintGridlines

Last updated Sep 20, 2021

addRow

Last updated Sep 20, 2021

addRows

Last updated Oct 6, 2021

addSplitPane

Last updated Sep 20, 2021

autoSizeColumn

Last updated Sep 20, 2021

binaryFromQuery

Last updated Sep 20, 2021

Chaining

Last updated Sep 18, 2021

cleanUpStreamingXml

Last updated Sep 20, 2021

clearCell

Last updated Sep 20, 2021

clearCellRange

Last updated Sep 20, 2021

ColdFusion spreadsheet functionality support

Last updated Apr 22, 2025

collapseColumnGroup

Last updated Apr 15, 2025

collapseRowGroup

Last updated Apr 15, 2025

createCellStyle

Last updated Mar 8, 2023

createJavaObject

Last updated May 3, 2023

createSheet

Last updated Sep 20, 2021

csvToQuery

Last updated Oct 17, 2025

Data type handling

Last updated Mar 3, 2023

deleteColumn

Last updated Sep 20, 2021

deleteColumns

Last updated Dec 11, 2021

deleteRow

Last updated Sep 20, 2021

deleteRows

Last updated Dec 11, 2021

download

Last updated Sep 20, 2021

downloadCsvFromFile

Last updated Sep 20, 2021

downloadFileFromQuery

Last updated Sep 20, 2021

expandColumnGroup

Last updated Apr 15, 2025

expandRowGroup

Last updated Apr 15, 2025

formatCell

Last updated Mar 3, 2023

formatCellRange

Last updated Mar 3, 2023

formatColumn

Last updated Mar 3, 2023

formatColumns

Last updated Mar 3, 2023

formatRow

Last updated Mar 3, 2023

formatRows

Last updated Mar 3, 2023

Formatting options

Last updated May 2, 2023

Functions not available in ColdFusion

Last updated Apr 22, 2025

getActiveCell

Last updated Apr 15, 2025

getCellAddress

Last updated Mar 6, 2024

getCellComment

Last updated Sep 20, 2021

getCellComments

Last updated Sep 20, 2021

getCellFormat

Last updated Sep 20, 2021

getCellFormula

Last updated Sep 20, 2021

getCellHyperLink

Last updated Sep 20, 2021

getCellType

Last updated Sep 20, 2021

getCellValue

Last updated Sep 20, 2021

getColumnCount

Last updated Sep 20, 2021

getColumnWidth

Last updated Sep 20, 2021

getColumnWidthInPixels

Last updated Sep 20, 2021

getLastRowNumber

Last updated Sep 20, 2021

getPOIVersion

Last updated Sep 20, 2021

getPresetColorNames

Last updated Sep 20, 2021

getRecalculateFormulasOnNextOpen

Last updated Apr 16, 2025

getRowCount

Last updated Sep 20, 2021

getSheetPrintOrientation

Last updated Apr 16, 2025

Global configuration options

Last updated May 9, 2025

groupColumns

Last updated Apr 15, 2025

groupRows

Last updated Apr 15, 2025

hideColumn

Last updated Sep 20, 2021

hideRow

Last updated Sep 20, 2021

hideSheet

Last updated Feb 27, 2025

info

Last updated Sep 18, 2025

isBinaryFormat

Last updated Sep 20, 2021

isColumnHidden

Last updated Sep 20, 2021

isRowHidden

Last updated Sep 20, 2021

isSpreadsheetFile

Last updated Sep 20, 2021

isSpreadsheetObject

Last updated Sep 20, 2021

isStreamingXmlFormat

Last updated Sep 20, 2021

isXmlFormat

Last updated Sep 20, 2021

Loading the POI java libraries

Last updated Jun 4, 2025

mergeCells

Last updated Sep 20, 2021

moveSheet

Last updated Jun 22, 2024

new

Last updated Mar 6, 2024

newChainable

Last updated Sep 17, 2021

newConditionalFormatting

Last updated May 21, 2025

newDataValidation

Last updated Sep 9, 2025

newStreamingXlsx

Last updated Mar 18, 2021

newXls

Last updated Apr 8, 2017

newXlsx

Last updated Apr 8, 2017

Null support

Last updated May 9, 2025

processLargeFile

Last updated Apr 25, 2025

queryToCsv

Last updated Nov 27, 2023

read

Last updated May 21, 2025

readBinary

Last updated Sep 20, 2021

readCsv

Last updated Apr 25, 2025

readLargeFile

Last updated Apr 16, 2025

recalculateAllFormulas

Last updated Apr 16, 2025

removeColumnBreak

Last updated Apr 18, 2025

removePrintGridlines

Last updated Sep 20, 2021

removeRowBreak

Last updated Apr 15, 2025

removeSheet

Last updated Sep 20, 2021

removeSheetNumber

Last updated Sep 20, 2021

renameSheet

Last updated Sep 20, 2021

setActiveCell

Last updated Sep 20, 2021

setActiveSheet

Last updated Sep 20, 2021

setActiveSheetNumber

Last updated Sep 20, 2021

setCellComment

Last updated Sep 20, 2021

setCellFormula

Last updated Sep 20, 2021

setCellHyperLink

Last updated Mar 3, 2023

setCellRangeValue

Last updated Sep 20, 2021

setCellValue

Last updated Aug 6, 2024

setColumnBreak

Last updated Apr 18, 2025

setColumnWidth

Last updated Sep 20, 2021

setDateFormats

Last updated May 21, 2025

setDefaultWorkbookFormat

Last updated Mar 6, 2024

setFitToPage

Last updated Sep 20, 2021

setFooter

Last updated Sep 20, 2021

setFooterImage

Last updated Sep 20, 2021

setHeader

Last updated Sep 20, 2021

setHeaderImage

Last updated Sep 20, 2021

setLoadJavaClassesUsing

Last updated May 9, 2025

setReadOnly

Last updated Sep 20, 2021

setRecalculateFormulasOnNextOpen

Last updated Apr 16, 2025

setRepeatingColumns

Last updated Sep 20, 2021

setRepeatingRows

Last updated Sep 20, 2021

setReturnCachedFormulaValues

Last updated Mar 6, 2024

setRowBreak

Last updated Apr 18, 2025

setRowHeight

Last updated Sep 20, 2021

setSheetBottomMargin

Last updated Sep 20, 2021

setSheetFooterMargin

Last updated Sep 20, 2021

setSheetHeaderMargin

Last updated Sep 20, 2021

setSheetLeftMargin

Last updated Sep 20, 2021

setSheetPrintOrientation

Last updated Sep 20, 2021

setSheetRightMargin

Last updated Sep 20, 2021

setSheetTopMargin

Last updated Sep 20, 2021

setThrowExceptionOnFormulaError

Last updated May 8, 2025

sheetInfo

Last updated Apr 16, 2025

shiftColumns

Last updated Sep 20, 2021

shiftRows

Last updated Sep 20, 2021

showColumn

Last updated Sep 20, 2021

showRow

Last updated Sep 20, 2021

Spreadsheet CFML Documentation

Last updated Feb 20, 2026

ungroupColumns

Last updated Apr 15, 2025

ungroupRows

Last updated Apr 15, 2025

unhideSheet

Last updated Feb 27, 2025

workbookFromCsv

Last updated Sep 20, 2021

workbookFromQuery

Last updated Nov 11, 2021

write

Last updated Aug 22, 2025

writeCsv

Last updated Nov 27, 2023

writeFileFromQuery

Last updated Sep 20, 2021

writeToCsv

Last updated Sep 20, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!