add a page break to a worksheet
insert page breaks into a worksheet
pageBreak(wb, sheet, i, type = "row")
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. |
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") ## Not run: saveWorkbook(wb, "pageBreakExample.xlsx", TRUE) ## End(Not run) ## In Excel: View tab -> Page Break Preview
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.