Other packages > Find by keyword >

openxlsx2  

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


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

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

Install by package version:
library("remotes")
install_version("openxlsx2", "1.29")



Attach the package and use:
library("openxlsx2")
Maintained by
Jan Marvin Garbuszus
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2022-09-30
Latest Update: 2025-07-29
Description:
Simplifies the creation of 'xlsx' files by providing a high level interface to writing, styling and editing worksheets.
How to cite:
Jan Marvin Garbuszus (2022). openxlsx2: Read, Write and Edit 'xlsx' Files. R package version 1.29, https://cran.r-project.org/web/packages/openxlsx2. Accessed 13 Oct. 2026.
Previous versions and publish date:
(2026-10-11 14:10), 0.3.1 (2022-10-31 08:57), 0.3 (2022-09-30 09:40), 0.4.1 (2022-12-18 10:50), 0.4 (2022-12-05 09:10), 0.5.1 (2023-02-26 16:30), 0.5 (2023-01-29 16:40), 0.6.1 (2023-04-21 20:12), 0.6 (2023-04-02 11:30), 0.7.1 (2023-06-30 10:00), 0.7 (2023-05-26 09:50), 0.8 (2023-08-07 12:20), 1.0 (2023-08-25 09:10), 1.1 (2023-10-23 12:10), 1.2 (2023-11-29 11:50), 1.3 (2024-01-12 11:10), 1.4 (2024-02-16 00:20), 1.5 (2024-03-26 13:00), 1.6 (2024-05-01 11:30), 1.7 (2024-06-02 18:30), 1.8 (2024-07-07 12:30), 1.9 (2024-09-08 09:30), 1.10 (2024-10-17 20:30), 1.11 (2024-11-14 22:50), 1.12 (2024-12-19 12:30), 1.13 (2025-02-15 17:20), 1.14 (2025-03-20 18:50), 1.15 (2025-04-25 09:50), 1.16 (2025-06-06 00:20), 1.17 (2025-07-04 09:00), 1.18 (2025-07-29 12:20), 1.19 (2025-08-25 08:30), 1.20 (2025-09-29 14:20), 1.21 (2025-10-31 07:10), 1.22 (2025-12-07 08:00), 1.23.1 (2026-01-19 09:30), 1.23 (2026-01-16 10:10), 1.24 (2026-02-21 07:10), 1.25 (2026-03-07 15:00), 1.26 (2026-04-17 07:10), 1.27 (2026-05-25 18:00), 1.28 (2026-07-03 01:10), 1.29 (2026-08-20 15:20)
Other packages that cited openxlsx2 R package
View openxlsx2 citation profile
Other R packages that openxlsx2 depends, imports, suggests or enhances
Complete documentation for openxlsx2
Functions, R codes and Examples using the openxlsx2 R package
Some associated functions: active_sheet-wb . as_xml . base_font-wb . clean_worksheet_name . col2int . col_widths-wb . comment_internal . convertToExcelDate . convert_date . convert_to_excel_date . create_border . create_cell_style . create_comment . create_dxfs_style . create_fill . create_font . create_hyperlink . create_numfmt . create_sparklines . create_tablestyle . creators-wb . dataframe_to_dims . delete_data . dims_helper . dims_to_dataframe . filter-wb . fmt_txt . grouping-wb . int2col . named_region-wb . openxlsx2-deprecated . openxlsx2-package . openxlsx2_options . person-wb . pipe . print.pugi_xml . properties-wb . pugixml . read_xml . row_heights-wb . sheet_names-wb . sheet_visibility-wb . styles_on_sheet . temp_xlsx . waivers . wbWorkbook . wb_add_border . wb_add_cell_style . wb_add_chart_xml . wb_add_chartsheet . wb_add_comment . wb_add_conditional_formatting . wb_add_data . wb_add_data_table . wb_add_data_validation . wb_add_drawing . wb_add_dxfs_style . wb_add_fill . wb_add_font . wb_add_form_control . wb_add_formula . wb_add_ignore_error . wb_add_image . wb_add_mschart . wb_add_named_style . wb_add_numfmt . wb_add_page_break . wb_add_pivot_table . wb_add_plot . wb_add_slicer . wb_add_sparklines . wb_add_style . wb_add_thread . wb_add_worksheet . wb_cell_style . wb_clean_sheet . wb_clone_sheet_style . wb_clone_worksheet . wb_color . wb_comment . wb_copy_cells . wb_data . wb_dims . wb_freeze_pane . wb_get_tables . wb_load . wb_merge_cells . wb_open . wb_order . wb_page_setup . wb_protect . wb_protect_worksheet . wb_remove_tables . wb_remove_worksheet . wb_save . wb_set_bookview . wb_set_grid_lines . wb_set_header_footer . wb_set_last_modified_by . wb_set_sheetview . wb_to_df . wb_update_table . wb_workbook . write_data . write_datatable . write_formula . write_xlsx . xl_open . xml_add_child . xml_attr_mod . xml_node_create . xml_rm_child . 
Some associated R codes: RcppExports.R . asserts.R . baseXML.R . class-chart-sheet.R . class-color.R . class-comment.R . class-hyperlink.R . class-sheet-data.R . class-style_mgr.R . class-workbook-utils.R . class-workbook-wrappers.R . class-workbook.R . class-worksheet.R . conditional_formatting.R . converters.R . dates.R . get-named-regions.R . helper-functions.R . illegal-characters.R . onUnload.R . openxlsx2-package.R . pugixml.R . read.R . standardize.R . utils-pipe.R . utils.R . wb_functions.R . wb_load.R . wb_styles.R . write.R . write_xlsx.R . xl_open.R .  Full openxlsx2 package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

dafs  
Data Analysis for Forensic Scientists
Data and miscellanea to support the book "Introduction to Data analysis with R for Forensic Scientis ...
Download / Learn more Package Citations See dependency  
robust2sls  
Outlier Robust Two-Stage Least Squares Inference and Testing
An implementation of easy tools for outlier robust inference in two-stage least squares (2SLS) mode ...
Download / Learn more Package Citations See dependency  
covid19us  
Cases of COVID-19 in the United States
A wrapper around the 'COVID Tracking Project API' providing data o ...
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  
weibullness  
Goodness-of-Fit Test for Weibull Distribution (Weibullness)
Conducts a goodness-of-fit test for the Weibull distribution (referred to as the weibullness test) a ...
Download / Learn more Package Citations See dependency  

29,000

R Packages

247,686

Dependencies

76,729

Author Associations

29,001

Publication Badges

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