Whatever message this page gives is out now! Go check it out!
spreadsheetGetPrintOrientation
Last update:
May 18, 2026
Description
Retrieves the type of orientation, landscape or portrait, of a spreadsheet.
Returns
Landscape or portrait mode.
History
- ColdFusion (2025 release): Added the function.
Syntax
spreadsheetGetPrintOrientation(Object spreadsheet)Parameters
Name | Required | Type | Description |
spreadSheetObject | Yes | ExcelInfo | The Excel spreadsheet object to which you must set the print orientation to landscape or portrait. |
Example
<cfquery name="art" datasource="cfartgallery">
SELECT * FROM ART
</cfquery>
<cfscript>
theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-file.xls";
// create a spreadsheet object
theSheet=spreadsheetNew("SampleData")
// add rows from the table to the spreadsheet
spreadsheetAddRows(theSheet,art)
// set print orientation
try{
spreadsheetSetPrintOrientation(theSheet,"portrait","SampleData")
writeOutput("Print orientation set successfully" & "<br/>")
}
catch (any e){
writeOutput(e.message)
}
// get the print orientation
getOrientation=spreadsheetGetPrintOrientation(theSheet)
writeOutput("Print orientation is: " & getOrientation)
</cfscript>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
