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



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.23.1, https://cran.r-project.org/web/packages/openxlsx2. Accessed 06 Mar. 2026.
Previous versions and publish date:
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)
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

EMVS  
The Expectation-Maximization Approach to Bayesian Variable Selection
An efficient expectation-maximization algorithm for fitting Bayesian spike-and-slab regularization p ...
Download / Learn more Package Citations See dependency  
mlr3viz  
Visualizations for 'mlr3'
Visualization package of the 'mlr3' ecosystem. It features plots for mlr3 objects such as tasks, le ...
Download / Learn more Package Citations See dependency  
solitude  
An Implementation of Isolation Forest
Isolation forest is anomaly detection method introduced by the paper Isolation based Anomaly Detecti ...
Download / Learn more Package Citations See dependency  
DatabionicSwarm  
Swarm Intelligence for Self-Organized Clustering
Algorithms implementing populations of agents that interact with one another and sense their environ ...
Download / Learn more Package Citations See dependency  
openxlsx  
Read, Write and Edit xlsx Files
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, stylin ...
Download / Learn more Package Citations See dependency  
lbfgs  
Limited-memory BFGS Optimization
A wrapper built around the libLBFGS optimization library by Naoaki Okazaki. The lbfgs package implem ...
Download / Learn more Package Citations See dependency  

26,264

R Packages

223,360

Dependencies

70,376

Author Associations

26,265

Publication Badges

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