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



Attach the package and use:
library("openxlsx")
Maintained by
Jan Marvin Garbuszus
[Scholar Profile | Author Map]
First Published: 2014-04-21
Latest Update: 2023-02-06
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, https://cran.r-project.org/web/packages/openxlsx. Accessed 02 May. 2025.
Previous versions and publish date:
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)
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
04/0204/0304/0404/0504/0604/0704/0804/0904/1004/1104/1204/1304/1404/1504/1604/1704/1804/1904/2004/2104/2204/2304/2404/2504/2604/2704/2804/2904/30Downloads for openxlsx800090001000011000120001300014000150001600017000TrendBars

Today's Hot Picks in Authors and Packages

frailtypack  
Shared, Joint (Generalized) Frailty Models; Surrogate Endpoints
The following several classes of frailty models using a penalized likelihood estimation on the hazar ...
Download / Learn more Package Citations See dependency  
contFracR  
Continued Fraction Generators and Evaluators
Converts numbers to continued fractions and back again. A solver for Pell's Equation is provided. T ...
Download / Learn more Package Citations See dependency  
quotedargs  
A Way of Writing Functions that Quote their Arguments
A facility for writing functions that quote their arguments, may sometimes evaluate them in the env ...
Download / Learn more Package Citations See dependency  
disprofas  
Non-Parametric Dissolution Profile Analysis
Similarity of dissolution profiles is assessed using the similarity factor f2 according to the EMA ...
Download / Learn more Package Citations See dependency  
nlsem  
Fitting Structural Equation Mixture Models
Estimation of structural equation models with nonlinear effects and underlying nonnormal distributi ...
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  

24,142

R Packages

207,311

Dependencies

65,176

Author Associations

24,143

Publication Badges

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