XLConnect (version 0.2-15)

removePane-methods: Removing panes from worksheet

Description

Removes the split pane/freeze pane from the specified worksheet.

Usage

# S4 method for workbook,character
removePane(object,sheet)
# S4 method for workbook,numeric
removePane(object,sheet)

Arguments

object

The '>workbook to use

sheet

The name or index of the sheet from which to remove the split pane/freeze pane

References

How to create a freeze pane/split pane in Office 2007 http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx

See Also

'>workbook createFreezePane createSplitPane

Examples

# NOT RUN {
# Load workbook (create if not existing)
wb <- loadWorkbook("removePaneTest.xlsx", create = TRUE)

# Create a worksheet named 'Sheet1'
createSheet(wb, name = "Sheet1")

# Create a split pane on Sheet1, with coordinates (10000, 5000) expressed as 1/20th of a point,
# 10 (-> J) as left column visible in right pane and 10 as top row visible in bottom pane 
createSplitPane(wb, "Sheet1", 10000, 5000, 10, 10)

# Remove the split pane from Sheet1
removePane(wb, "Sheet1")

# Save workbook (this actually writes the file to disk). Now the workbook has no split pane.
saveWorkbook(wb)
# }

Run the code above in your browser using DataCamp Workspace