Learn R Programming

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

openxlsx (version 2.0.1)

.xlsx reading, writing and editing.

Description

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

Copy Link

Version

Install

install.packages('openxlsx')

Monthly Downloads

397,276

Version

2.0.1

License

GPL-3

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/awalker89/openxlsx

Maintainer

Alexander Walker

Last Published

May 29th, 2014

Functions in openxlsx (2.0.1)

Set footer for all worksheets

Insert an image into a worksheet

Read data from a worksheet into a data.frame

Load an exisiting .xlsx file

conditionalFormat

Add conditional formatting to cells

Read data from a worksheet into a data.frame

removeRowHeights

Remove custom row heights from a worksheet

Returns ordering of sorted cell references

Write an object to a worksheet

Insert the current plot into a worksheet

Set worksheet row heights

Add a worksheet to a workbook

Add a style to a set of cells

Delete cell data

renameWorksheet

Rename an exisiting worksheet

Modify the default font

Return excel cell coordinates from (x,y) coordinates

Freeze a worksheet pane

Returns a list of all styles in the workbook

Write to a worksheet and format as a table

Merge cells within a worksheet

save Workbook to file

Convert from excel date number to R Date type

Set page margins, orientation and print scaling

removeColWidths

Remove custom column widths from a worksheet

Replace an existing cell style

Set header for all worksheets

xlsx reading, writing and editing.

convertFromExcelRef

Convert excel column name to integer index

Returns names of worksheets.

Order of worksheets in xlsx file

removeCellMerge

Create a new Workbook object

Set worksheet gridlines to show or hide.

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

Create a new Workbook object

Create a cell style

write directly to an xlsx file

removeWorksheet

Remove a worksheet from a workbook

Return the workbook defaul font

get or set worksheet names

convertToDateTime

Convert from excel time number to R as.POSIXct

Set worksheet column widths