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

Share:

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

Author
Adrian A. Dragulescu
Date of publication
2014-08-02 23:32:07
Maintainer
Adrian A. Dragulescu <adrian.dragulescu@gmail.com>
License
GPL-3
Version
0.5.7
URLs

View on CRAN

Man pages

addDataFrame
Add a 'data.frame' to a sheet.
addHyperlink
Add a hyperlink to a cell.
Alignment
Create an Alignment object.
Border
Create an Border object.
Cell
Functions to manipulate cells.
CellBlock
Create and style a block of cells.
CellProtection
Create a CellProtection object.
CellStyle
Functions to manipulate cells.
CellStyle-plus
CellStyle construction.
Comment
Functions to manipulate cell comments.
DataFormat
Create an DataFormat object.
Fill
Create an Fill object.
Font
Create a Font object.
NamedRanges
Functions to manipulate named ranges.
OtherEffects
Functions to do various spreadsheets effects.
Picture
Functions to manipulate images in a spreadsheet.
POI_constants
Constants used in the project.
PrintSetup
Function to manipulate print setup.
readColumns
Read a contiguous set of columns from sheet into an R...
readRows
Read a contiguous set of rows into an R matrix
read.xlsx
Read the contents of a worksheet into an R data.frame
Row
Functions to manipulate rows of a worksheet.
Sheet
Functions to manipulate worksheets.
Workbook
Functions to manipulate Excel 2007 workbooks.
write.xlsx
Write a data.frame to an Excel workbook.
xlsx-package
Read, write, format Excel 2007 and Excel 97/2000/XP/2003...

Files in this package

xlsx
xlsx/inst
xlsx/inst/tests
xlsx/inst/tests/test.import.R
xlsx/inst/tests/lib_tests_xlsx.R
xlsx/inst/tests/log_plot.jpeg
xlsx/inst/tests/test_import.xlsx
xlsx/inst/tests/lib_test_issues.R
xlsx/inst/tests/crash_write_xlsx.R
xlsx/inst/tests/test_import.xls
xlsx/inst/java
xlsx/inst/java/rexcel-0.5.1.jar
xlsx/inst/doc
xlsx/inst/doc/xlsx.pdf
xlsx/inst/doc/xlsx.R
xlsx/inst/doc/xlsx.Rnw
xlsx/NAMESPACE
xlsx/NEWS
xlsx/R
xlsx/R/Font.R
xlsx/R/NamedRanges.R
xlsx/R/Cell.R
xlsx/R/Alignment.R
xlsx/R/read.xlsx.R
xlsx/R/write.xlsx2.R
xlsx/R/Picture.R
xlsx/R/read.xlsx2.R
xlsx/R/Workbook.R
xlsx/R/Fill.R
xlsx/R/utilities.R
xlsx/R/readColumns.R
xlsx/R/readRows.R
xlsx/R/CellBlock.R
xlsx/R/PrintSetup.R
xlsx/R/DataFormat.R
xlsx/R/CellStyle.R
xlsx/R/Border.R
xlsx/R/comment.R
xlsx/R/addDataFrame.R
xlsx/R/write.xlsx.R
xlsx/R/CellProtection.R
xlsx/R/Row.R
xlsx/R/otherEffects.R
xlsx/vignettes
xlsx/vignettes/xlsx.Rnw
xlsx/MD5
xlsx/build
xlsx/build/vignette.rds
xlsx/DESCRIPTION
xlsx/man
xlsx/man/read.xlsx.Rd
xlsx/man/CellStyle-plus.Rd
xlsx/man/Picture.Rd
xlsx/man/Font.Rd
xlsx/man/DataFormat.Rd
xlsx/man/PrintSetup.Rd
xlsx/man/Comment.Rd
xlsx/man/Border.Rd
xlsx/man/Alignment.Rd
xlsx/man/CellBlock.Rd
xlsx/man/Fill.Rd
xlsx/man/Cell.Rd
xlsx/man/OtherEffects.Rd
xlsx/man/addHyperlink.Rd
xlsx/man/write.xlsx.Rd
xlsx/man/Sheet.Rd
xlsx/man/CellProtection.Rd
xlsx/man/Workbook.Rd
xlsx/man/addDataFrame.Rd
xlsx/man/xlsx-package.Rd
xlsx/man/POI_constants.Rd
xlsx/man/readColumns.Rd
xlsx/man/CellStyle.Rd
xlsx/man/readRows.Rd
xlsx/man/Row.Rd
xlsx/man/NamedRanges.Rd