Learn R Programming

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

openxlsx (version 1.0.3)

.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

1.0.3

License

GPL-3

Maintainer

Alexander Walker

Last Published

April 21st, 2014

Functions in openxlsx (1.0.3)

Merge cells within a worksheet

Modify the default font

Insert the current plot into a worksheet

Freeze a worksheet pane

convertFromExcelRef

Convert excel column name to integer index

Create a cell style

conditionalFormat

Add conditional formatting to cells

Create a new Workbook object

Return excel cell coordinates from (x,y) coordinates

Add a style to a set of cells

Delete cell data

Add a worksheet to a workbook

Returns a list of all styles in the workbook

Load an exisiting .xlsx file

Returns ordering of sorted cell references

removeRowHeights

Remove custom row heights from a worksheet

Read data from a worksheet into a data.frame

Set header for all worksheets

save Workbook to file

Set worksheet gridlines to show or hide.

renameWorksheet

Rename an exisiting worksheet

Set footer for all worksheets

Write to a worksheet

Write to a worksheet and format as a table

removeColWidths

Remove custom column widths from a worksheet

Set worksheet column widths

Set page margins, orientation and print scaling

Replace an existing cell style

Set worksheet row heights

Read data from a worksheet into a data.frame

Insert an image into a worksheet

removeCellMerge

Create a new Workbook object

removeWorksheet

Remove a worksheet from a workbook

Returns names of worksheets.