openxlsx v4.2.3

0

Monthly downloads

0th

Percentile

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.

Readme

openxlsx

Build Status AppVeyor build status codecov CRAN_Status_Badge CRAN RStudio mirror downloads R-CMD-check

This R package simplifies the creation of .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.

Installation

Stable version

Current stable version is available on CRAN via

install.packages("openxlsx", dependencies = TRUE)

Development version

install.packages(c("Rcpp", "devtools"), dependencies = TRUE)
require(devtools)
install_github("ycphs/openxlsx")

Bug/feature request

Please let me know which version of openxlsx you are using when posting bug reports.

packageVersion("openxlsx")

News

Here.

Authors and Contributors for the current release

@awalker89, @aavanesy, @ale275, @alexb523, @david-f1976, @davidgohel, @dovrosenberg, @JoshuaSturm, @SHAESEN2, @soliac, @theclue, and @ycphs

Functions in openxlsx

Name Description
convertFromExcelRef Convert excel column name to integer index
dataValidation Add data validation to cells
deleteData Delete cell data
createNamedRegion Create a named region.
getStyles Returns a list of all styles in the workbook
createComment create a Comment object
getSheetNames Get names of worksheets
getDateOrigin Get the date origin an xlsx file is using
getNamedRegions Get named regions
addStyle Add a style to a set of cells
addWorksheet Add a worksheet to a workbook
createStyle Create a cell style
convertToDate Convert from excel date number to R Date type
all.equal Check equality of workbooks
cloneWorksheet Clone a worksheet to a workbook
mergeCells Merge cells within a worksheet
createWorkbook Create a new Workbook object
read.xlsx Read from an Excel file or Workbook object
protectWorksheet Protect a worksheet from modifications
modifyBaseFont Modify the default font
insertImage Insert an image into a worksheet
loadWorkbook Load an existing .xlsx file
groupRows Group Rows
convertToDateTime Convert from excel time number to R POSIXct type.
copyWorkbook Copy a Workbook object.
setHeaderFooter Set document headers and footers
makeHyperlinkString create Excel hyperlink string
removeRowHeights Remove custom row heights from a worksheet
groupColumns Group columns
replaceStyle Replace an existing cell style
int2col Convert integer to Excel column
renameWorksheet Rename a worksheet
getTables List Excel tables in a workbook
insertPlot Insert the current plot into a worksheet
removeFilter Remove a worksheet filter
write.xlsx write data to an xlsx file
conditionalFormat Add conditional formatting to cells
openxlsx xlsx reading, writing and editing.
pageSetup Set page margins, orientation and print scaling
protectWorkbook Protect a workbook from modifications
pageBreak add a page break to a worksheet
setLastModifiedBy Add another author to the meta data of the file.
writeData Write an object to a worksheet
writeDataTable Write to a worksheet as an Excel table
sheets Returns names of worksheets.
sheetVisible Get worksheet visible state.
saveWorkbook save Workbook to file
setColWidths Set worksheet column widths
freezePane Freeze a worksheet pane
conditionalFormatting Add conditional formatting to cells
getBaseFont Return the workbook default font
writeComment write a cell comment
getCellRefs Return excel cell coordinates from (x,y) coordinates
getCreators Add another author to the meta data of the file.
names get or set worksheet names
writeFormula Write a character vector as an Excel Formula
removeComment Remove a comment from a cell
setHeader Set header for all worksheets
showGridLines Set worksheet gridlines to show or hide.
setFooter Set footer for all worksheets
removeColWidths Remove column widths from a worksheet
worksheetOrder Order of worksheets in xlsx file
ungroupRows Ungroup Rows
readWorkbook Read from an Excel file or Workbook object
removeCellMerge Create a new Workbook object
openXL Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook
removeTable Remove an Excel table in a workbook
ungroupColumns Ungroup Columns
removeWorksheet Remove a worksheet from a workbook
sheetVisibility Get/set worksheet visible state
setRowHeights Set worksheet row heights
addCreator Add another author to the meta data of the file.
addFilter Add column filters
No Results!

Vignettes of openxlsx

Name
Formatting.Rmd
Introduction.Rmd
tableStyles.PNG
No Results!

Last month downloads

Details

Type Package
Date 2020-10-26
Language en-US
License MIT + file LICENSE
URL https://ycphs.github.io/openxlsx/index.html, https://github.com/ycphs/openxlsx
BugReports https://github.com/ycphs/openxlsx/issues
LinkingTo Rcpp
VignetteBuilder knitr
Encoding UTF-8
RoxygenNote 7.1.1
Collate 'CommentClass.R' 'HyperlinkClass.R' 'RcppExports.R' 'class_definitions.R' 'StyleClass.R' 'WorkbookClass.R' 'baseXML.R' 'borderFunctions.R' 'chartsheet_class.R' 'conditional_formatting.R' 'helperFunctions.R' 'loadWorkbook.R' 'onUnload.R' 'openXL.R' 'openxlsx-package.R' 'openxlsx.R' 'openxlsxCoerce.R' 'readWorkbook.R' 'sheet_data_class.R' 'workbook_column_widths.R' 'workbook_read_workbook.R' 'workbook_write_data.R' 'worksheet_class.R' 'wrappers.R' 'writeData.R' 'writeDataTable.R' 'writexlsx.R'
NeedsCompilation yes
Packaged 2020-10-27 09:11:13 UTC; philipp
Repository CRAN
Date/Publication 2020-10-27 14:20:02 UTC

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/openxlsx)](http://www.rdocumentation.org/packages/openxlsx)