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("awalker89/openxlsx")

Bug/feature request

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

packageVersion("openxlsx")

Thanks, here.

News

Authors and Contributors

A list is automagically maintained here.

Copy Link

Version

Install

install.packages('openxlsx')

Monthly Downloads

451,411

Version

4.1.0.1

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/awalker89/openxlsx

Maintainer

Alexander Walker

Last Published

May 28th, 2019

Functions in openxlsx (4.1.0.1)

Create a cell style

Add a style to a set of cells

convertFromExcelRef

Convert excel column name to integer index

conditionalFormatting

Add conditional formatting to cells

create a Comment object

Read from an Excel file or Workbook object

conditionalFormat

Add conditional formatting to cells

Set header for all worksheets

removeColWidths

Remove column widths from a worksheet

save Workbook to file

Add a worksheet to a workbook

Check equality of workbooks

Merge cells within a worksheet

Create a new Workbook object

makeHyperlinkString

create Excel hyperlink string

Returns a list of all styles in the workbook

convertToDateTime

Convert from excel time number to R POSIXct type.

Read from an Excel file or Workbook object

Add column filters

Load an existing .xlsx file

Remove an Excel table in a workbook

Add data validation to cells

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

Copy a Workbook object.

removeCellMerge

Create a new Workbook object

Convert integer to Excel column

Delete cell data

Set worksheet column widths

Replace an existing cell style

Freeze a worksheet pane

getNamedRegions

Get named regions

add a page break to a worksheet

write data to an xlsx file

write a cell comment

Return the workbook default font

Set footer for all worksheets

createNamedRegion

Create a named region.

Remove a comment from a cell

List Excel tables in a workbook

Get names of worksheets

Set page margins, orientation and print scaling

setHeaderFooter

Set document headers and footers

xlsx reading, writing and editing.

Get worksheet visible state.

Insert an image into a worksheet

Remove a worksheet filter

Modify the default font

removeRowHeights

Remove custom row heights from a worksheet

Set worksheet row heights

Write an object to a worksheet

Convert from excel date number to R Date type

renameWorksheet

Rename a worksheet

Insert the current plot into a worksheet

Return excel cell coordinates from (x,y) coordinates

Get the date origin an xlsx file is using

Returns names of worksheets.

sheetVisibility

Get/set worksheet visible state

removeWorksheet

Remove a worksheet from a workbook

Write to a worksheet as an Excel table

Set worksheet gridlines to show or hide.

get or set worksheet names

Write a character vector as an Excel Formula

Order of worksheets in xlsx file