xlsx v0.6.1

0

Monthly downloads

0th

Percentile

Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

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

Readme

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

Questions should be asked on the dedicated mailing list

Functions in xlsx

Name Description
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.
No Results!

Vignettes of xlsx

Name
xlsx.Rnw
No Results!

Last month downloads

Details

Type Package
Date 2018-06-07
LazyLoad yes
License GPL-3
URL https://github.com/dragua/rexcel, http://groups.google.com/group/R-package-xlsx
BugReports https://github.com/dragua/rexcel/issues
SystemRequirements java (>= 1.6)
NeedsCompilation no
Packaged 2018-06-11 00:21:04 UTC; adrian
Repository CRAN
Date/Publication 2018-06-11 05:50:21 UTC

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/xlsx)](http://www.rdocumentation.org/packages/xlsx)