{ "_id": "6a21b400cd65a98ecbd3cf55", "Type": "Package", "Package": "openxlsx2", "Title": "Read, Write and Edit 'xlsx' Files", "Version": "1.27.0.9000", "Language": "en-US", "Authors@R": "c(\nperson(\"Jordan Mark\", \"Barbone\", email = \"jmbarbone@gmail.com\", role = \"aut\", comment = c(ORCID = \"0000-0001-9788-3628\")),\nperson(\"Jan Marvin\", \"Garbuszus\", email = \"jan.garbuszus@ruhr-uni-bochum.de\", role = c(\"aut\", \"cre\")),\nperson(\"Olivier\", \"Roy\", role = \"ctb\"),\nperson(family = \"openxlsx authors\", role = \"cph\", comment = \"openxlsx package\"),\nperson(\"Arseny\", \"Kapoulkine\", role = c(\"ctb\", \"cph\"), comment = \"Author of included pugixml code\")\n)", "Description": "Simplifies the creation of 'xlsx' files by providing a\nhigh level interface to writing, styling and editing\nworksheets.", "License": "MIT + file LICENSE", "URL": "https://janmarvin.github.io/openxlsx2/,\nhttps://github.com/JanMarvin/openxlsx2", "BugReports": "https://github.com/JanMarvin/openxlsx2/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "Config/roxygen2/version": "8.0.0", "Config/testthat/edition": "3", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://janmarvin.r-universe.dev", "Date/Publication": "2026-06-04 16:49:26 UTC", "RemoteUrl": "https://github.com/JanMarvin/openxlsx2", "RemoteRef": "HEAD", "RemoteSha": "02137db1c61070f2434c3c425b89acf23338c7d8", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-06-04 17:09:08 UTC", "User": "root" }, "Author": "Jordan Mark Barbone [aut] (ORCID:\n),\nJan Marvin Garbuszus [aut, cre],\nOlivier Roy [ctb],\nopenxlsx authors [cph] (openxlsx package),\nArseny Kapoulkine [ctb, cph] (Author of included pugixml code)", "Maintainer": "Jan Marvin Garbuszus ", "MD5sum": "15277c6e841238578cf99ca63d990f09", "_user": "janmarvin", "_type": "src", "_file": "openxlsx2_1.27.0.9000.tar.gz", "_fileid": "4d1fefda7469c3bb9acf07c2fbf2908d2590017228aeb82ad5234827b133926f", "_filesize": 2225424, "_sha256": "4d1fefda7469c3bb9acf07c2fbf2908d2590017228aeb82ad5234827b133926f", "_created": "2026-06-04T17:09:08.000Z", "_published": "2026-06-04T17:21:04.163Z", "_distro": "noble", "_jobs": [ { "job": 79573374517, "time": 267, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7418151953" }, { "job": 79573374570, "time": 232, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7418137668" }, { "job": 79573374503, "time": 266, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7418151524" }, { "job": 79573374498, "time": 275, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7418153481" }, { "job": 79573374518, "time": 223, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7418146707" }, { "job": 79573374535, "time": 387, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "7418208340" }, { "job": 79573374510, "time": 202, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7418161662" }, { "job": 79573374522, "time": 573, "config": "macos-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7418283206" }, { "job": 79572402293, "time": 307, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7418045415" }, { "job": 79573374533, "time": 144, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7418104124" }, { "job": 79573374532, "time": 344, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7418178895" }, { "job": 79573374555, "time": 285, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7418157604" }, { "job": 79573374513, "time": 316, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7418168963" } ], "_buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/JanMarvin/openxlsx2", "_commit": { "id": "02137db1c61070f2434c3c425b89acf23338c7d8", "author": "Jan Marvin Garbuszus ", "committer": "GitHub ", "message": "[cpp] update df_to_xml() (#1633)\n\n* [cpp] update df_to_xml()\n\nFixes #1632\n\n* [cpp] cleanups", "time": 1780591766 }, "_maintainer": { "name": "Jan Marvin Garbuszus", "email": "jan.garbuszus@ruhr-uni-bochum.de", "login": "janmarvin", "linkedin": "in/jan-marvin-garbuszus", "description": "", "uuid": 1645626 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5.0", "role": "Depends" }, { "package": "Rcpp", "role": "LinkingTo" }, { "package": "R6", "role": "Imports" }, { "package": "Rcpp", "role": "Imports" }, { "package": "grDevices", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "encharter", "role": "Suggests" }, { "package": "mschart", "version": ">= 0.4", "role": "Suggests" }, { "package": "openssl", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "rvg", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "zip", "role": "Suggests" } ], "_owner": "janmarvin", "_selfowned": true, "_usedby": 25, "_updates": [ { "week": "2025-23", "n": 12 }, { "week": "2025-24", "n": 6 }, { "week": "2025-25", "n": 2 }, { "week": "2025-26", "n": 1 }, { "week": "2025-27", "n": 4 }, { "week": "2025-28", "n": 3 }, { "week": "2025-29", "n": 4 }, { "week": "2025-30", "n": 1 }, { "week": "2025-31", "n": 3 }, { "week": "2025-32", "n": 1 }, { "week": "2025-33", "n": 5 }, { "week": "2025-34", "n": 3 }, { "week": "2025-35", "n": 3 }, { "week": "2025-36", "n": 1 }, { "week": "2025-39", "n": 1 }, { "week": "2025-40", "n": 4 }, { "week": "2025-42", "n": 1 }, { "week": "2025-44", "n": 9 }, { "week": "2025-45", "n": 2 }, { "week": "2025-46", "n": 1 }, { "week": "2025-47", "n": 6 }, { "week": "2025-48", "n": 12 }, { "week": "2025-49", "n": 1 }, { "week": "2025-50", "n": 3 }, { "week": "2025-51", "n": 11 }, { "week": "2025-52", "n": 5 }, { "week": "2026-01", "n": 10 }, { "week": "2026-02", "n": 4 }, { "week": "2026-03", "n": 1 }, { "week": "2026-04", "n": 13 }, { "week": "2026-05", "n": 7 }, { "week": "2026-06", "n": 10 }, { "week": "2026-07", "n": 8 }, { "week": "2026-08", "n": 6 }, { "week": "2026-09", "n": 7 }, { "week": "2026-10", "n": 4 }, { "week": "2026-11", "n": 4 }, { "week": "2026-12", "n": 6 }, { "week": "2026-13", "n": 3 }, { "week": "2026-15", "n": 1 }, { "week": "2026-16", "n": 2 }, { "week": "2026-17", "n": 1 }, { "week": "2026-18", "n": 2 }, { "week": "2026-19", "n": 1 }, { "week": "2026-20", "n": 4 }, { "week": "2026-22", "n": 2 }, { "week": "2026-23", "n": 1 } ], "_tags": [ { "name": "v1.16", "date": "2025-06-05" }, { "name": "v1.17", "date": "2025-07-04" }, { "name": "v1.18", "date": "2025-07-29" }, { "name": "v1.19", "date": "2025-08-26" }, { "name": "v1.20", "date": "2025-09-29" }, { "name": "v1.21", "date": "2025-10-31" }, { "name": "v1.22", "date": "2025-12-07" }, { "name": "v1.23", "date": "2026-01-16" }, { "name": "v1.23.1", "date": "2026-01-19" }, { "name": "v1.24", "date": "2026-02-21" }, { "name": "v1.25", "date": "2026-03-07" }, { "name": "v1.26", "date": "2026-04-17" }, { "name": "v1.27", "date": "2026-05-25" } ], "_topics": [ "xlsx", "cpp" ], "_stars": 193, "_contributors": [ { "user": "janmarvin", "count": 2018, "uuid": 1645626 }, { "user": "awalker89", "count": 690, "uuid": 7400673 }, { "user": "jmbarbone", "count": 638, "uuid": 38573843 }, { "user": "ycphs", "count": 325, "uuid": 21127941 }, { "user": "olivroy", "count": 52, "uuid": 52606734 }, { "user": "joshuasturm", "count": 48, "uuid": 22535419 }, { "user": "shrektan", "count": 17, "uuid": 8368933 }, { "user": "lbraglia", "count": 17, "uuid": 603306 }, { "user": "jmpivette", "count": 10, "uuid": 46813298 }, { "user": "kainhofer", "count": 10, "uuid": 4689419 }, { "user": "blakeboswell", "count": 7, "uuid": 12782539 }, { "user": "chris-stockbridge", "count": 5, "uuid": 36540350 }, { "user": "heseber", "count": 5, "uuid": 22882929 }, { "user": "noamross", "count": 5, "uuid": 571752 }, { "user": "t-kalinowski", "count": 4, "uuid": 8462255 }, { "user": "luke-symes-tsy", "count": 3, "uuid": 93558726 }, { "user": "vkatti", "count": 3, "uuid": 76277932 }, { "user": "debarros", "count": 3, "uuid": 9647582 }, { "user": "christiankaindl", "count": 2, "uuid": 15364860 }, { "user": "sjewo", "count": 2, "uuid": 2435621 }, { "user": "tkunstek", "count": 2, "uuid": 1747963 }, { "user": "davidgohel", "count": 2, "uuid": 4331618 }, { "user": "rogerssam", "count": 1, "uuid": 7007561 }, { "user": "shitao5", "count": 1, "uuid": 68451957 }, { "user": "trekonom", "count": 1, "uuid": 16198114 }, { "user": "pteridin", "count": 1, "uuid": 29350560 }, { "user": "david-f1976", "count": 1, "uuid": 13930432 }, { "user": "mlell", "count": 1, "uuid": 16210594 }, { "user": "shaesen2", "count": 1, "uuid": 47894155 }, { "user": "tobwen", "count": 1, "uuid": 1864057 }, { "user": "uhkeller", "count": 1, "uuid": 2323704 }, { "user": "yasirs", "count": 1, "uuid": 400538 }, { "user": "elenius", "count": 1, "uuid": 5310644 }, { "user": "j-moravec", "count": 1, "uuid": 10236938 }, { "user": "gfiumara", "count": 1, "uuid": 419642 }, { "user": "fweimer-rh", "count": 1, "uuid": 75532728 }, { "user": "ecortens", "count": 1, "uuid": 3460446 }, { "user": "darxor", "count": 1, "uuid": 1351765 }, { "user": "balthasars", "count": 1, "uuid": 37873951 }, { "user": "aslomko", "count": 1, "uuid": 11588153 }, { "user": "kloppen", "count": 1, "uuid": 12833793 } ], "_userbio": { "uuid": 1645626, "type": "user", "name": "Jan Marvin Garbuszus" }, "_downloads": { "count": 17148, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/openxlsx2" }, "_devurl": "https://github.com/janmarvin/openxlsx2", "_pkgdown": "https://janmarvin.github.io/openxlsx2/", "_searchresults": 527, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/openxlsx2.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/janmarvin/openxlsx2", "_realowner": "janmarvin", "_cranurl": true, "_releases": [ { "version": "0.3", "date": "2022-09-30" }, { "version": "0.3.1", "date": "2022-10-31" }, { "version": "0.4", "date": "2022-12-05" }, { "version": "0.4.1", "date": "2022-12-18" }, { "version": "0.5", "date": "2023-01-29" }, { "version": "0.5.1", "date": "2023-02-26" }, { "version": "0.6", "date": "2023-04-02" }, { "version": "0.6.1", "date": "2023-04-21" }, { "version": "0.7", "date": "2023-05-26" }, { "version": "0.7.1", "date": "2023-06-30" }, { "version": "0.8", "date": "2023-08-07" }, { "version": "1.0", "date": "2023-08-25" }, { "version": "1.1", "date": "2023-10-23" }, { "version": "1.2", "date": "2023-11-29" }, { "version": "1.3", "date": "2024-01-12" }, { "version": "1.4", "date": "2024-02-16" }, { "version": "1.5", "date": "2024-03-26" }, { "version": "1.6", "date": "2024-05-01" }, { "version": "1.7", "date": "2024-06-02" }, { "version": "1.8", "date": "2024-07-07" }, { "version": "1.9", "date": "2024-09-08" }, { "version": "1.10", "date": "2024-10-17" }, { "version": "1.11", "date": "2024-11-14" }, { "version": "1.12", "date": "2024-12-19" }, { "version": "1.13", "date": "2025-02-15" }, { "version": "1.14", "date": "2025-03-22" }, { "version": "1.15", "date": "2025-04-25" }, { "version": "1.16", "date": "2025-06-05" }, { "version": "1.17", "date": "2025-07-04" }, { "version": "1.18", "date": "2025-08-01" }, { "version": "1.19", "date": "2025-08-25" }, { "version": "1.20", "date": "2025-09-29" }, { "version": "1.21", "date": "2025-10-31" }, { "version": "1.22", "date": "2025-12-11" }, { "version": "1.23", "date": "2026-01-16" }, { "version": "1.23.1", "date": "2026-01-19" }, { "version": "1.24", "date": "2026-02-21" }, { "version": "1.25", "date": "2026-03-07" }, { "version": "1.26", "date": "2026-04-17" }, { "version": "1.27", "date": "2026-05-25" } ], "_exports": [ "apply_numfmt", "as_xml", "col2int", "convert_date", "convert_datetime", "convert_hms", "convert_to_excel_date", "convertToExcelDate", "create_border", "create_cell_style", "create_colors_xml", "create_colours_xml", "create_comment", "create_dxfs_style", "create_fill", "create_font", "create_hyperlink", "create_numfmt", "create_pivottablestyle", "create_shape", "create_sparklines", "create_tablestyle", "current_sheet", "dataframe_to_dims", "delete_data", "dims_to_dataframe", "dims_to_rowcol", "fmt_txt", "int2col", "na_strings", "next_sheet", "read_xlsx", "read_xml", "remove_comment", "rowcol_to_dims", "styles_on_sheet", "temp_xlsx", "validate_dims", "wb_add_border", "wb_add_cell_style", "wb_add_chart_xml", "wb_add_chartsheet", "wb_add_comment", "wb_add_conditional_formatting", "wb_add_creators", "wb_add_data", "wb_add_data_table", "wb_add_data_validation", "wb_add_drawing", "wb_add_dxfs_style", "wb_add_encharter", "wb_add_fill", "wb_add_filter", "wb_add_font", "wb_add_form_control", "wb_add_formula", "wb_add_hyperlink", "wb_add_ignore_error", "wb_add_image", "wb_add_mips", "wb_add_mschart", "wb_add_named_region", "wb_add_named_style", "wb_add_numfmt", "wb_add_page_break", "wb_add_person", "wb_add_pivot_table", "wb_add_plot", "wb_add_slicer", "wb_add_sparklines", "wb_add_style", "wb_add_thread", "wb_add_timeline", "wb_add_worksheet", "wb_clean_sheet", "wb_clone_sheet_style", "wb_clone_worksheet", "wb_color", "wb_colour", "wb_comment", "wb_copy_cells", "wb_data", "wb_dims", "wb_freeze_pane", "wb_get_active_sheet", "wb_get_base_colors", "wb_get_base_colours", "wb_get_base_font", "wb_get_bookview", "wb_get_cell_style", "wb_get_comment", "wb_get_creators", "wb_get_mips", "wb_get_named_regions", "wb_get_order", "wb_get_person", "wb_get_properties", "wb_get_selected", "wb_get_sheet_names", "wb_get_sheet_visibility", "wb_get_tables", "wb_get_thread", "wb_grid_lines", "wb_group_cols", "wb_group_rows", "wb_load", "wb_merge_cells", "wb_open", "wb_page_setup", "wb_protect", "wb_protect_worksheet", "wb_read", "wb_remove_bookview", "wb_remove_col_widths", "wb_remove_comment", "wb_remove_conditional_formatting", "wb_remove_creators", "wb_remove_filter", "wb_remove_hyperlink", "wb_remove_named_region", "wb_remove_row_heights", "wb_remove_slicer", "wb_remove_tables", "wb_remove_timeline", "wb_remove_worksheet", "wb_save", "wb_set_active_sheet", "wb_set_base_colors", "wb_set_base_colours", "wb_set_base_font", "wb_set_bookview", "wb_set_cell_style", "wb_set_cell_style_across", "wb_set_col_widths", "wb_set_creators", "wb_set_grid_lines", "wb_set_header_footer", "wb_set_last_modified_by", "wb_set_order", "wb_set_page_setup", "wb_set_properties", "wb_set_row_heights", "wb_set_selected", "wb_set_sheet_names", "wb_set_sheet_visibility", "wb_set_sheetview", "wb_to_df", "wb_ungroup_cols", "wb_ungroup_rows", "wb_unmerge_cells", "wb_update_table", "wb_workbook", "wbWorkbook", "write_comment", "write_data", "write_datatable", "write_formula", "write_xlsx", "xl_open", "xml_add_child", "xml_attr", "xml_attr_mod", "xml_node", "xml_node_create", "xml_node_name", "xml_rm_child", "xml_value" ], "_help": [ { "page": "active_sheet-wb", "title": "Modify the state of active and selected sheets in a workbook", "topics": [ "active_sheet-wb", "wb_get_active_sheet", "wb_get_selected", "wb_set_active_sheet", "wb_set_selected" ] }, { "page": "apply_numfmt", "title": "Format Values using OOXML (Spreadsheet) Number Format Codes", "topics": [ "apply_numfmt" ] }, { "page": "as_xml", "title": "loads character string to pugixml and returns an externalptr", "topics": [ "as_xml" ] }, { "page": "as.character.pugi_xml", "title": "as.character pugi_xml", "topics": [ "as.character.pugi_xml" ] }, { "page": "base_font-wb", "title": "Set the default font in a workbook", "concept": [ "workbook styling functions", "workbook wrappers" ], "topics": [ "base_font-wb", "wb_get_base_font", "wb_set_base_font" ] }, { "page": "clean_worksheet_name", "title": "Clean worksheet name", "topics": [ "clean_worksheet_name" ] }, { "page": "col_widths-wb", "title": "Modify column widths of a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "col_widths-wb", "wb_remove_col_widths", "wb_set_col_widths" ] }, { "page": "col2int", "title": "Convert spreadsheet column notation to integers", "topics": [ "col2int" ] }, { "page": "convert_date", "title": "Convert from spreadsheet date, datetime or hms number to R Date type", "topics": [ "convert_date", "convert_datetime", "convert_hms" ] }, { "page": "convert_to_excel_date", "title": "convert back to an Excel Date", "topics": [ "convert_to_excel_date" ] }, { "page": "create_border", "title": "Create border format", "concept": [ "style creating functions" ], "topics": [ "create_border" ] }, { "page": "create_cell_style", "title": "Create cell style", "concept": [ "style creating functions" ], "topics": [ "create_cell_style" ] }, { "page": "create_colors_xml", "title": "Create custom color xml schemes", "concept": [ "style creating functions" ], "topics": [ "create_colors_xml", "create_colours_xml" ] }, { "page": "create_dxfs_style", "title": "Create a custom formatting style", "concept": [ "style creating functions" ], "topics": [ "create_dxfs_style" ] }, { "page": "create_fill", "title": "Create fill pattern", "concept": [ "style creating functions" ], "topics": [ "create_fill" ] }, { "page": "create_font", "title": "Create font format", "concept": [ "style creating functions" ], "topics": [ "create_font" ] }, { "page": "create_hyperlink", "title": "Create spreadsheet hyperlink string", "topics": [ "create_hyperlink" ] }, { "page": "create_numfmt", "title": "Create number format", "concept": [ "style creating functions" ], "topics": [ "create_numfmt" ] }, { "page": "create_shape", "title": "Helper to create a shape", "topics": [ "create_shape" ] }, { "page": "create_sparklines", "title": "Create a sparklines object", "topics": [ "create_sparklines" ] }, { "page": "create_tablestyle", "title": "Create custom (pivot) table styles", "concept": [ "style creating functions" ], "topics": [ "create_pivottablestyle", "create_tablestyle" ] }, { "page": "creators-wb", "title": "Modify creators of a workbook", "concept": [ "workbook wrappers" ], "topics": [ "creators-wb", "wb_add_creators", "wb_get_creators", "wb_remove_creators", "wb_set_creators" ] }, { "page": "dims_helper", "title": "Helper functions to work with 'dims'", "topics": [ "dims_helper", "dims_to_rowcol", "rowcol_to_dims", "validate_dims" ] }, { "page": "filter-wb", "title": "Add/remove column filters in a worksheet", "concept": [ "worksheet content functions" ], "topics": [ "filter-wb", "wb_add_filter", "wb_remove_filter" ] }, { "page": "fmt_txt", "title": "format strings independent of the cell style.", "topics": [ "+.fmt_txt", "as.character.fmt_txt", "fmt_txt", "print.fmt_txt" ] }, { "page": "grouping-wb", "title": "Group rows and columns in a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "grouping-wb", "wb_group_cols", "wb_group_rows", "wb_ungroup_cols", "wb_ungroup_rows" ] }, { "page": "int2col", "title": "Convert integers to spreadsheet column notation", "topics": [ "int2col" ] }, { "page": "named_region-wb", "title": "Modify named regions in a worksheet", "concept": [ "worksheet content functions" ], "topics": [ "named_region-wb", "wb_add_named_region", "wb_get_named_regions", "wb_remove_named_region" ] }, { "page": "openxlsx2_options", "title": "Options consulted by openxlsx2", "topics": [ "openxlsx2_options" ] }, { "page": "openxlsx2-deprecated", "title": "Deprecated functions in package _openxlsx2_", "topics": [ "openxlsx2-deprecated" ] }, { "page": "person-wb", "title": "Helper for adding threaded comments", "topics": [ "person-wb", "wb_add_person", "wb_get_person" ] }, { "page": "print.pugi_xml", "title": "print pugi_xml", "topics": [ "print.pugi_xml" ] }, { "page": "properties-wb", "title": "Modify workbook properties", "topics": [ "properties-wb", "wb_get_properties", "wb_set_properties" ] }, { "page": "pugixml", "title": "xml_node", "topics": [ "pugixml", "xml_attr", "xml_node", "xml_node_name", "xml_value" ] }, { "page": "read_xml", "title": "read xml file", "topics": [ "read_xml" ] }, { "page": "row_heights-wb", "title": "Modify row heights of a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "row_heights-wb", "wb_remove_row_heights", "wb_set_row_heights" ] }, { "page": "sheet_names-wb", "title": "Get / Set worksheet names for a workbook", "topics": [ "sheet_names-wb", "wb_get_sheet_names", "wb_set_sheet_names" ] }, { "page": "sheet_visibility-wb", "title": "Get/set worksheet visible state in a workbook", "topics": [ "sheet_visibility-wb", "wb_get_sheet_visibility", "wb_set_sheet_visibility" ] }, { "page": "styles_on_sheet", "title": "Get all styles on a sheet", "topics": [ "styles_on_sheet" ] }, { "page": "temp_xlsx", "title": "helper function to create temporary directory for testing purpose", "topics": [ "temp_xlsx" ] }, { "page": "waivers", "title": "'openxlsx2' waivers", "topics": [ "current_sheet", "na_strings", "next_sheet", "waivers" ] }, { "page": "wb_add_border", "title": "Modify borders in a cell region of a worksheet", "concept": [ "styles" ], "topics": [ "wb_add_border" ] }, { "page": "wb_add_cell_style", "title": "Modify the style in a cell region", "concept": [ "styles" ], "topics": [ "wb_add_cell_style" ] }, { "page": "wb_add_chart_xml", "title": "Add a chart XML to a worksheet", "topics": [ "wb_add_chart_xml" ] }, { "page": "wb_add_chartsheet", "title": "Add a chartsheet to a workbook", "concept": [ "workbook wrappers" ], "topics": [ "wb_add_chartsheet" ] }, { "page": "wb_add_comment", "title": "Add comment to worksheet", "topics": [ "wb_add_comment", "wb_get_comment", "wb_remove_comment" ] }, { "page": "wb_add_conditional_formatting", "title": "Add conditional formatting to cells in a worksheet", "concept": [ "worksheet content functions" ], "topics": [ "wb_add_conditional_formatting", "wb_remove_conditional_formatting" ] }, { "page": "wb_add_data", "title": "Add data to a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_data" ] }, { "page": "wb_add_data_table", "title": "Add a data table to a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_data_table" ] }, { "page": "wb_add_data_validation", "title": "Add data validation to cells in a worksheet", "topics": [ "wb_add_data_validation" ] }, { "page": "wb_add_drawing", "title": "Add drawings to a worksheet", "topics": [ "wb_add_drawing" ] }, { "page": "wb_add_dxfs_style", "title": "Set a dxfs style for the workbook", "concept": [ "workbook styling functions" ], "topics": [ "wb_add_dxfs_style" ] }, { "page": "wb_add_encharter", "title": "Add a Chart object to a workbook sheet", "topics": [ "wb_add_encharter" ] }, { "page": "wb_add_fill", "title": "Modify the background fill color in a cell region", "concept": [ "styles" ], "topics": [ "wb_add_fill" ] }, { "page": "wb_add_font", "title": "Modify font properties in a cell region", "concept": [ "styles" ], "topics": [ "wb_add_font" ] }, { "page": "wb_add_form_control", "title": "Add a checkbox, radio button or drop menu to a cell in a worksheet", "topics": [ "wb_add_form_control" ] }, { "page": "wb_add_formula", "title": "Add a formula to a cell range in a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_formula" ] }, { "page": "wb_add_hyperlink", "title": "wb_add_hyperlink", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_hyperlink", "wb_remove_hyperlink" ] }, { "page": "wb_add_ignore_error", "title": "Ignore error types on a worksheet", "topics": [ "wb_add_ignore_error" ] }, { "page": "wb_add_image", "title": "Insert an image into a worksheet", "topics": [ "wb_add_image" ] }, { "page": "wb_add_mips", "title": "wb get and apply MIP section", "topics": [ "wb_add_mips", "wb_get_mips" ] }, { "page": "wb_add_mschart", "title": "Add an mschart object to a worksheet", "topics": [ "wb_add_mschart" ] }, { "page": "wb_add_named_style", "title": "Apply styling to a cell region with a named style", "concept": [ "styles" ], "topics": [ "wb_add_named_style" ] }, { "page": "wb_add_numfmt", "title": "Modify number formatting in a cell region", "concept": [ "styles" ], "topics": [ "wb_add_numfmt" ] }, { "page": "wb_add_page_break", "title": "Add a page break to a worksheet", "topics": [ "wb_add_page_break" ] }, { "page": "wb_add_pivot_table", "title": "Add a pivot table to a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_pivot_table" ] }, { "page": "wb_add_plot", "title": "Insert the current R plot into a worksheet", "topics": [ "wb_add_plot" ] }, { "page": "wb_add_slicer", "title": "Add a slicer/timeline to a pivot table", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_add_slicer", "wb_add_timeline", "wb_remove_slicer", "wb_remove_timeline" ] }, { "page": "wb_add_sparklines", "title": "Add sparklines to a worksheet", "topics": [ "wb_add_sparklines" ] }, { "page": "wb_add_style", "title": "Register a style in a workbook", "concept": [ "workbook styling functions" ], "topics": [ "wb_add_style" ] }, { "page": "wb_add_thread", "title": "Add threaded comments to a cell in a worksheet", "concept": [ "worksheet content functions" ], "topics": [ "wb_add_thread", "wb_get_thread" ] }, { "page": "wb_add_worksheet", "title": "Add a worksheet to a workbook", "concept": [ "workbook wrappers" ], "topics": [ "wb_add_worksheet" ] }, { "page": "wb_base_colors", "title": "Set the default colors in a workbook", "concept": [ "workbook styling functions", "workbook wrappers" ], "topics": [ "wb_base_colors", "wb_get_base_colors", "wb_get_base_colours", "wb_set_base_colors", "wb_set_base_colours" ] }, { "page": "wb_cell_style", "title": "Get or set cell style indices", "concept": [ "styles" ], "topics": [ "wb_cell_style", "wb_get_cell_style", "wb_set_cell_style", "wb_set_cell_style_across" ] }, { "page": "wb_clean_sheet", "title": "Clear content and formatting from a worksheet", "topics": [ "wb_clean_sheet" ] }, { "page": "wb_clone_sheet_style", "title": "Apply styling from a sheet to another within a workbook", "topics": [ "wb_clone_sheet_style" ] }, { "page": "wb_clone_worksheet", "title": "Create copies of a worksheet within a workbook", "concept": [ "workbook wrappers" ], "topics": [ "wb_clone_worksheet" ] }, { "page": "wb_color", "title": "Create a color object for workbook styling", "topics": [ "wb_color", "wb_colour" ] }, { "page": "wb_comment", "title": "Helper to create a comment object", "topics": [ "wb_comment" ] }, { "page": "wb_copy_cells", "title": "Copy cells around within a worksheet", "concept": [ "workbook wrappers" ], "topics": [ "wb_copy_cells" ] }, { "page": "wb_data", "title": "Add the 'wb_data' attribute to a data frame in a worksheet", "topics": [ "wb_data", "[.wb_data" ] }, { "page": "wb_dims", "title": "Helper to specify the 'dims' argument", "topics": [ "wb_dims" ] }, { "page": "wb_freeze_pane", "title": "Freeze panes of a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_freeze_pane" ] }, { "page": "wb_get_tables", "title": "List tables in a worksheet", "topics": [ "wb_get_tables" ] }, { "page": "wb_load", "title": "Load an existing .xlsx, .xlsm or .xlsb file", "topics": [ "wb_load" ] }, { "page": "wb_merge_cells", "title": "Merge cells within a worksheet", "concept": [ "workbook wrappers", "worksheet content functions" ], "topics": [ "wb_merge_cells", "wb_unmerge_cells" ] }, { "page": "wb_open", "title": "Preview a workbook in spreadsheet software", "topics": [ "wb_open" ] }, { "page": "wb_order", "title": "Order worksheets in a workbook", "topics": [ "wb_get_order", "wb_order", "wb_set_order" ] }, { "page": "wb_page_setup", "title": "Set page margins, orientation and print scaling of a worksheet", "topics": [ "wb_page_setup", "wb_set_page_setup" ] }, { "page": "wb_protect", "title": "Protect a workbook from modifications", "topics": [ "wb_protect" ] }, { "page": "wb_protect_worksheet", "title": "Protect a worksheet from modifications", "topics": [ "wb_protect_worksheet" ] }, { "page": "wb_remove_tables", "title": "Remove a data table from a worksheet", "topics": [ "wb_remove_tables" ] }, { "page": "wb_remove_worksheet", "title": "Remove a worksheet from a workbook", "topics": [ "wb_remove_worksheet" ] }, { "page": "wb_save", "title": "Save a workbook to file", "concept": [ "workbook wrappers" ], "topics": [ "wb_save" ] }, { "page": "wb_set_bookview", "title": "Get and Set the workbook position, size and filter", "topics": [ "wb_get_bookview", "wb_remove_bookview", "wb_set_bookview" ] }, { "page": "wb_set_grid_lines", "title": "Modify grid lines visibility in a worksheet", "topics": [ "wb_grid_lines", "wb_set_grid_lines" ] }, { "page": "wb_set_header_footer", "title": "Set headers and footers of a worksheet", "topics": [ "wb_set_header_footer" ] }, { "page": "wb_set_last_modified_by", "title": "Modify author in the metadata of a workbook", "concept": [ "workbook wrappers" ], "topics": [ "wb_set_last_modified_by" ] }, { "page": "wb_set_sheetview", "title": "Modify the default view of a worksheet", "topics": [ "wb_set_sheetview" ] }, { "page": "wb_to_df", "title": "Create a data frame from a Workbook", "topics": [ "read_xlsx", "wb_read", "wb_to_df" ] }, { "page": "wb_update_table", "title": "Update a data table position in a worksheet", "topics": [ "wb_update_table" ] }, { "page": "wb_workbook", "title": "Create a new Workbook object", "concept": [ "workbook wrappers" ], "topics": [ "wb_workbook" ] }, { "page": "wbWorkbook", "title": "Workbook class", "topics": [ "wbWorkbook" ] }, { "page": "write_xlsx", "title": "Write data to an xlsx file", "topics": [ "write_xlsx" ] }, { "page": "xl_open", "title": "Open a file or workbook object in spreadsheet software", "topics": [ "xl_open", "xl_open.default", "xl_open.wbWorkbook" ] }, { "page": "xml_add_child", "title": "append xml child to node", "topics": [ "xml_add_child" ] }, { "page": "xml_attr_mod", "title": "adds or updates attribute(s) in existing xml node", "topics": [ "xml_attr_mod" ] }, { "page": "xml_node_create", "title": "create xml_node from R objects", "topics": [ "xml_node_create" ] }, { "page": "xml_rm_child", "title": "remove xml child to node", "topics": [ "xml_rm_child" ] } ], "_pkglogo": "https://github.com/JanMarvin/openxlsx2/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/JanMarvin/openxlsx2/raw/HEAD/README.md", "_rundeps": [ "R6", "Rcpp", "stringi" ], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "14.2.0-4ubuntu2~24.04.1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "openxlsx2_charts_manual.Rmd", "filename": "openxlsx2_charts_manual.html", "title": "Add charts to a workbook", "engine": "knitr::rmarkdown", "headings": [ "", "Add plot to workbook", "Add {ggplot2} plot to workbook", "Add plot via", "Adding {encharter} plots", "Add and fill a chartsheet", "Add {mschart} plots" ], "created": "2022-12-18 07:59:19", "modified": "2026-05-25 22:13:31", "commits": 9 }, { "source": "conditional-formatting.Rmd", "filename": "conditional-formatting.html", "title": "Add conditional formatting to a workbook", "engine": "knitr::rmarkdown", "headings": [ "Rule applies to all each cell in range", "Highlight row dependent on first cell in row", "Highlight column dependent on first cell in column", "Highlight cell dependent on", "Highlight entire range cols X rows dependent only on cell A1", "Highlight cells in column 1 based on value in column 2", "Highlight duplicates using default style", "Cells containing text", "Cells not containing text", "Cells begins with text", "Cells ends with text", "Colorscale colors cells based on cell value", "Databars", "Between", "Top N", "Bottom N", "Logical Operators" ], "created": "2022-06-26 14:48:55", "modified": "2025-11-09 12:45:05", "commits": 21 }, { "source": "openxlsx2_formulas_manual.Rmd", "filename": "openxlsx2_formulas_manual.html", "title": "Add formulas to a workbook", "engine": "knitr::rmarkdown", "headings": [ "Simple formulas", "Array formulas", "Array formulas creating multiple fields", "cells metadata (cm) formulas", "dataTable formulas^[this example was originally provided by @zykezero for openxlsx.]", "dataTable formula differences" ], "created": "2023-04-26 15:32:50", "modified": "2025-01-04 08:47:57", "commits": 7 }, { "source": "openxlsx2_style_manual.Rmd", "filename": "openxlsx2_style_manual.html", "title": "Add styling to a workbook", "engine": "knitr::rmarkdown", "headings": [ "Styling showcase", "Colors, text rotation and number formats", "the quick way: using high-level functions", "the long way: using bare-metal functions", "Working with number formats", "numfmts", "numfmts2", "Modifying the column widths", "wb_set_col_widths", "Adding borders", "add borders", "styled table", "the long way: creating everything from the bone", "Use workbook colors and modify them", "Copy cell styles", "Style strings", "Create custom table styles" ], "created": "2022-04-01 15:23:38", "modified": "2026-01-31 15:21:30", "commits": 39 }, { "source": "openxlsx2.Rmd", "filename": "openxlsx2.html", "title": "openxlsx2 basic manual", "engine": "knitr::rmarkdown", "headings": [ "First steps", "Handling workbooks", "Importing as workbook", "Exporting data", "Exporting data frames or vectors", "Exporting a wbWorkbook", "dims/ wb_dims()", "A note on speed and memory usage" ], "created": "2023-07-13 16:27:07", "modified": "2026-01-31 15:21:30", "commits": 9 }, { "source": "openxlsx2_read_to_df.Rmd", "filename": "openxlsx2_read_to_df.html", "title": "openxlsx2 read to data frame", "engine": "knitr::rmarkdown", "headings": [ "Importing data", "Basic import", "col_names - first row as column name", "detect_dates - convert cells to R dates", "show_formula - show formulas instead of results", "dims - read specific dimension", "cols - read selected columns", "rows - read selected rows", "convert - convert input to guessed type", "skip_empty_rows - remove empty rows", "skip_empty_cols - remove empty columns", "row_names - keep rownames from input", "types - convert column to specific type", "start_row - where to begin", "na - define missing values" ], "created": "2024-06-01 09:23:38", "modified": "2026-01-31 15:21:30", "commits": 7 }, { "source": "Update-from-openxlsx.Rmd", "filename": "Update-from-openxlsx.html", "title": "Upgrade from openxlsx", "engine": "knitr::rmarkdown", "headings": [ "Basic read and write functions", "Read xlsx or xlsm files", "Write xlsx files", "Basic workbook functions", "Loading a workbook", "Styles", "Conditional formatting", "Data validation", "Saving", "Why openxlsx2?", "Invitation to contribute" ], "created": "2022-09-26 07:25:25", "modified": "2025-11-09 12:45:05", "commits": 16 } ], "_score": 14.934868556064572, "_indexed": true, "_nocasepkg": "openxlsx2", "_universes": [ "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.27.0.9000", "date": "2026-06-04T17:12:37.000Z", "distro": "noble", "arch": "aarch64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "ff10d0f217a4dc8836ea352d17c2786d074ff194d60a9cb01007951383744a0a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.7.0", "os": "linux", "version": "1.27.0.9000", "date": "2026-06-04T17:12:25.000Z", "distro": "noble", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "9efad51bfa3e9e7edd268b607a4de774e0552fb1f4d0384c3b69ce7c48c3bcac", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "linux", "version": "1.27.0.9000", "date": "2026-06-04T17:12:33.000Z", "distro": "noble", "arch": "aarch64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "dcfaf36dedc5e58733a8aafab9c5a918511351c9334e3e5faa6aa2901cd70068", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "linux", "version": "1.27.0.9000", "date": "2026-06-04T17:12:36.000Z", "distro": "noble", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "839ecea3bdb343b9fc1acf059bb8a3b9f96b9532dd8c42ac683827becfc51f15", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.5.3", "os": "mac", "version": "1.27.0.9000", "date": "2026-06-04T17:12:42.000Z", "arch": "aarch64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "dec5e48c73b458c084d92a0f597649216dcda13f40c2a4fa9e2c77910c5a0db5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.5.3", "os": "mac", "version": "1.27.0.9000", "date": "2026-06-04T17:13:38.000Z", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "f770864ef84a0b9d104fc23fb8120237d09570f12c459d3df70341fa65aa88b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "mac", "version": "1.27.0.9000", "date": "2026-06-04T17:13:28.000Z", "arch": "aarch64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "dcd3f8e219ded13b5a1297a84ac10cbe8bdf2716e43837a4e771d7a5ca6b2cc0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "mac", "version": "1.27.0.9000", "date": "2026-06-04T17:14:47.000Z", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "58d59ccdcee64ff2893457786e32959072c23eb097f5b1cda1dbacd452cf3fbb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "wasm", "version": "1.27.0.9000", "date": "2026-06-04T17:12:25.000Z", "arch": "emscripten", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "710c615ba7e64c2b78c9d6a3ea77ec09775f7bdd46c410ff0dcfa479f6acff75", "status": "success", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.7.0", "os": "win", "version": "1.27.0.9000", "date": "2026-06-04T17:11:31.000Z", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "6757291ed0a73ffa9a9ae7a04bbb082ba2a918208df6344e48f9e6a5e3a3d660", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.5.3", "os": "win", "version": "1.27.0.9000", "date": "2026-06-04T17:11:19.000Z", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "cf792b9a79d0f3cf918ceb0456e866a8faadb5756b1bc469cd873b52bccc191a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" }, { "r": "4.6.0", "os": "win", "version": "1.27.0.9000", "date": "2026-06-04T17:11:26.000Z", "arch": "x86_64", "commit": "02137db1c61070f2434c3c425b89acf23338c7d8", "fileid": "acd2a033b090a7c5f89fe60aab3c16587689c35c57488cb6b5aa94f642973a26", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/26967059450" } ] }