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 06 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

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  
gecko  
Geographical Ecology and Conservation Knowledge Online
Includes a collection of geographical analysis functions aimed primarily at ecology and conservation ...
Download / Learn more Package Citations See dependency  
gRim  
Graphical Interaction Models
Provides the following types of models: Models for contingency tables (i.e. log-linear models) Grap ...
Download / Learn more Package Citations See dependency  

28,905

R Packages

247,686

Dependencies

76,495

Author Associations

28,906

Publication Badges

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