Learn R Programming

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

xlsx

An R package to read, write, format Excel 2007 and Excel 97/2000/XP/2003 files

The package provides R functions to read, write, and format Excel files. Depends on Java, but this makes it available on most OS'es.

Install

Stable version from CRAN

install.packages('xlsx')

Or development version from GitHub

devtools::install_github('dragua/xlsx')

Quick start

To read the first sheet from spreadsheet into a data.frame

read.xlsx2('C:/temp/file.xlsx', 1)

To write a data.frame to a spreadsheet

write.xlsx2(iris, file='C:/temp/iris.xlsx')

Issues/Mailing list

To report a bug, use the Issues page at [issues] [issues]: https://github.com/dragua/xlsx/issues

Questions should be asked on the dedicated mailing [list] [list]: http://groups.google.com/group/R-package-xlsx

Copy Link

Version

Install

install.packages('xlsx')

Monthly Downloads

76,748

Version

0.6.1

License

GPL-3

Issues

Pull Requests

Stars

Forks

Last Published

June 11th, 2018

Functions in xlsx (0.6.1)

Cell

Functions to manipulate cells.
write.xlsx

Write a data.frame to an Excel workbook.
"+.CellStyle"

CellStyle construction.
CellProtection

Create a CellProtection object.
Picture

Functions to manipulate images in a spreadsheet.
DataFormat

Create an DataFormat object.
PrintSetup

Function to manipulate print setup.
Fill

Create an Fill object.
Row

Functions to manipulate rows of a worksheet.
Sheet

Functions to manipulate worksheets.
addHyperlink

Add a hyperlink to a cell.
ForceRefresh

Force Refresh Pivot Tables and Formulae
xlsx-package

Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files
Alignment

Create an Alignment object.
Border

Create an Border object.
Workbook

Functions to manipulate Excel 2007 workbooks.
addDataFrame

Add a data.frame to a sheet.
readColumns

Read a contiguous set of columns from sheet into an R data.frame
read.xlsx

Read the contents of a worksheet into an R data.frame
CellStyle

Functions to manipulate cells.
Comment

Functions to manipulate cell comments.
OtherEffects

Functions to do various spreadsheets effects.
POI_constants

Constants used in the project.
Font

Create a Font object.
readRows

Read a contiguous set of rows into an R matrix
CellBlock

Create and style a block of cells.
NamedRanges

Functions to manipulate named ranges.