Last updated on
Oct 27, 2023
| Function | Description |
| IsSpreadsheetFile | Checks if a specified file is a spreadsheet file. |
| IsSpreadsheetObject | Checks if a specified object is a spreadsheet object. |
| SpreadsheetAddColumn | Adds a column or column data to an Excel spreadsheet object. |
| SpreadsheetAddFreezePane | Adds frozen pane to a spreadsheet. |
| SpreadsheetAddImage | Adds an image to an Excel spreadsheet object. |
| SpreadsheetAddInfo | Adds information to an Excel spreadsheet object. |
| SpreadsheetAddRow | Adds a row to an Excel spreadsheet object. |
| SpreadsheetAddRows | Adds multiple rows from a query to an Excel spreadsheet object. |
| SpreadsheetAddSplitPane | Adds a split pane to a spreadsheet. |
| SpreadsheetCreateSheet | Creates a spreadsheet from a given spreadsheet object. |
| SpreadsheetDeleteColumn | Deletes data from a column of an Excel spreadsheet object. |
| SpreadsheetDeleteColumns | Deletes data from multiple columns of an Excel spreadsheet object. |
| SpreadsheetDeleteRow | Deletes all data from a row of an Excel spreadsheet object. |
| SpreadsheetDeleteRows | Deletes all data from multiple rows of an Excel spreadsheet object. |
| SpreadsheetFormatCell | Formats the contents of a single cell of an Excel spreadsheet object. |
| SpreadsheetFormatCellRange | Formats the cells within the given range of an Excel spreadsheet object. |
| SpreadsheetFormatColumn | Formats the contents of a single column of an Excel spreadsheet object. |
| SpreadsheetFormatColumns | Formats the contents of multiple columns of an Excel spreadsheet object. |
| SpreadsheetFormatRow | Formats the contents of a single row of an Excel spreadsheet object. |
| SpreadsheetFormatRows | Formats the contents of multiple rows of an Excel spreadsheet object. |
| SpreadsheetGetCellComment | Gets the comment for an Excel spreadsheet object cell as a structure with formatting information, or all comments for the object. |
| SpreadsheetGetCellFormula | Gets the formula for a for an Excel spreadsheet object cell, or all formulas for the object. |
| SpreadsheetGetCellValue | Gets the cell value of an Excel spreadsheet object. |
| SpreadsheetInfo | Returns the properties of a spreadsheet object. |
| SpreadsheetMergeCells | Merges a rectangular block of two or more Excel spreadsheet object cells. |
| SpreadsheetNew | Creates a ColdFusion spreadsheet object, which represents a single sheet of an Excel document. |
| SpreadsheetRead | Reads a sheet from a spreadsheet file and stores it in a ColdFusion spreadsheet object. |
| SpreadsheetReadBinary | Reads a spreadsheet file into a binary object. |
| SpreadsheetRemoveSheet | Deletes a sheet from an Excel spreadsheet object. |
| SpreadsheetSetActiveSheet | Sets active sheet in a given spreadsheet. |
| SpreadsheetSetActiveSheetNumber | Sets the number of active sheets in a given spreadsheet. |
| SpreadsheetSetCellComment | Specifies the cell comment for an Excel spreadsheet object. |
| SpreadsheetSetCellFormula | Specifies the formula for an Excel spreadsheet object cell. |
| SpreadsheetSetCellValue | Sets the cell value of an Excel spreadsheet object. |
| SpreadsheetSetColumnWidth | Sets the width of a column in a worksheet. |
| SpreadsheetSetFooter | Adds a footer to the specified worksheet. |
| SpreadsheetSetHeader | Adds a header to the specified worksheet. |
| SpreadsheetSetRowHeight | Sets the height of a row in a worksheet. |
| SpreadsheetShiftColumns | Shifts one or more columns in an Excel spreadsheet object to the left or right. |
| SpreadsheetShiftRows | Shifts one or more rows in an Excel spreadsheet object to the left or right. |
| SpreadsheetWrite | Writes a spreadsheet object to a file. |