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.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy