{ "_id": "6ad205441200a49930211f0d", "Package": "openxlsx2Extras", "Title": "Extra Functions for the openxlsx2 package", "Version": "0.0.0.9000", "Authors@R": "c(\nperson(\"Eli\", \"Pousson\", , \"eli.pousson@gmail.com\", role = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0001-8280-1706\")),\nperson(\"Jan Marvin\", \"Garbuszus\", , \"jan.garbuszus@ruhr-uni-bochum.de\", role = \"ctb\")\n)", "Description": "Extends the openxlsx2 package with wrapper and helper\nfunctions designed to add new features and options when working\nwith Excel workbooks.", "License": "MIT + file LICENSE", "URL": "https://github.com/elipousson/openxlsx2Extras,\nhttps://elipousson.github.io/openxlsx2Extras/", "BugReports": "https://github.com/elipousson/openxlsx2Extras/issues", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "Config/roxygen2/version": "8.1.0", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev", "Repository": "https://elipousson.r-universe.dev", "Date/Publication": "2026-09-16 18:17:05 UTC", "RemoteUrl": "https://github.com/elipousson/openxlsx2Extras", "RemoteRef": "HEAD", "RemoteSha": "75510a4d97164005aa36ec082dd86d6178beb9ec", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-16 11:03:09 UTC", "User": "root" }, "Author": "Eli Pousson [aut, cre, cph] (ORCID:\n),\nJan Marvin Garbuszus [ctb]", "Maintainer": "Eli Pousson ", "_user": "elipousson", "_type": "src", "_file": "openxlsx2Extras_0.0.0.9000.tar.gz", "_fileid": "https://r2.ropensci.org/76a53617baa0aa31f02c2f0692c64e7090496531a9f4217958eb85d50d2b8b4a", "_filesize": 196463, "_sha256": "76a53617baa0aa31f02c2f0692c64e7090496531a9f4217958eb85d50d2b8b4a", "_expires": "2027-01-24T11:06:42.000Z", "_created": "2026-10-16T11:03:09.000Z", "_published": "2026-10-16T11:06:43.971Z", "_buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116941283586, "time": 118, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12041752276" }, { "job": 116941283611, "time": 132, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12041962018" }, { "job": 116941283520, "time": 89, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12041179400" }, { "job": 116941283577, "time": 122, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12042251782" }, { "job": 116939762340, "time": 252, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12041538129" }, { "job": 116941283582, "time": 118, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12041239034" }, { "job": 116941283662, "time": 105, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12041269474" }, { "job": 116941283695, "time": 141, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12041429098" }, { "job": 116941283773, "time": 93, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12041782869" } ], "_upstream": "https://github.com/elipousson/openxlsx2Extras", "_commit": { "id": "75510a4d97164005aa36ec082dd86d6178beb9ec", "author": "Eli Pousson ", "committer": "Eli Pousson ", "message": "Update test-coverage GH action\n", "time": 1789582625 }, "_maintainer": { "name": "Eli Pousson", "email": "eli.pousson@gmail.com", "login": "elipousson", "orcid": "0000-0001-8280-1706", "twitter": "@elipousson", "description": "I love old buildings and bicycles. Planner with the Baltimore City Department of Planning. Former preservationist @baltimoreheritage", "uuid": 931136 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "cli", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "openxlsx2", "version": ">= 1.23", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "vctrs", "role": "Imports" }, { "package": "dplyr", "role": "Suggests" }, { "package": "gt", "role": "Suggests" }, { "package": "marquee", "role": "Suggests" }, { "package": "sf", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "tidyselect", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "elipousson", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-43", "n": 14 }, { "week": "2025-45", "n": 1 }, { "week": "2025-52", "n": 1 }, { "week": "2026-37", "n": 11 }, { "week": "2026-38", "n": 1 } ], "_tags": [], "_stars": 9, "_contributors": [ { "user": "elipousson", "count": 129, "uuid": 931136 }, { "user": "janmarvin", "count": 2, "uuid": 1645626 } ], "_userbio": { "uuid": 931136, "type": "user", "name": "Eli Pousson", "followers": 138, "description": "I love old buildings and bicycles. Planner with the Baltimore City Department of Planning. Former preservationist @baltimoreheritage" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/openxlsx2Extras" }, "_devurl": "https://github.com/elipousson/openxlsx2extras", "_pkgdown": "https://elipousson.github.io/openxlsx2Extras/", "_searchresults": 4, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/openxlsx2Extras.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_cranurl": false, "_exports": [ "as_data_validation_value", "as_sheet_list", "as_sheet_names", "as_wb", "common_dxfs_styles", "csv_to_wb", "csv_to_xlsx", "fmt_lgl_cols", "fmt_marquee_txt", "map_wb", "prep_wb_data", "read_xlsx_ext", "set_excel_fmt_class", "set_sheet_list_names", "vec_fmt_lgl", "wb_add_data_ext", "wb_add_marquee_text", "wb_add_styles", "wb_cols_to_dims", "wb_cols_to_index", "wb_dims_ext", "wb_new_workbook", "wb_protect_worksheets", "wb_rename_data", "wb_rename_sheets", "wb_rename_sheets_with", "wb_save_ext", "wb_set_col_widths_ext", "wb_set_properties_ext", "wb_sheets_cols_to_dims", "wb_sheets_fmt", "wb_split", "wb_to_df_list", "write_xlsx_ext", "xlsx_to_csv" ], "_help": [ { "page": "as_data_validation_value", "title": "Prepare a character vector as a data validation string", "topics": [ "as_data_validation_value" ] }, { "page": "as_wb", "title": "Coerce a data frame or list of data frames to a workbook", "topics": [ "as_wb" ] }, { "page": "common_dxfs_styles", "title": "Common dxfs styles", "topics": [ "common_dxfs_styles" ] }, { "page": "convert_to", "title": "Convert CSV to XLSX files or XLSX to CSV", "topics": [ "convert_to", "csv_to_wb", "csv_to_xlsx", "xlsx_to_csv" ] }, { "page": "fmt_lgl_cols", "title": "Format logical vector columns to use replacement values", "topics": [ "fmt_lgl_cols" ] }, { "page": "fmt_marquee_txt", "title": "Use 'marquee::marquee_parse()' to format Markdown text", "topics": [ "fmt_marquee_txt" ] }, { "page": "prep_wb_data", "title": "Prepare data for adding to a workbook", "topics": [ "prep_wb_data" ] }, { "page": "read_xlsx_ext", "title": "Create a data frame from a Workbook (with extra features)", "topics": [ "read_xlsx_ext" ] }, { "page": "set_excel_fmt_class", "title": "Prepare a data frame with Excel style class values for formatting by openxlsx2", "topics": [ "set_excel_fmt_class" ] }, { "page": "vec_fmt_lgl", "title": "Format a logical vector to specified values", "topics": [ "vec_fmt_lgl" ] }, { "page": "wb_add_data_ext", "title": "Add data using 'openxlsx2::wb_add_data()' with extra features", "topics": [ "wb_add_data_ext" ] }, { "page": "wb_add_marquee_text", "title": "Add Markdown formatted text to a Workbook", "topics": [ "wb_add_marquee_text" ] }, { "page": "wb_add_styles", "title": "Add a named list of styles to a workbook", "topics": [ "wb_add_styles" ] }, { "page": "wb_new_workbook", "title": "Create a new workbook and add named work sheets", "topics": [ "wb_new_workbook" ] }, { "page": "wb_protect_worksheets", "title": "Protect one or more sheets in a workbook", "topics": [ "wb_protect_worksheets" ] }, { "page": "wb_rename_data", "title": "Rename column names in workbook data", "topics": [ "wb_rename_data" ] }, { "page": "wb_rename_sheets", "title": "Rename workbook sheets using a tidyselect syntax", "topics": [ "wb_rename_sheets", "wb_rename_sheets_with" ] }, { "page": "wb_save_ext", "title": "Save a workboook object to file while filling file name from assigned workbook title", "topics": [ "wb_save_ext" ] }, { "page": "wb_set_properties_ext", "title": "Set workbook properties", "topics": [ "wb_set_properties_ext" ] }, { "page": "wb_split", "title": "Use 'dplyr::group_split' to split a workbook into a list of workbooks", "topics": [ "wb_split" ] }, { "page": "wb_to_df_list", "title": "Convert a workbook to a list of data frames", "topics": [ "wb_to_df_list" ] }, { "page": "write_xlsx_ext", "title": "Write data to an xlsx file with additional features", "topics": [ "write_xlsx_ext" ] } ], "_readme": "https://github.com/elipousson/openxlsx2Extras/raw/HEAD/README.md", "_rundeps": [ "cli", "fs", "glue", "lifecycle", "magrittr", "openxlsx2", "purrr", "R6", "Rcpp", "rlang", "stringi", "vctrs" ], "_score": 3.3521825181113623, "_indexed": true, "_nocasepkg": "openxlsx2extras", "_universes": [ "elipousson" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.0.9000", "date": "2026-10-16T11:05:48.000Z", "distro": "resolute", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/0f0f39af350364c1315810aa562f7982dc6fde58028966c03aed2cdea0a5005c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.6.1", "os": "linux", "version": "0.0.0.9000", "date": "2026-10-16T11:05:59.000Z", "distro": "resolute", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/ccc734aa7e52526d78dc09dcc7880a964f8a4d04a66ab60d4e8a185da63173e1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.5.3", "os": "mac", "version": "0.0.0.9000", "date": "2026-10-16T11:05:20.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/a8f032702589ec40dc6c26587fa77bc52dbe5ea705c2d987e4c72f902ebef70d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.6.1", "os": "mac", "version": "0.0.0.9000", "date": "2026-10-16T11:05:52.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/86b6286aeda842efdd83dd844857ad5c3257bf1a76ed744f011479b42032813c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.0.9000", "date": "2026-10-16T11:06:02.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/2e7edfa63174b3d9302efefefa25cf0388e8f9597482496cf7018c2dfeb1f13b", "status": "success", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.7.0", "os": "win", "version": "0.0.0.9000", "date": "2026-10-16T11:05:16.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/926f38749b5fc35d1f43e8d111dc1d3d6c190ddf8aab3910fdd8414799b08a4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.5.3", "os": "win", "version": "0.0.0.9000", "date": "2026-10-16T11:05:52.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/e07528f9b53efccdd5c72d60570ef28e4344723f076794d0b2148db5c6e68fd8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" }, { "r": "4.6.1", "os": "win", "version": "0.0.0.9000", "date": "2026-10-16T11:05:08.000Z", "commit": "75510a4d97164005aa36ec082dd86d6178beb9ec", "fileid": "https://r2.ropensci.org/26aa9983537a5644ccec90e6219b20b36305f47478c4dac263edae162865c146", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/elipousson/actions/runs/38890815779" } ] }