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

xlsx (version 0.5.7)

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

Description

Provide R functions to read/write/format Excel 2007 and Excel 97/2000/XP/2003 file formats.

Copy Link

Version

Install

install.packages('xlsx')

Monthly Downloads

53,385

Version

0.5.7

License

GPL-3

Maintainer

Adrian Dragulescu

Last Published

August 2nd, 2014

Functions in xlsx (0.5.7)

OtherEffects

Functions to do various spreadsheets effects.
Comment

Functions to manipulate cell comments.
DataFormat

Create an DataFormat object.
write.xlsx

Write a data.frame to an Excel workbook.
Cell

Functions to manipulate cells.
read.xlsx

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

Constants used in the project.
Border

Create an Border object.
readRows

Read a contiguous set of rows into an R matrix
xlsx-package

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

Functions to manipulate worksheets.
Row

Functions to manipulate rows of a worksheet.
PrintSetup

Function to manipulate print setup.
CellStyle

Functions to manipulate cells.
"+.CellStyle"

CellStyle construction.
Workbook

Functions to manipulate Excel 2007 workbooks.
addHyperlink

Add a hyperlink to a cell.
CellProtection

Create a CellProtection object.
CellBlock

Create and style a block of cells.
Picture

Functions to manipulate images in a spreadsheet.
addDataFrame

Add a data.frame to a sheet.
Fill

Create an Fill object.
readColumns

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

Create a Font object.
NamedRanges

Functions to manipulate named ranges.
Alignment

Create an Alignment object.