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.

AuthorAlexander Walker [aut, cre], Luca Braglia [ctb]
Date of publication2017-01-09 15:17:12
MaintainerAlexander Walker <Alexander.Walker1989@gmail.com>
LicenseGPL-3
Version4.0.0
https://github.com/awalker89/openxlsx

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

Functions

addFilter Man page
addStyle Man page
addWorksheet Man page
all.equal Man page
all.equal.Workbook Man page
conditionalFormat Man page
conditionalFormatting Man page
convertFromExcelRef Man page
convertToDate Man page
convertToDateTime Man page
copyWorkbook Man page
createComment Man page
createNamedRegion Man page
createStyle Man page
createWorkbook Man page
dataValidation Man page
deleteData Man page
freezePane Man page
getBaseFont Man page
getCellRefs Man page
getDateOrigin Man page
getNamedRegions Man page
getSheetNames Man page
getStyles Man page
insertImage Man page
insertPlot Man page
int2col Man page
loadWorkbook Man page
makeHyperlinkString Man page
mergeCells Man page
modifyBaseFont Man page
names Man page
names<-.Workbook Man page
names.Workbook Man page
openXL Man page
openxlsx Man page
openxlsx-package Man page
pageBreak Man page
pageSetup Man page
readWorkbook Man page
read.xlsx Man page
removeCellMerge Man page
removeColWidths Man page
removeComment Man page
removeFilter Man page
removeRowHeights Man page
removeWorksheet Man page
renameWorksheet Man page
replaceStyle Man page
saveWorkbook Man page
setColWidths Man page
setFooter Man page
setHeader Man page
setHeaderFooter Man page
setRowHeights Man page
sheets Man page
sheetVisibility Man page
sheetVisibility<- Man page
sheetVisible Man page
sheetVisible<- Man page
showGridLines Man page
worksheetOrder Man page
worksheetOrder<- Man page
writeComment Man page
writeData Man page
writeDataTable Man page
writeFormula Man page
write.xlsx Man page

Files

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

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.