Learn R Programming

⚠️There's a newer version (4.2.8) of this package.Take me there.

openxlsx

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.

Installation

Stable version

Current stable version is available on CRAN via

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

Development version

install.packages(c("Rcpp", "devtools"), dependencies = TRUE)
require(devtools)
install_github("ycphs/openxlsx")

Bug/feature request

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

packageVersion("openxlsx")

News

Authors and Contributors for the current release

@awalker89, @aavanesy, @ale275, @alexb523, @david-f1976, @davidgohel, @dovrosenberg, @JoshuaSturm, @SHAESEN2, @soliac, @theclue, and @ycphs

Copy Link

Version

Install

install.packages('openxlsx')

Monthly Downloads

397,276

Version

4.1.5

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/ycphs/openxlsx

Homepage

https://ycphs.github.io/openxlsx/index.html

Maintainer

Philipp Schauberger

Last Published

May 6th, 2020

Functions in openxlsx (4.1.5)

Check equality of workbooks

conditionalFormat

Add conditional formatting to cells

Clone a worksheet to a workbook

Add column filters

Convert from excel date number to R Date type

conditionalFormatting

Add conditional formatting to cells

Add another author to the meta data of the file.

convertFromExcelRef

Convert excel column name to integer index

Add a style to a set of cells

Add a worksheet to a workbook

Freeze a worksheet pane

Get names of worksheets

Return the workbook default font

Create a cell style

Create a new Workbook object

List Excel tables in a workbook

convertToDateTime

Convert from excel time number to R POSIXct type.

Insert an image into a worksheet

Add data validation to cells

getNamedRegions

Get named regions

Copy a Workbook object.

Get worksheet visible state.

xlsx reading, writing and editing.

Get the date origin an xlsx file is using

Delete cell data

get or set worksheet names

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

removeCellMerge

Create a new Workbook object

Returns names of worksheets.

Read from an Excel file or Workbook object

Return excel cell coordinates from (x,y) coordinates

create a Comment object

Add another author to the meta data of the file.

add a page break to a worksheet

createNamedRegion

Create a named region.

Set page margins, orientation and print scaling

removeRowHeights

Remove custom row heights from a worksheet

protectWorkbook

Protect a workbook from modifications

Returns a list of all styles in the workbook

Set footer for all worksheets

Load an existing .xlsx file

setLastModifiedBy

Add another author to the meta data of the file.

Insert the current plot into a worksheet

makeHyperlinkString

create Excel hyperlink string

setHeaderFooter

Set document headers and footers

Convert integer to Excel column

Replace an existing cell style

renameWorksheet

Rename a worksheet

Write to a worksheet as an Excel table

removeWorksheet

Remove a worksheet from a workbook

Write an object to a worksheet

Remove a worksheet filter

Remove an Excel table in a workbook

Merge cells within a worksheet

save Workbook to file

Remove a comment from a cell

write a cell comment

removeColWidths

Remove column widths from a worksheet

Set worksheet row heights

Modify the default font

write data to an xlsx file

sheetVisibility

Get/set worksheet visible state

protectWorksheet

Protect a worksheet from modifications

Set worksheet column widths

Write a character vector as an Excel Formula

Read from an Excel file or Workbook object

Set header for all worksheets

Set worksheet gridlines to show or hide.

Order of worksheets in xlsx file