openxlsx: Read, Write and Edit XLSX Files
Version 4.0.17

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.

Browse man pages Browse package API and functions Browse package files

AuthorAlexander Walker [aut, cre], Luca Braglia [ctb]
Date of publication2017-03-23 13:10:15 UTC
MaintainerAlexander Walker <Alexander.Walker1989@gmail.com>
LicenseGPL-3
Version4.0.17
URL https://github.com/awalker89/openxlsx
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("openxlsx")

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
getTables: List Excel tables in a 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
removeTable: Remove an Excel table in a workbook
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

Functions

addFilter Man page Source code
addStyle Man page Source code
addWorksheet Man page Source code
all.equal Man page
all.equal.Workbook Man page Source code
buildBorder Source code
buildCellList Source code
buildCellTypes Source code
buildFillList Source code
buildFontList Source code
buildMatrixMixed Source code
buildMatrixNumeric Source code
build_cell_merges Source code
build_cell_types_integer Source code
build_table_xml Source code
calc_column_widths Source code
calc_number_rows Source code
cell_ref_to_col Source code
chooseExcelApp Source code
classStyles Source code
clean_names Source code
col2hex Source code
conditionalFormat Man page Source code
conditionalFormatting Man page Source code
contentTypePivotXML Source code
contentTypeSlicerCacheXML Source code
convert2EMU Source code
convertFromExcelRef Man page Source code
convertToDate Man page Source code
convertToDateTime Man page Source code
convert_from_excel_ref Source code
convert_to_excel_ref Source code
convert_to_excel_ref_expand Source code
copyWorkbook Man page Source code
cppReadFile Source code
createComment Man page Source code
createNamedRegion Man page Source code
createStyle Man page Source code
createWorkbook Man page Source code
dataValidation Man page Source code
databar Man page
deleteData Man page Source code
freezePane Man page Source code
genBaseColStyle Source code
genBaseContent_Type Source code
genBaseCore Source code
genBasePic Source code
genBaseShapeVML Source code
genBaseSheetRels Source code
genBaseSlicerXML Source code
genBaseStyleSheet Source code
genBaseTable Source code
genBaseTheme Source code
genBaseWorkbook Source code
genBaseWorkbook.xml.rels Source code
genClientData Source code
genHeaderFooterNode Source code
genPrinterSettings Source code
genSlicerCachesExtLst Source code
gen_databar_extlst Source code
getAttr Source code
getAttrs Source code
getAttrsFont Source code
getBaseFont Man page Source code
getCellInfo Source code
getCellRefs Man page Source code
getChildlessNode Source code
getChildlessNode_ss Source code
getDateOrigin Man page Source code
getDefinedNamesSheet Source code
getFile Source code
getId Source code
getNamedRegions Man page Source code
getNamedRegions.Workbook Source code
getNamedRegions.default Source code
getNodes Source code
getOpenClosedNode Source code
getRId Source code
getSharedStringsFromFile Source code
getSheetNames Man page Source code
getStyles Man page Source code
getTables Man page Source code
get_extLst_Major Source code
get_letters Source code
get_named_regions_from_string Source code
get_shared_strings Source code
get_style_max_char_width Source code
headerFooterSub Source code
insertImage Man page Source code
insertPlot Man page Source code
int2col Man page Source code
int_2_cell_ref Source code
isInternalHyperlink Source code
loadWorkbook Man page Source code
loadworksheets Source code
makeHyperlinkString Man page Source code
map_cell_types_to_char Source code
map_cell_types_to_integer Source code
matrixRowInds Source code
mergeCell2mapping Source code
mergeCells Man page Source code
mergeStyle Source code
modifyBaseFont Man page Source code
names Man page
names.Workbook Man page Source code
names<-.Workbook Man page
nodeAttributes Source code
openXL Man page Source code
openxlsx Man page
openxlsx-package Man page
openxlsxCoerce Source code
openxlsxCoerce.anova Source code
openxlsxCoerce.aov Source code
openxlsxCoerce.array Source code
openxlsxCoerce.cox.zph Source code
openxlsxCoerce.coxph Source code
openxlsxCoerce.data.frame Source code
openxlsxCoerce.data.table Source code
openxlsxCoerce.default Source code
openxlsxCoerce.glm Source code
openxlsxCoerce.hyperlink Source code
openxlsxCoerce.lm Source code
openxlsxCoerce.matrix Source code
openxlsxCoerce.prcomp Source code
openxlsxCoerce.summary.coxph Source code
openxlsxCoerce.summary.prcomp Source code
openxlsxCoerce.survdiff Source code
openxlsxCoerce.table Source code
pageBreak Man page Source code
pageSetup Man page Source code
pixels2ExcelColWidth Source code
pxml Source code
read.xlsx Man page Source code
read.xlsx.Workbook Source code
read.xlsx.default Source code
readWorkbook Man page Source code
read_file_newline Source code
read_workbook Source code
removeCellMerge Man page Source code
removeColWidths Man page Source code
removeComment Man page Source code
removeFilter Man page Source code
removeHeadTag Source code
removeRowHeights Man page Source code
removeTable Man page Source code
removeWorksheet Man page Source code
renameWorksheet Man page Source code
replaceIllegalCharacters Source code
replaceStyle Man page Source code
replaceXMLEntities Source code
saveWorkbook Man page Source code
setColWidths Man page Source code
setFooter Man page Source code
setHeader Man page Source code
setHeaderFooter Man page Source code
setRowHeights Man page Source code
sheetVisibility Man page Source code
sheetVisibility<- Man page
sheetVisible Man page Source code
sheetVisible<- Man page
sheets Man page Source code
showGridLines Man page Source code
splitHeaderFooter Source code
validateBorderStyle Source code
validateColour Source code
worksheetOrder Man page Source code
worksheetOrder<- Man page
write.xlsx Man page Source code
writeComment Man page Source code
writeCommentXML Source code
writeData Man page Source code
writeDataTable Man page Source code
writeFile Source code
writeFormula Man page Source code
write_worksheet_xml Source code
write_worksheet_xml_2 Source code
xml_to_hyperlink Source code

Files

inst
inst/einstein.jpg
inst/build_font_size_lookup.R
inst/load_xlsx_testing.R
inst/loadExample.xlsx
inst/readTest.xlsx
inst/namedRegions.xlsx
inst/doc
inst/doc/formatting.Rnw
inst/doc/Introduction.Rnw
inst/doc/Introduction.pdf
inst/doc/installation.pdf
inst/doc/installation.Rnw
inst/doc/formatting.pdf
inst/stack_style_testing.R
inst/conditional_formatting_testing.R
tests
tests/testthat.R
tests/testthat
tests/testthat/test-encoding.R
tests/testthat/test-read_write_logicals.R
tests/testthat/Rplots.pdf
tests/testthat/test-read_sources.R
tests/testthat/test-table_overlaps.R
tests/testthat/test-worksheet_ordering.R
tests/testthat/test-v3_0_0_bugs.R
tests/testthat/test-write_read_equality.R
tests/testthat/test-write_data_to_sheetData_NAs.R
tests/testthat/test-freeze_pane.R
tests/testthat/test-skip_empty_rows.R
tests/testthat/test-trying_to_break_openxlsx.R
tests/testthat/test-load_read_file_read_equality3.R
tests/testthat/test-loading_workbook.R
tests/testthat/test-style_replacing.R
tests/testthat/test-worksheet_renaming.R
tests/testthat/test-date_time_conversion.R
tests/testthat/test-write_data_to_sheetData.R
tests/testthat/test-deleting_tables.R
tests/testthat/test-remove_worksheets.R
tests/testthat/test-loading_workbook_tables.R
tests/testthat/test-read_from_loaded_workbook.R
tests/testthat/test-named_regions.R
tests/testthat/test-read_from_created_wb.R
tests/testthat/test-validate_table_name.R
src
src/write_file_2.cpp
src/write_data.cpp
src/load_workbook.cpp
src/openxlsx_init.c
src/helper_functions.cpp
src/RcppExports.cpp
src/write_file.cpp
src/openxlsx.h
src/read_workbook.cpp
NAMESPACE
NEWS
R
R/sheet_data_class.R
R/workbook_write_data.R
R/workbook_column_widths.R
R/openxlsxCoerce.R
R/CommentClass.R
R/chartsheet_class.R
R/WorkbookClass.R
R/conditional_formatting.R
R/HyperlinkClass.R
R/wrappers.R
R/writeData.R
R/readWorkbook.R
R/loadWorkbook.R
R/writeDataTable.R
R/workbook_read_workbook.R
R/worksheet_class.R
R/RcppExports.R
R/helperFunctions.R
R/openxlsx.R
R/writexlsx.R
R/baseXML.R
R/borderFunctions.R
R/StyleClass.R
R/class_definitions.R
R/openXL.R
vignettes
vignettes/tableStyles.PNG
vignettes/formatting.Rnw
vignettes/Introduction.Rnw
vignettes/rtools_installation_path.PNG
vignettes/installation.Rnw
README.md
MD5
build
build/vignette.rds
DESCRIPTION
man
man/getTables.Rd
man/setHeader.Rd
man/conditionalFormatting.Rd
man/read.xlsx.Rd
man/addFilter.Rd
man/renameWorksheet.Rd
man/removeFilter.Rd
man/figures
man/figures/tableoptions.pdf
man/figures/tableoptions.png
man/removeComment.Rd
man/setFooter.Rd
man/mergeCells.Rd
man/setRowHeights.Rd
man/createComment.Rd
man/setHeaderFooter.Rd
man/insertImage.Rd
man/names.Rd
man/pageBreak.Rd
man/addWorksheet.Rd
man/getBaseFont.Rd
man/getNamedRegions.Rd
man/removeWorksheet.Rd
man/convertToDateTime.Rd
man/convertToDate.Rd
man/dataValidation.Rd
man/getSheetNames.Rd
man/removeRowHeights.Rd
man/getDateOrigin.Rd
man/all.equal.Rd
man/writeDataTable.Rd
man/getCellRefs.Rd
man/sheetVisibility.Rd
man/sheets.Rd
man/makeHyperlinkString.Rd
man/writeData.Rd
man/modifyBaseFont.Rd
man/insertPlot.Rd
man/saveWorkbook.Rd
man/removeTable.Rd
man/removeCellMerge.Rd
man/createStyle.Rd
man/deleteData.Rd
man/writeComment.Rd
man/setColWidths.Rd
man/openxlsx.Rd
man/createWorkbook.Rd
man/sheetVisible.Rd
man/openXL.Rd
man/conditionalFormat.Rd
man/readWorkbook.Rd
man/int2col.Rd
man/replaceStyle.Rd
man/createNamedRegion.Rd
man/loadWorkbook.Rd
man/write.xlsx.Rd
man/freezePane.Rd
man/copyWorkbook.Rd
man/addStyle.Rd
man/removeColWidths.Rd
man/getStyles.Rd
man/showGridLines.Rd
man/convertFromExcelRef.Rd
man/worksheetOrder.Rd
man/writeFormula.Rd
man/pageSetup.Rd
openxlsx documentation built on May 20, 2017, 3:24 a.m.