spreadsheetAddSplitPane

Adds split pane to spreadsheet.

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

  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetAddSplitPane
  5. CF
  6. 0 Issue
  7. Edit

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)>

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub