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
2017-01-09 15:17:12
Maintainer
Alexander Walker <Alexander.Walker1989@gmail.com>
License
GPL-3
Version
4.0.0
URLs

View on CRAN

Man pages

addFilter
Add column filters
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.
copyWorkbook
Copy a Workbook object.
createComment
create a Comment object
createNamedRegion
Create a named region.
createStyle
Create a cell style
createWorkbook
Create a new Workbook object
dataValidation
Add data validation to cells
deleteData
Delete cell data
freezePane
Freeze a worksheet pane
getBaseFont
Return the workbook default font
getCellRefs
Return excel cell coordinates from (x,y) coordinates
getDateOrigin
Get the date origin an xlsx file is using
getNamedRegions
Get named regions
getSheetNames
Get names of worksheets
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
makeHyperlinkString
create Excel hyperlink string
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.
pageBreak
add a page break to a worksheet
pageSetup
Set page margins, orientation and print scaling
readWorkbook
Read from an Excel file or Workbook object
read.xlsx
Read from an Excel file or Workbook object
removeCellMerge
Create a new Workbook object
removeColWidths
Remove column widths from a worksheet
removeComment
Remove a comment from a cell
removeFilter
Remove a worksheet filter
removeRowHeights
Remove custom row heights from a worksheet
removeWorksheet
Remove a worksheet from a workbook
renameWorksheet
Rename a 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.
sheetVisibility
Get/set worksheet visible state
sheetVisible
Get worksheet visible state.
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 as an Excel table
writeFormula
Write a character vector as an Excel Formula
write.xlsx
write data to an xlsx file

Files in this package

openxlsx
openxlsx/inst
openxlsx/inst/einstein.jpg
openxlsx/inst/build_font_size_lookup.R
openxlsx/inst/load_xlsx_testing.R
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/installation.pdf
openxlsx/inst/doc/installation.Rnw
openxlsx/inst/doc/formatting.pdf
openxlsx/inst/stack_style_testing.R
openxlsx/inst/conditional_formatting_testing.R
openxlsx/tests
openxlsx/tests/testthat.R
openxlsx/tests/testthat
openxlsx/tests/testthat/test-encoding.R
openxlsx/tests/testthat/test-read_write_logicals.R
openxlsx/tests/testthat/Rplots.pdf
openxlsx/tests/testthat/test-read_sources.R
openxlsx/tests/testthat/test-worksheet_ordering.R
openxlsx/tests/testthat/test-v3_0_0_bugs.R
openxlsx/tests/testthat/test-write_read_equality.R
openxlsx/tests/testthat/test-write_data_to_sheetData_NAs.R
openxlsx/tests/testthat/test-freeze_pane.R
openxlsx/tests/testthat/test-trying_to_break_openxlsx.R
openxlsx/tests/testthat/test-load_read_file_read_equality3.R
openxlsx/tests/testthat/test-loading_workbook.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-write_data_to_sheetData.R
openxlsx/tests/testthat/test-remove_worksheets.R
openxlsx/tests/testthat/test-read_from_loaded_workbook.R
openxlsx/tests/testthat/test-named_regions.R
openxlsx/tests/testthat/test-read_from_created_wb.R
openxlsx/tests/testthat/test-validate_table_name.R
openxlsx/src
openxlsx/src/write_file_2.cpp
openxlsx/src/write_data.cpp
openxlsx/src/load_workbook.cpp
openxlsx/src/helper_functions.cpp
openxlsx/src/RcppExports.cpp
openxlsx/src/write_file.cpp
openxlsx/src/openxlsx.h
openxlsx/src/read_workbook.cpp
openxlsx/NAMESPACE
openxlsx/NEWS
openxlsx/R
openxlsx/R/sheet_data_class.R
openxlsx/R/workbook_write_data.R
openxlsx/R/workbook_column_widths.R
openxlsx/R/openxlsxCoerce.R
openxlsx/R/CommentClass.R
openxlsx/R/chartsheet_class.R
openxlsx/R/WorkbookClass.R
openxlsx/R/HyperlinkClass.R
openxlsx/R/wrappers.R
openxlsx/R/writeData.R
openxlsx/R/readWorkbook.R
openxlsx/R/loadWorkbook.R
openxlsx/R/writeDataTable.R
openxlsx/R/workbook_read_workbook.R
openxlsx/R/worksheet_class.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/class_definitions.R
openxlsx/R/openXL.R
openxlsx/vignettes
openxlsx/vignettes/tableStyles.PNG
openxlsx/vignettes/formatting.Rnw
openxlsx/vignettes/Introduction.Rnw
openxlsx/vignettes/rtools_installation_path.PNG
openxlsx/vignettes/installation.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/pageBreak.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/dataValidation.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/sheetVisibility.Rd
openxlsx/man/sheets.Rd
openxlsx/man/makeHyperlinkString.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/sheetVisible.Rd
openxlsx/man/openXL.Rd
openxlsx/man/conditionalFormat.Rd
openxlsx/man/readWorkbook.Rd
openxlsx/man/int2col.Rd
openxlsx/man/replaceStyle.Rd
openxlsx/man/createNamedRegion.Rd
openxlsx/man/loadWorkbook.Rd
openxlsx/man/write.xlsx.Rd
openxlsx/man/freezePane.Rd
openxlsx/man/copyWorkbook.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