xlsx-package: Read, write, format Excel 2007 and Excel 97/2000/XP/2003...

Description Details Author(s) References See Also Examples

Description

The xlsx package gives programatic control of Excel files using R. A high level API allows the user to read a sheet of an xlsx document into a data.frame and write a data.frame to a file. Lower level functionality permits the direct manipulation of sheets, rows and cells. For example, the user has control to set colors, fonts, data formats, add borders, hide/unhide sheets, add/remove rows, add/remove sheets, etc.

Behind the scenes, the xlsx package uses a java library from the Apache project, http://poi.apache.org/index.html. This Apache project provides a Java API to Microsoft Documents (Excel, Word, PowerPoint, Outlook, Visio, etc.) By using the rJava package that links R and Java, we can piggyback on the excellent work already done by the folks at the Apache project and provide this functionality in R. The xlsx package uses only a subset of the Apache POI project, namely the one dealing with Excel files. All the necessary jar files are kept in package xlsxjars that is imported by package xlsx.

A collection of tests that can be used as examples are located in folder /tests/. They are a good source of examples of how to use the package.

Please see http://code.google.com/p/rexcel/ for a Wiki and the development version. To report a bug, use the Issues page at https://code.google.com/p/rexcel/issues/list. Questions should be asked on the dedicated mailing list at http://groups.google.com/group/R-package-xlsx.

Details

Package: xlsx
Type: Package
Version: 0.6.1
Date: 2018-06-07
License: GPL-3

Author(s)

Adrian A. Dragulescu, Cole Arendt.

Maintainer: Adrian A. Dragulescu <[email protected]>

References

Apache POI project for Microsoft Excel format: http://poi.apache.org/spreadsheet/index.html.

The Java Doc detailing the classes: http://poi.apache.org/apidocs/index.html. This can be useful if you are looking for something that is not exposed in R as it may be available on the Java side. Inspecting the source code for some the the R functions in this package can show you how to do it (even if you are Java shy.)

See Also

Workbook for ways to work with Workbook objects.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
## Not run: 

require(xlsx)

# example of reading xlsx sheets
file <- system.file("tests", "test_import.xlsx", package = "xlsx")
res <- read.xlsx(file, 2)  # read the second sheet

# example of writing xlsx sheets
file <- paste(tempfile(), "xlsx", sep=".")
write.xlsx(USArrests, file=file)


## End(Not run)

colearendt/xlsx documentation built on Oct. 11, 2018, 12:23 a.m.