Whatever message this page gives is out now! Go check it out!

Microsoft Office integration functions

Last update:
May 18, 2026
FunctionDescription
IsSpreadsheetFileChecks if a specified file is a spreadsheet file.
IsSpreadsheetObjectChecks if a specified object is a spreadsheet object.
SpreadsheetAddColumnAdds a column or column data to an Excel spreadsheet object.
SpreadsheetAddFreezePaneAdds frozen pane to a spreadsheet.
SpreadsheetAddImageAdds an image to an Excel spreadsheet object.
SpreadsheetAddInfoAdds information to an Excel spreadsheet object.
SpreadsheetAddRowAdds a row to an Excel spreadsheet object.
SpreadsheetAddRowsAdds multiple rows from a query to an Excel spreadsheet object.
SpreadsheetAddSplitPaneAdds a split pane to a spreadsheet.
SpreadsheetCreateSheetCreates a spreadsheet from a given spreadsheet object.
SpreadsheetDeleteColumnDeletes data from a column of an Excel spreadsheet object.
SpreadsheetDeleteColumnsDeletes data from multiple columns of an Excel spreadsheet object.
SpreadsheetDeleteRowDeletes all data from a row of an Excel spreadsheet object.
SpreadsheetDeleteRowsDeletes all data from multiple rows of an Excel spreadsheet object.
SpreadsheetFormatCellFormats the contents of a single cell of an Excel spreadsheet object.
SpreadsheetFormatCellRangeFormats the cells within the given range of an Excel spreadsheet object.
SpreadsheetFormatColumnFormats the contents of a single column of an Excel spreadsheet object.
SpreadsheetFormatColumnsFormats the contents of multiple columns of an Excel spreadsheet object.
SpreadsheetFormatRowFormats the contents of a single row of an Excel spreadsheet object.
SpreadsheetFormatRowsFormats the contents of multiple rows of an Excel spreadsheet object.
SpreadsheetGetCellCommentGets the comment for an Excel spreadsheet object cell as a structure with formatting information, or all comments for the object.
SpreadsheetGetCellFormulaGets the formula for a for an Excel spreadsheet object cell, or all formulas for the object.
SpreadsheetGetCellValueGets the cell value of an Excel spreadsheet object.
SpreadsheetInfoReturns the properties of a spreadsheet object.
SpreadsheetMergeCellsMerges a rectangular block of two or more Excel spreadsheet object cells.
SpreadsheetNewCreates a ColdFusion spreadsheet object, which represents a single sheet of an Excel document.
SpreadsheetReadReads a sheet from a spreadsheet file and stores it in a ColdFusion spreadsheet object.
SpreadsheetReadBinaryReads a spreadsheet file into a binary object.
SpreadsheetRemoveSheetDeletes a sheet from an Excel spreadsheet object.
SpreadsheetSetActiveSheetSets active sheet in a given spreadsheet.
SpreadsheetSetActiveSheetNumberSets the number of active sheets in a given spreadsheet.
SpreadsheetSetCellCommentSpecifies the cell comment for an Excel spreadsheet object.
SpreadsheetSetCellFormulaSpecifies the formula for an Excel spreadsheet object cell.
SpreadsheetSetCellValueSets the cell value of an Excel spreadsheet object.
SpreadsheetSetColumnWidthSets the width of a column in a worksheet.
SpreadsheetSetFooterAdds a footer to the specified worksheet.
SpreadsheetSetHeaderAdds a header to the specified worksheet.
SpreadsheetSetRowHeightSets the height of a row in a worksheet.
SpreadsheetShiftColumnsShifts one or more columns in an Excel spreadsheet object to the left or right.
SpreadsheetShiftRowsShifts one or more rows in an Excel spreadsheet object to the left or right.
SpreadsheetWriteWrites a spreadsheet object to a file.

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page