spreadsheetAddSplitPane

Adds split pane to spreadsheet.

spreadsheetAddSplitPane(spreadsheetObj, x, y, splitColumn, splitRow [, position]) → returns void

spreadsheetAddSplitPane Argument Reference

spreadsheetObj variableName
Required

Spreadsheet variable

x numeric
Required

X position for split

y numeric
Required

Y position for split

splitColumn numeric
Required

Split Column

splitRow numeric
Required

Split Row

position string

Specify which pane has the focus
Values:
  • LOWER_LEFT
  • LOWER_RIGHT
  • UPPER_LEFT
  • UPPER_RIGHT

Examples sample code invoking the spreadsheetAddSplitPane function

Here,we've example to splitpane in excel using spreadsheetaddsplitpane.

<cfset Detail=SpreadsheetNew("student",false)>
<cfset SpreadSheetAddRow(Detail,"id,Name,Department,marks,average")>
<cfset SpreadSheetAddRow(Detail,"1,Dhar,CS,500,50")>
<cfset SpreadSheetAddRow(Detail,"2,DharC,EEE,600,85")>
<cfset SpreadSheetAddRow(Detail,"3,DharCf,EC,700,90")>
<cfset SpreadsheetAddSplitPane(Detail,2000, 2000, 4, 3)>
<cfset SpreadsheetWrite(Detail,expandPath("./Detail.xls"),true)>

Fork me on GitHub