All functions

addFilter()

Add column filters

addStyle()

Add a style to a set of cells

addWorksheet()

Add a worksheet to a workbook

all.equal(<Workbook>)

Check equality of workbooks

cloneWorksheet()

Clone a worksheet to a workbook

conditionalFormat()

Add conditional formatting to cells

conditionalFormatting()

Add conditional formatting to cells

convertFromExcelRef()

Convert excel column name to integer index

convertToDate()

Convert from excel date number to R Date type

convertToDateTime()

Convert from excel time number to R POSIXct type.

copyWorkbook()

Copy a Workbook object.

createComment()

create a Comment object

createNamedRegion()

Create a named region.

createStyle()

Create a cell style

createWorkbook()

Create a new Workbook object

dataValidation()

Add data validation to cells

deleteData()

Delete cell data

freezePane()

Freeze a worksheet pane

getBaseFont()

Return the workbook default font

getCellRefs()

Return excel cell coordinates from (x,y) coordinates

getDateOrigin()

Get the date origin an xlsx file is using

getNamedRegions()

Get named regions

getSheetNames()

Get names of worksheets

getStyles()

Returns a list of all styles in the workbook

getTables()

List Excel tables in a workbook

insertImage()

Insert an image into a worksheet

insertPlot()

Insert the current plot into a worksheet

int2col()

Convert integer to Excel column

loadWorkbook()

Load an existing .xlsx file

makeHyperlinkString()

create Excel hyperlink string

mergeCells()

Merge cells within a worksheet

modifyBaseFont()

Modify the default font

names(<Workbook>) `names<-`(<Workbook>)

get or set worksheet names

openXL()

Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook

openxlsx

xlsx reading, writing and editing.

pageBreak()

add a page break to a worksheet

pageSetup()

Set page margins, orientation and print scaling

protectWorkbook()

Protect a workbook from modifications

protectWorksheet()

Protect a worksheet from modifications

read.xlsx()

Read from an Excel file or Workbook object

readWorkbook()

Read from an Excel file or Workbook object

removeCellMerge()

Create a new Workbook object

removeColWidths()

Remove column widths from a worksheet

removeComment()

Remove a comment from a cell

removeFilter()

Remove a worksheet filter

removeRowHeights()

Remove custom row heights from a worksheet

removeTable()

Remove an Excel table in a workbook

removeWorksheet()

Remove a worksheet from a workbook

renameWorksheet()

Rename a worksheet

replaceStyle()

Replace an existing cell style

saveWorkbook()

save Workbook to file

setColWidths()

Set worksheet column widths

setFooter()

Set footer for all worksheets

setHeader()

Set header for all worksheets

setHeaderFooter()

Set document headers and footers

setRowHeights()

Set worksheet row heights

sheetVisibility() `sheetVisibility<-`()

Get/set worksheet visible state

sheetVisible() `sheetVisible<-`()

Get worksheet visible state.

sheets()

Returns names of worksheets.

showGridLines()

Set worksheet gridlines to show or hide.

worksheetOrder() `worksheetOrder<-`()

Order of worksheets in xlsx file

write.xlsx()

write data to an xlsx file

writeComment()

write a cell comment

writeData()

Write an object to a worksheet

writeDataTable()

Write to a worksheet as an Excel table

writeFormula()

Write a character vector as an Excel Formula