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.8.1")



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.8.1, https://cran.r-project.org/web/packages/openxlsx. Accessed 26 Aug. 2026.
Previous versions and publish date:
(2026-07-09 06:37), 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 (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

ncodeR  
Techniques for Automated Classifiers
A set of techniques that can be used to develop, validate, and implement automated classifiers. A po ...
Download / Learn more Package Citations See dependency  
SelvarMix  
Regularization for Variable Selection in Model-Based Clustering and Discriminant Analysis
Performs a regularization approach to variable selection in themodel-based clustering and classifica ...
Download / Learn more Package Citations See dependency  
PCADSC  
Tools for Principal Component Analysis-Based Data Structure Comparisons
A suite of non-parametric, visual tools for assessing differences in data structures for two datase ...
Download / Learn more Package Citations See dependency  
RCytoGPS  
Using Cytogenetics Data in R
Defines classes and methods to process text-based cytogenetics using the CytoGPS web site, then imp ...
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  
leafgl  
High-Performance 'WebGl' Rendering for Package 'leaflet'
Provides bindings to the 'Leaflet.glify' JavaScript library which extends the 'leaflet' JavaScript l ...
Download / Learn more Package Citations See dependency  

28,332

R Packages

239,283

Dependencies

75,113

Author Associations

28,333

Publication Badges

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