Learn R Programming

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

417,604

Version

4.2.7.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

September 20th, 2024

Functions in openxlsx (4.2.7.1)

conditionalFormat

Add conditional formatting to cells

Add another author to the meta data of the file.

Convert Excel column to integer

Return the workbook default font

Return excel cell coordinates from (x,y) coordinates

deleteDataColumn

Deletes a whole column from a workbook

convertToDateTime

Convert from excel time number to R POSIXct type.

Freeze a worksheet pane

Convert from excel date number to R Date type

Get names of worksheets

Clone a worksheet to a workbook

If NULL then ...

getNamedRegions

Get named regions

Copy a Workbook object.

Create a cell style

Create a new Workbook object

create a Comment object

makeHyperlinkString

create Excel hyperlink string

List Excel tables in a workbook

Get the date origin an xlsx file is using

Returns a list of all styles in the workbook

get or set worksheet names

Modify the default font

Add data validation to cells

Remove a comment from a cell

Merge cells within a worksheet

Remove a worksheet filter

protectWorkbook

Protect a workbook from modifications

get_worksheet_entries

Get entries from workbook worksheet

Convert integer to Excel column

protectWorksheet

Protect a worksheet from modifications

Load an existing .xlsx file

renameWorksheet

Rename a worksheet

removeWorksheet

Remove a worksheet from a workbook

save Workbook to file

Ungroup Columns

Read from an Excel file or Workbook object

Insert an image into a worksheet

Replace an existing cell style

Insert the current plot into a worksheet

openxlsxFontSizeLookupTable

Font Size Lookup tables

sheetVisibility

Get/set worksheet visible state

removeCellMerge

Create a new Workbook object

Set and Get Window Size for xlsx file

openxlsx_options

openxlsx Options

Remove an Excel table in a workbook

removeRowHeights

Remove custom row heights from a worksheet

write data to an xlsx file

Read from an Excel file or Workbook object

Set worksheet row heights

Order of worksheets in xlsx file

setLastModifiedBy

Add another author to the meta data of the file.

write a cell comment

Delete cell data

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

add a page break to a worksheet

removeColWidths

Remove column widths from a worksheet

Set header for all worksheets

Get worksheet visible state.

Set worksheet column widths

Write to a worksheet as an Excel table

helper function to create tempory directory for testing purpose

Set footer for all worksheets

Set page margins, orientation and print scaling

xlsx reading, writing and editing.

Returns names of worksheets.

setHeaderFooter

Set document headers and footers

Write an object to a worksheet

Write a character vector as an Excel Formula

Set worksheet gridlines to show or hide.

Check equality of workbooks

as.character.formula

as.character.formula()

createNamedRegion

Create / delete a named region.

Get/set active sheet of the workbook

Add another author to the meta data of the file.

Convert to POSIXct with timezone UTC

Add column filters

Compute optimal row heights

conditionalFormatting

Add conditional formatting to cells

convertFromExcelRef

Convert excel column name to integer index

Add a style to a set of cells

Add a worksheet to a workbook