You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.
Click the button below to launch CFFiddle.
To copy the project in your workspace in CFFiddle, follow the steps below:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- Give the project a suitable name and click Save.
Description
Writes single sheet to a new XLS file from a ColdFusion spreadsheet object.
Category
Microsoft Office Integration
Function syntax
SpreadsheetWrite(spreadsheet,filePath,[password,overwrite,autosize]) SpreadsheetWrite(spreadsheet,filePath) |
See also
SpreadsheetRead, SpreadsheetAddRow, SpreadsheetAddRows, SpreadsheetDeleteRow, SpreadsheetDeleteRows,
SpreadsheetFormatRow, SpreadsheetFormatRows, SpreadsheetShiftColumns
History
ColdFusion (2018 release): Introduced named parameters.
ColdFusion 11: Added the autosize parameter.
ColdFusion 9: Added the function.
Parameters
Parameter |
Description |
|---|---|
spreadsheet |
The Excel spreadsheet object to which to write. |
filePath |
The pathname of the file that is written. |
overwrite |
(Default: false) A Boolean value specifying whether to overwrite an existing file. Specify yes to overwrite. |
password |
Password to protect the active sheet. This attribute is supported for both XLS and XLSX files. |
| autosize | (Default: true) Auto re-size the column, if required. You can specify either a Boolean value or an array of integers denoting the columns to expand. If you specify an array, it must contain the column numbers that needs to be re-sized. |
Usage
Use this function to:
- Write multiple sheets to a single file.
- Update an existing file, read all sheets in the file, modify one or more sheets, and to rewrite the entire file.
Example
spreadsheet = SpreadSheetRead("C:\Files\Report.xls","Annual Report"); |
Example 2
spObj = spreadsheetread("#dirname#SingleSheet.xls","Sheet2"); |
Example 3
| SpreadSheetWrite method usage: SpreadSheetWrite(SpreadsheetObj, filename, password, overwrite, autosize) ---> <cfset colList ="col1,col2,col3,col4,col5,col6,col7,col8,co9,col0"> <cfset rowCount = 100> <cfset qryObj = QueryNew("#colList#")> <cfset QueryAddRow(qryObj, #rowCount#)> <cfloop from="1" to="#rowCount#" index="r"> <cfloop from="1" to="#ListLen(colList)#" index="c"> <cfset QuerySetCell(qryObj, #ListGetAt(colList,c)#, "some random text r#r# c#c#", r)> </cfloop> </cfloop> <cfset xlObj = spreadsheetNew("testsheet", true)> <cfset spreadsheetAddRows(xlObj, "#qryObj#")> <cfset spreadsheetwrite(xlObj, "#Expandpath("./")#test_autosize_ss_method.xlsx", "", true, false)> |
Sign in to your account