xlsx.addLineBreak: Add a line break to a worksheet

In kassambara/r2excel: Read, write and format Excel files in R

Description

Add a line break to a worksheet.

Usage

xlsx.addLineBreak(sheet, numberOfLine = 1)

Arguments

sheet	Sheet object
numberOfLine	number of rows to skip before appending the data

Author(s)

Alboukadel Kassambara <[e-mail]>

References

http://www.sthda.com

Examples

# create an Excel workbook. Both .xls and .xlsx file formats can be used.
wb <- createWorkbook(type="xlsx")
# Create a sheet in that workbook
sheet <- xlsx::createSheet(wb, sheetName = "example1")
 
# Add line break
xlsx.addHeader(wb, sheet, value="Header 1",level=1, color="black")
xlsx.addLineBreak(sheet, 3)
xlsx.addHeader(wb, sheet, value="Header 2",level=1, color="black")

# saving a workbook to an Excel file and write the file to the disk.
saveWorkbook(wb, "examples_add_linebreak.xlsx")

kassambara/r2excel documentation built on May 20, 2019, 7:40 a.m.