openxlsx: Read, Write and Edit XLSX Files

Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

Author
Alexander Walker [aut, cre], Luca Braglia [ctb]
Date of publication
2015-07-03 15:35:09
Maintainer
Alexander Walker <Alexander.Walker1989@gmail.com>
License
GPL-3
Version
3.0.0
URLs

View on CRAN

Man pages

addFilter
add filters to columns
addStyle
Add a style to a set of cells
addWorksheet
Add a worksheet to a workbook
all.equal
Check equality of workbooks
conditionalFormat
Add conditional formatting to cells
conditionalFormatting
Add conditional formatting to cells
convertFromExcelRef
Convert excel column name to integer index
convertToDate
Convert from excel date number to R Date type
convertToDateTime
Convert from excel time number to R POSIXct type.
createComment
write a cell comment
createStyle
Create a cell style
createWorkbook
Create a new Workbook object
deleteData
Delete cell data
freezePane
Freeze a worksheet pane
getBaseFont
Return the workbook defaul font
getCellRefs
Return excel cell coordinates from (x,y) coordinates
getDateOrigin
Return the date origin used internally by an xlsx or xlsm...
getNamedRegions
Get named regions in an xlsx file.
getSheetNames
Returns the worksheet names within an xlsx file
getStyles
Returns a list of all styles in the workbook
insertImage
Insert an image into a worksheet
insertPlot
Insert the current plot into a worksheet
int2col
Convert integer to Excel column
loadWorkbook
Load an exisiting .xlsx file
mergeCells
Merge cells within a worksheet
modifyBaseFont
Modify the default font
names
get or set worksheet names
openXL
Open a Microsoft Excel file (xls/xlsx) or an openxlsx...
openxlsx
xlsx reading, writing and editing.
pageSetup
Set page margins, orientation and print scaling
readWorkbook
Read data from a worksheet into a data.frame
read.xlsx
Read data from an Excel file or Workbook object into a...
removeCellMerge
Create a new Workbook object
removeColWidths
Remove custom column widths from a worksheet
removeComment
Remove a comment from a cell
removeFilter
removes worksheet filter from addFilter and writeData
removeRowHeights
Remove custom row heights from a worksheet
removeWorksheet
Remove a worksheet from a workbook
renameWorksheet
Rename an exisiting worksheet
replaceStyle
Replace an existing cell style
saveWorkbook
save Workbook to file
setColWidths
Set worksheet column widths
setFooter
Set footer for all worksheets
setHeader
Set header for all worksheets
setHeaderFooter
Set document headers and footers
setRowHeights
Set worksheet row heights
sheets
Returns names of worksheets.
showGridLines
Set worksheet gridlines to show or hide.
worksheetOrder
Order of worksheets in xlsx file
writeComment
write a cell comment
writeData
Write an object to a worksheet
writeDataTable
Write to a worksheet and format as a table
writeFormula
Write a character vector as an Excel Formula
write.xlsx
write directly to an xlsx file

Files in this package

openxlsx
openxlsx/inst
openxlsx/inst/einstein.jpg
openxlsx/inst/loadExample.xlsx
openxlsx/inst/readTest.xlsx
openxlsx/inst/doc
openxlsx/inst/doc/formatting.Rnw
openxlsx/inst/doc/Introduction.Rnw
openxlsx/inst/doc/Introduction.pdf
openxlsx/inst/doc/formatting.pdf
openxlsx/tests
openxlsx/tests/testthat.R
openxlsx/tests/testthat
openxlsx/tests/testthat/test-encoding.R
openxlsx/tests/testthat/Rplots.pdf
openxlsx/tests/testthat/test-load_read_file_read_equality4.R
openxlsx/tests/testthat/test-worksheet_ordering.R
openxlsx/tests/testthat/test-write_read_equality.R
openxlsx/tests/testthat/test-load_read_file_read_equality5.R
openxlsx/tests/testthat/test-load_read_file_read_equality3.R
openxlsx/tests/testthat/test-style_replacing.R
openxlsx/tests/testthat/test-worksheet_renaming.R
openxlsx/tests/testthat/test-date_time_conversion.R
openxlsx/tests/testthat/test-load_read_file_read_equality.R
openxlsx/tests/testthat/test-remove_worksheets.R
openxlsx/tests/testthat/test-load_read_file_read_equality2.R
openxlsx/src
openxlsx/src/cppFunctions.cpp
openxlsx/src/RcppExports.cpp
openxlsx/NAMESPACE
openxlsx/NEWS
openxlsx/R
openxlsx/R/openxlsxCoerce.R
openxlsx/R/CommentClass.R
openxlsx/R/WorkbookClass.R
openxlsx/R/wrappers.R
openxlsx/R/writeData.R
openxlsx/R/readWorkbook.R
openxlsx/R/loadWorkbook.R
openxlsx/R/writeDataTable.R
openxlsx/R/RcppExports.R
openxlsx/R/helperFunctions.R
openxlsx/R/openxlsx.R
openxlsx/R/writexlsx.R
openxlsx/R/baseXML.R
openxlsx/R/borderFunctions.R
openxlsx/R/StyleClass.R
openxlsx/R/openXL.R
openxlsx/vignettes
openxlsx/vignettes/tableStyles.PNG
openxlsx/vignettes/formatting.Rnw
openxlsx/vignettes/Introduction.Rnw
openxlsx/README.md
openxlsx/MD5
openxlsx/build
openxlsx/build/vignette.rds
openxlsx/DESCRIPTION
openxlsx/man
openxlsx/man/setHeader.Rd
openxlsx/man/conditionalFormatting.Rd
openxlsx/man/read.xlsx.Rd
openxlsx/man/addFilter.Rd
openxlsx/man/renameWorksheet.Rd
openxlsx/man/removeFilter.Rd
openxlsx/man/removeComment.Rd
openxlsx/man/setFooter.Rd
openxlsx/man/mergeCells.Rd
openxlsx/man/setRowHeights.Rd
openxlsx/man/createComment.Rd
openxlsx/man/setHeaderFooter.Rd
openxlsx/man/insertImage.Rd
openxlsx/man/names.Rd
openxlsx/man/addWorksheet.Rd
openxlsx/man/getBaseFont.Rd
openxlsx/man/getNamedRegions.Rd
openxlsx/man/removeWorksheet.Rd
openxlsx/man/convertToDateTime.Rd
openxlsx/man/convertToDate.Rd
openxlsx/man/getSheetNames.Rd
openxlsx/man/removeRowHeights.Rd
openxlsx/man/getDateOrigin.Rd
openxlsx/man/all.equal.Rd
openxlsx/man/writeDataTable.Rd
openxlsx/man/getCellRefs.Rd
openxlsx/man/sheets.Rd
openxlsx/man/writeData.Rd
openxlsx/man/modifyBaseFont.Rd
openxlsx/man/insertPlot.Rd
openxlsx/man/saveWorkbook.Rd
openxlsx/man/removeCellMerge.Rd
openxlsx/man/createStyle.Rd
openxlsx/man/deleteData.Rd
openxlsx/man/writeComment.Rd
openxlsx/man/setColWidths.Rd
openxlsx/man/openxlsx.Rd
openxlsx/man/createWorkbook.Rd
openxlsx/man/openXL.Rd
openxlsx/man/conditionalFormat.Rd
openxlsx/man/readWorkbook.Rd
openxlsx/man/int2col.Rd
openxlsx/man/replaceStyle.Rd
openxlsx/man/loadWorkbook.Rd
openxlsx/man/write.xlsx.Rd
openxlsx/man/freezePane.Rd
openxlsx/man/addStyle.Rd
openxlsx/man/removeColWidths.Rd
openxlsx/man/getStyles.Rd
openxlsx/man/showGridLines.Rd
openxlsx/man/convertFromExcelRef.Rd
openxlsx/man/worksheetOrder.Rd
openxlsx/man/writeFormula.Rd
openxlsx/man/pageSetup.Rd