Learn R Programming

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

openxlsx (version 2.4.0)

Read, Write and Edit XLSX Files

Description

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.

Copy Link

Version

Install

install.packages('openxlsx')

Monthly Downloads

376,325

Version

2.4.0

License

GPL-3

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/awalker89/openxlsx

Maintainer

Alexander Walker

Last Published

March 7th, 2015

Functions in openxlsx (2.4.0)

removeCellMerge

Create a new Workbook object

convertFromExcelRef

Convert excel column name to integer index

Freeze a worksheet pane

Add a worksheet to a workbook

Add a style to a set of cells

Merge cells within a worksheet

Load an exisiting .xlsx file

conditionalFormat

Add conditional formatting to cells

convertToDateTime

Convert from excel time number to R POSIXct type.

conditionalFormatting

Add conditional formatting to cells

Create a new Workbook object

Return excel cell coordinates from (x,y) coordinates

Delete cell data

Insert the current plot into a worksheet

removeRowHeights

Remove custom row heights from a worksheet

setHeaderFooter

Set document headers and footers

Set worksheet row heights

Convert from excel date number to R Date type

Return the workbook defaul font

Read data from a worksheet or Workbook object into a data.frame

xlsx reading, writing and editing.

removeWorksheet

Remove a worksheet from a workbook

renameWorksheet

Rename an exisiting worksheet

Set worksheet column widths

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

Create a cell style

get or set worksheet names

Replace an existing cell style

Returns a list of all styles in the workbook

Return the date origin used internally by an xlsx or xlsm file

Read data from a worksheet into a data.frame

removeColWidths

Remove custom column widths from a worksheet

save Workbook to file

add filters to columns

removes worksheet filter from addFilter and writeData

Write to a worksheet and format as a table

Order of worksheets in xlsx file

Set header for all worksheets

write directly to an xlsx file

Insert an image into a worksheet

Set worksheet gridlines to show or hide.

Set page margins, orientation and print scaling

Set footer for all worksheets

Modify the default font

Write an object to a worksheet

Returns names of worksheets.