pageBreak: add a page break to a worksheet
In awalker89/openxlsx: Read, Write and Edit XLSX Files
Description
Usage
Arguments
See Also
Examples
Description
insert page breaks into a worksheet
Usage
1
Arguments
wb
A workbook object
sheet
A name or index of a worksheet
i
row or column number to insert page break.
type
One of "row" or "column" for a row break or column break.
See Also
Examples
1
2
3
4
5
6
7
8
9
10
wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
writeData(wb, sheet = 1, x = iris)
pageBreak(wb, sheet = 1, i = 10, type = "row")
pageBreak(wb, sheet = 1, i = 20, type = "row")
pageBreak(wb, sheet = 1, i = 2, type = "column")
saveWorkbook(wb, "pageBreakExample.xlsx", TRUE)
## In Excel: View tab -> Page Break Preview
awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments See Also Examples
Description
insert page breaks into a worksheet
Usage
1 |
Arguments
wb |
A workbook object |
sheet |
A name or index of a worksheet |
i |
row or column number to insert page break. |
type |
One of "row" or "column" for a row break or column break. |
See Also
Examples
1 2 3 4 5 6 7 8 9 10 | wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
writeData(wb, sheet = 1, x = iris)
pageBreak(wb, sheet = 1, i = 10, type = "row")
pageBreak(wb, sheet = 1, i = 20, type = "row")
pageBreak(wb, sheet = 1, i = 2, type = "column")
saveWorkbook(wb, "pageBreakExample.xlsx", TRUE)
## In Excel: View tab -> Page Break Preview
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.