Learn R Programming

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

openxlsx (version 2.2.1)

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

392,565

Version

2.2.1

License

GPL-3

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/awalker89/openxlsx

Maintainer

Alexander Walker

Last Published

October 18th, 2014

Functions in openxlsx (2.2.1)

Returns a list of all styles in the workbook

Create a new Workbook object

Delete cell data

Freeze a worksheet pane

Set page margins, orientation and print scaling

removeWorksheet

Remove a worksheet from a workbook

removeCellMerge

Create a new Workbook object

save Workbook to file

Set worksheet row heights

removeColWidths

Remove custom column widths from a worksheet

Insert the current plot into a worksheet

Return the workbook defaul font

Add a worksheet to a workbook

renameWorksheet

Rename an exisiting worksheet

convertToDateTime

Convert from excel time number to R POSIXct type.

add filters to columns

Set worksheet gridlines to show or hide.

Convert from excel date number to R Date type

Insert an image into a worksheet

conditionalFormat

Add conditional formatting to cells

Write an object to a worksheet

Read data from a worksheet into a data.frame

Replace an existing cell style

Set header for all worksheets

Add a style to a set of cells

convertFromExcelRef

Convert excel column name to integer index

xlsx reading, writing and editing.

Create a cell style

setHeaderFooter

Set document headers and footers

Returns names of worksheets.

Set worksheet column widths

Modify the default font

Load an exisiting .xlsx file

Order of worksheets in xlsx file

write directly to an xlsx file

get or set worksheet names

Set footer for all worksheets

Merge cells within a worksheet

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

Read data from a worksheet into a data.frame

removes worksheet filter from addFilter and writeData

Write to a worksheet and format as a table

removeRowHeights

Remove custom row heights from a worksheet

Return excel cell coordinates from (x,y) coordinates