Learn R Programming

⚠️There's a newer version (4.2.7) 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", "remotes"), dependencies = TRUE)
remotes::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

Copy Link

Version

Install

install.packages('openxlsx')

Monthly Downloads

346,643

Version

4.2.6.1

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/ycphs/openxlsx

Homepage

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

Maintainer

Jan Marvin Garbuszus

Last Published

July 23rd, 2024

Functions in openxlsx (4.2.6.1)

Return the workbook default font

Return excel cell coordinates from (x,y) coordinates

List Excel tables in a workbook

create a Comment object

Delete cell data

Add data validation to cells

Returns a list of all styles in the workbook

Insert an image into a worksheet

makeHyperlinkString

create Excel hyperlink string

Load an existing .xlsx file

Freeze a worksheet pane

If NULL then ...

deleteDataColumn

Deletes a whole column from a workbook

Convert integer to Excel column

getNamedRegions

Get named regions

Insert the current plot into a worksheet

Get names of worksheets

Get the date origin an xlsx file is using

Add another author to the meta data of the file.

xlsx reading, writing and editing.

openxlsx_options

openxlsx Options

add a page break to a worksheet

Merge cells within a worksheet

Read from an Excel file or Workbook object

removeCellMerge

Create a new Workbook object

get or set worksheet names

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

removeColWidths

Remove column widths from a worksheet

Remove an Excel table in a workbook

protectWorksheet

Protect a worksheet from modifications

Modify the default font

Read from an Excel file or Workbook object

Set footer for all worksheets

Remove a comment from a cell

setHeaderFooter

Set document headers and footers

setLastModifiedBy

Add another author to the meta data of the file.

removeWorksheet

Remove a worksheet from a workbook

Set page margins, orientation and print scaling

protectWorkbook

Protect a workbook from modifications

Order of worksheets in xlsx file

Set worksheet row heights

Set worksheet gridlines to show or hide.

sheetVisibility

Get/set worksheet visible state

Set header for all worksheets

save Workbook to file

write a cell comment

Write an object to a worksheet

openxlsxFontSizeLookupTable

Font Size Lookup tables

Remove a worksheet filter

Returns names of worksheets.

Set worksheet column widths

renameWorksheet

Rename a worksheet

Replace an existing cell style

write data to an xlsx file

Write a character vector as an Excel Formula

Get worksheet visible state.

removeRowHeights

Remove custom row heights from a worksheet

Ungroup Columns

helper function to create tempory directory for testing purpose

Write to a worksheet as an Excel table

Add a style to a set of cells

Check equality of workbooks

Clone a worksheet to a workbook

Add another author to the meta data of the file.

Get/set active sheet of the workbook

createNamedRegion

Create / delete a named region.

as.character.formula

as.character.formula()

Add a worksheet to a workbook

Add column filters

Convert Excel column to integer

convertToDateTime

Convert from excel time number to R POSIXct type.

Create a cell style

conditionalFormat

Add conditional formatting to cells

Copy a Workbook object.

convertFromExcelRef

Convert excel column name to integer index

Convert from excel date number to R Date type

conditionalFormatting

Add conditional formatting to cells

Create a new Workbook object