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



Attach the package and use:
library("openxlsx2")
Maintained by
Jan Marvin Garbuszus
[Scholar Profile | Author Map]
First Published: 2022-09-30
Latest Update: 2024-02-15
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.15, https://cran.r-project.org/web/packages/openxlsx2. Accessed 07 May. 2025.
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)
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
04/0704/0804/0904/1004/1104/1204/1304/1404/1504/1604/1704/1804/1904/2004/2104/2204/2304/2404/2504/2604/2704/2804/2904/3005/0105/0205/0305/0405/0505/06Downloads for openxlsx250100150200250300350400450TrendBars

Today's Hot Picks in Authors and Packages

humanize  
Create Values for Human Consumption
An almost direct port of the 'python' 'humanize' package . Thi ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
funLBM  
Model-Based Co-Clustering of Functional Data
The funLBM algorithm allows to simultaneously cluster the rows and the columns of a data matrix wher ...
Download / Learn more Package Citations See dependency  
aroma.affymetrix  
Analysis of Large Affymetrix Microarray Data Sets
A cross-platform R framework that facilitates processing of any number of Affymetrix microarray samp ...
Download / Learn more Package Citations See dependency  
MLDS  
Maximum Likelihood Difference Scaling
Difference scaling is a method for scaling perceived supra-threshold differences. The package cont ...
Download / Learn more Package Citations See dependency  

24,205

R Packages

207,311

Dependencies

65,312

Author Associations

24,206

Publication Badges

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