Removes the split pane/freeze pane from the specified worksheet.
1 2 3 4
The name or index of the sheet from which to remove the split pane/freeze pane
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.
When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. For example, you might want to keep row and column labels visible as you scroll.
When you split panes, you create separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.
Mirai Solutions GmbH http://www.mirai-solutions.com
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
# 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)
Loading required package: XLConnectJars OpenJDK 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed XLConnect 0.2-12 by Mirai Solutions GmbH [aut], Martin Studer [cre], The Apache Software Foundation [ctb, cph] (Apache POI, Apache Commons Codec), Stephen Colebourne [ctb, cph] (Joda-Time Java library), Graph Builder [ctb, cph] (Curvesapi Java library) http://www.mirai-solutions.com , http://miraisolutions.wordpress.com ZoneInfo: /usr/share/javazi/ZoneInfoMappings (Permission denied) Warning message: system call failed: Cannot allocate memory
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.