openxlsx v4.1.0


Monthly downloads



Read, Write and Edit XLSX Files

Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.



This R package simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.


Stable version

Current stable version is available on CRAN via

install.packages("openxlsx", dependencies = TRUE)

Development version

install.packages(c("Rcpp", "devtools"), dependencies = TRUE)

Bug/feature request

Please let me know which version of openxlsx you are using when posting bug reports.


Thanks, here.



Authors and Contributors

A list is automagically maintained here.

Functions in openxlsx

Name Description
getBaseFont Return the workbook default font
makeHyperlinkString create Excel hyperlink string
removeCellMerge Create a new Workbook object
int2col Convert integer to Excel column
getSheetNames Get names of worksheets
removeColWidths Remove column widths from a worksheet
removeWorksheet Remove a worksheet from a workbook
getNamedRegions Get named regions
removeComment Remove a comment from a cell
renameWorksheet Rename a worksheet
setHeader Set header for all worksheets
setRowHeights Set worksheet row heights
pageBreak add a page break to a worksheet
removeFilter Remove a worksheet filter
pageSetup Set page margins, orientation and print scaling
setFooter Set footer for all worksheets
setColWidths Set worksheet column widths
mergeCells Merge cells within a worksheet
loadWorkbook Load an existing .xlsx file
read.xlsx Read from an Excel file or Workbook object
sheetVisibility Get/set worksheet visible state
writeFormula Write a character vector as an Excel Formula
getStyles Returns a list of all styles in the workbook
setHeaderFooter Set document headers and footers
names get or set worksheet names
modifyBaseFont Modify the default font
getTables List Excel tables in a workbook
write.xlsx write data to an xlsx file
getDateOrigin Get the date origin an xlsx file is using
readWorkbook Read from an Excel file or Workbook object
insertPlot Insert the current plot into a worksheet
insertImage Insert an image into a worksheet
openXL Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
openxlsx xlsx reading, writing and editing.
writeComment write a cell comment
removeRowHeights Remove custom row heights from a worksheet
saveWorkbook save Workbook to file
replaceStyle Replace an existing cell style
removeTable Remove an Excel table in a workbook
sheetVisible Get worksheet visible state.
showGridLines Set worksheet gridlines to show or hide.
worksheetOrder Order of worksheets in xlsx file
sheets Returns names of worksheets.
writeData Write an object to a worksheet
writeDataTable Write to a worksheet as an Excel table
addFilter Add column filters
addStyle Add a style to a set of cells
addWorksheet Add a worksheet to a workbook
all.equal Check equality of workbooks
conditionalFormat Add conditional formatting to cells
getCellRefs Return excel cell coordinates from (x,y) coordinates
freezePane Freeze a worksheet pane
conditionalFormatting Add conditional formatting to cells
convertToDate Convert from excel date number to R Date type
convertFromExcelRef Convert excel column name to integer index
createStyle Create a cell style
createWorkbook Create a new Workbook object
convertToDateTime Convert from excel time number to R POSIXct type.
copyWorkbook Copy a Workbook object.
dataValidation Add data validation to cells
deleteData Delete cell data
createComment create a Comment object
createNamedRegion Create a named region.
No Results!

Vignettes of openxlsx

No Results!

Last month downloads


Type Package
Date 2018-05-26
License MIT + file LICENSE
LinkingTo Rcpp
Encoding UTF-8
VignetteBuilder knitr
Collate 'CommentClass.R' 'HyperlinkClass.R' 'RcppExports.R' 'class_definitions.R' 'StyleClass.R' 'WorkbookClass.R' 'baseXML.R' 'borderFunctions.R' 'chartsheet_class.R' 'conditional_formatting.R' 'helperFunctions.R' 'loadWorkbook.R' 'onUnload.R' 'openXL.R' 'openxlsx.R' 'openxlsxCoerce.R' 'readWorkbook.R' 'sheet_data_class.R' 'workbook_column_widths.R' 'workbook_read_workbook.R' 'workbook_write_data.R' 'worksheet_class.R' 'wrappers.R' 'writeData.R' 'writeDataTable.R' 'writexlsx.R'
NeedsCompilation yes
Packaged 2018-05-26 13:55:02 UTC; Alex
Repository CRAN
Date/Publication 2018-05-26 15:20:49 UTC

Include our badge in your README