Supported ColdFusion functions addAutofilter addColumn addFreezePane addImage addInfo addPageBreaks addRow addRows addSplitPane autosize, implemented as autoSizeColumn createSheet deleteColumn deleteColumns deleteRow deleteRows formatCell formatCellRange formatColumn formatColumns formatRow formatRows getCellComment getCellFormula getCellValue getColumnCount info isSpreadsheetFile isSpreadsheetObject mergeCells new read readBinary removeSheet setActiveSheet setActiveSheetNumber setCellComment setCellFormula setCellValue setColumnWidth setFooter setHeader setRowHeight shiftColumns shiftRows write Extra functions not available in ColdFusion addConditionalFormatting addDataValidation addPrintGridlines binaryFromQuery cleanUpStreamingXml clearCell clearCellRange createCellStyle csvToQuery download downloadCsvFromFile downloadFileFromQuery getCellAddress getCellComments getCellFormat getCellHyperLink getCellType getColumnWidth getColumnWidthInPixels getLastRowNumber getPOIVersion getPresetColorNames getRowCount hideColumn hideRow isBinaryFormat isColumnHidden isRowHidden isStreamingXmlFormat isXmlFormat moveSheet newStreamingXlsx newXls newXlsx queryToCsv readCsv readLargeFile removePrintGridlines renameSheet removeSheetNumber setActiveCell setCellHyperLink setCellRangeValue setDateFormats setDefaultWorkbookFormat setFitToPage setFooterImage setHeaderImage setReadOnly setRecalculateFormulasOnNextOpen setRepeatingColumns setRepeatingRows setReturnCachedFormulaValues setSheetTopMargin setSheetBottomMargin setSheetLeftMargin setSheetRightMargin setSheetHeaderMargin setSheetFooterMargin setSheetPrintOrientation sheetInfo showColumn showRow workbookFromCsv workbookFromQuery writeFileFromQuery writeCsv writeToCsv