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

openxlsx (version 2.0.15)

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

License

GPL-3

Issues

205

Pull Requests

17

Stars

364

Forks

79

Maintainer

Alexander Walker

Last Published

July 27th, 2014

Functions in openxlsx (2.0.15)

read.xlsx

Read data from a worksheet into a data.frame
freezePane

Freeze a worksheet pane
modifyBaseFont

Modify the default font
names

get or set worksheet names
openxlsx

xlsx reading, writing and editing.
getBaseFont

Return the workbook defaul font
addWorksheet

Add a worksheet to a workbook
conditionalFormat

Add conditional formatting to cells
addStyle

Add a style to a set of cells
write.xlsx

write directly to an xlsx file
mergeCells

Merge cells within a worksheet
removeColWidths

Remove custom column widths from a worksheet
loadWorkbook

Load an exisiting .xlsx file
setHeader

Set header for all worksheets
convertToDateTime

Convert from excel time number to R as.POSIXct
deleteData

Delete cell data
insertImage

Insert an image into a worksheet
orderCellRef

Returns ordering of sorted cell references
removeCellMerge

Create a new Workbook object
getStyles

Returns a list of all styles in the workbook
createStyle

Create a cell style
removeRowHeights

Remove custom row heights from a worksheet
setRowHeights

Set worksheet row heights
convertFromExcelRef

Convert excel column name to integer index
writeData

Write an object to a worksheet
getCellRefs

Return excel cell coordinates from (x,y) coordinates
openXL

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

Set page margins, orientation and print scaling
showGridLines

Set worksheet gridlines to show or hide.
removeWorksheet

Remove a worksheet from a workbook
setColWidths

Set worksheet column widths
convertToDate

Convert from excel date number to R Date type
replaceStyle

Replace an existing cell style
writeDataTable

Write to a worksheet and format as a table
saveWorkbook

save Workbook to file
createWorkbook

Create a new Workbook object
renameWorksheet

Rename an exisiting worksheet
readWorkbook

Read data from a worksheet into a data.frame
setFooter

Set footer for all worksheets
insertPlot

Insert the current plot into a worksheet
sheets

Returns names of worksheets.
worksheetOrder

Order of worksheets in xlsx file