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.7.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: 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.7.1, https://cran.r-project.org/web/packages/openxlsx. Accessed 30 Jan. 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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

GGMncv  
Gaussian Graphical Models with Nonconvex Regularization
Estimate Gaussian graphical models with nonconvex penalties , including ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
WtTopsis  
Weighted Method for Multiple-Criteria Decision Making
Evaluation of alternatives based on multiple criteria using weighted technique for Order preference ...
Download / Learn more Package Citations See dependency  
fastmit  
Fast Mutual Information Based Independence Test
A mutual information estimator based on k-nearest neighbor method proposed by A. Kraskov, et al. (20 ...
Download / Learn more Package Citations See dependency  
convertid  
Convert Gene IDs Between Each Other and Fetch Annotations from Biomart
Gene Symbols or Ensembl Gene IDs are converted using the Bimap interface in 'AnnotationDbi' in conve ...
Download / Learn more Package Citations See dependency  
kesernetwork  
Visualization of the KESER Network
A shiny app to visualize the knowledge networks for the code concepts. Using co-occurrence matrices ...
Download / Learn more Package Citations See dependency  

23,580

R Packages

204,057

Dependencies

63,980

Author Associations

23,581

Publication Badges

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