Other packages > Find by keyword >

openxlsx  

Read, Write and Edit xlsx Files
View on CRAN: Click here


Download and install openxlsx package within the R console
Install from CRAN:
install.packages("openxlsx")

Install from Github:
library("remotes")
install_github("cran/openxlsx")

Install by package version:
library("remotes")
install_version("openxlsx", "4.2.9")



Attach the package and use:
library("openxlsx")
Maintained by
Jan Marvin Garbuszus
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2014-04-21
Latest Update: 2025-01-25
Description:
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.
How to cite:
Jan Marvin Garbuszus (2014). openxlsx: Read, Write and Edit xlsx Files. R package version 4.2.9, https://cran.r-project.org/web/packages/openxlsx. Accessed 26 Oct. 2026.
Previous versions and publish date:
(2026-09-02 11:30), 1.0.3 (2014-04-21 15:41), 2.0.1 (2014-05-29 15:05), 2.0.15 (2014-07-27 08:10), 2.2.1 (2014-10-18 11:16), 2.4.0 (2015-03-07 17:47), 3.0.0 (2015-07-03 15:35), 4.0.0 (2017-01-09 15:17), 4.0.17 (2017-03-23 14:10), 4.1.0.1 (2019-05-28 22:10), 4.1.0 (2018-05-26 17:20), 4.1.2 (2019-10-29 07:50), 4.1.3 (2019-11-07 14:40), 4.1.4 (2019-12-06 13:50), 4.1.5 (2020-05-06 19:50), 4.2.2 (2020-09-17 10:10), 4.2.3 (2020-10-27 15:20), 4.2.4 (2021-06-16 06:20), 4.2.5.1 (2022-10-24 14:57), 4.2.5.2 (2023-02-06 18:57), 4.2.5 (2021-12-14 15:20), 4.2.6.1 (2024-07-23 22:50), 4.2.6 (2024-07-23 14:40), 4.2.7.1 (2024-09-20 14:50), 4.2.7 (2024-08-30 10:30), 4.2.8.1 (2025-10-31 07:10), 4.2.8 (2025-01-25 21:30)
Other packages that cited openxlsx R package
View openxlsx citation profile
Other R packages that openxlsx depends, imports, suggests or enhances
Complete documentation for openxlsx
Functions, R codes and Examples using the openxlsx R package
Some associated functions: NamedRegion . activeSheet . addCreator . addFilter . addStyle . addWorksheet . all.equal . buildWorkbook . cloneWorksheet . col2int . conditionalFormat . conditionalFormatting . convertFromExcelRef . convertToDate . convertToDateTime . copyWorkbook . createComment . createStyle . createWorkbook . dataValidation . deleteData . freezePane . getBaseFont . getCellRefs . getCreators . getDateOrigin . getNamedRegions . getSheetNames . getStyles . getTables . groupColumns . groupRows . if_null_then . insertImage . insertPlot . int2col . loadWorkbook . makeHyperlinkString . mergeCells . modifyBaseFont . names . openXL . openxlsx . openxlsxFontSizeLookupTable . openxlsx_options . pageBreak . pageSetup . protectWorkbook . protectWorksheet . read.xlsx . readWorkbook . removeCellMerge . removeColWidths . removeComment . removeFilter . removeRowHeights . removeTable . removeWorksheet . renameWorksheet . replaceStyle . saveWorkbook . setColWidths . setFooter . setHeader . setHeaderFooter . setLastModifiedBy . setRowHeights . sheetVisibility . sheetVisible . sheets . showGridLines . temp_xlsx . ungroupColumns . ungroupRows . worksheetOrder . write.xlsx . writeComment . writeData . writeDataTable . writeFormula . 
Some associated R codes: CommentClass.R . HyperlinkClass.R . RcppExports.R . StyleClass.R . WorkbookClass.R . asserts.R . baseXML.R . borderFunctions.R . build_workbook.R . chartsheet_class.R . class_definitions.R . conditional_formatting.R . data-fontSizeLookupTables.R . helperFunctions.R . loadWorkbook.R . onUnload.R . openXL.R . openxlsx-package.R . openxlsx.R . openxlsxCoerce.R . readWorkbook.R . sheet_data_class.R . utils.R . workbook_column_widths.R . workbook_read_workbook.R . workbook_write_data.R . worksheet_class.R . wrappers.R . writeData.R . writeDataTable.R . writexlsx.R . zzz.R .  Full openxlsx package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

LSDsensitivity  
Sensitivity Analysis Tools for 'LSD' Simulations
Tools for sensitivity analysis of LSD simulation models. Reads object-oriented data produced by LSD ...
Download / Learn more Package Citations See dependency  
SADEG  
Stability Analysis in Differentially Expressed Genes
We analyzed the nucleotide composition of genes with a special emphasis on stability of DNA sequence ...
Download / Learn more Package Citations See dependency  
rts2  
Log-Gaussian Cox Process Models with Approximations
Supports modelling real-time case data to facilitate the real-time surveillance of infectious disea ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
MARSS  
Multivariate Autoregressive State-Space Modeling
The MARSS package provides maximum-likelihood parameter estimation for constrained and unconstraine ...
Download / Learn more Package Citations See dependency  

29,218

R Packages

247,686

Dependencies

77,281

Author Associations

29,219

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA