All functions

createNamedRegion() deleteNamedRegion()

Create / delete a named region.

activeSheet() `activeSheet<-`()

Get/set active sheet of the workbook

addCreator()

Add another author to the meta data of the file.

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

as.character(<formula>)

as.character.formula()

auto_heights()

Compute optimal row heights

buildWorkbook()

Build Workbook

cloneWorksheet()

Clone a worksheet to a workbook

col2int()

Convert Excel column to integer

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

createStyle()

Create a cell style

createWorkbook()

Create a new Workbook object

dataValidation()

Add data validation to cells

deleteData()

Delete cell data

deleteDataColumn()

Deletes a whole column from a workbook

freezePane()

Freeze a worksheet pane

getBaseFont()

Return the workbook default font

getCellRefs()

Return excel cell coordinates from (x,y) coordinates

getCreators()

Add another author to the meta data of the file.

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

get_worksheet_entries()

Get entries from workbook worksheet

groupColumns()

Group columns

groupRows()

Group Rows

`%||%`

If NULL then ...

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-package openxlsx

xlsx reading, writing and editing.

openxlsxFontSizeLookupTable openxlsxFontSizeLookupTableBold

Font Size Lookup tables

op.openxlsx openxlsx_getOp() openxlsx_setOp()

openxlsx Options

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

setLastModifiedBy()

Add another author to the meta data of the file.

setRowHeights()

Set worksheet row heights

setWindowSize() getWindowSize()

Set and Get Window Size for xlsx file

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.

temp_xlsx()

helper function to create tempory directory for testing purpose

ungroupColumns()

Ungroup Columns

ungroupRows()

Ungroup Rows

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