{ "_id": "6ad7306dd556c3a3418a6de9", "Package": "writexl", "Type": "Package", "Title": "Export Data Frames to Excel 'xlsx' Format", "Version": "2.0.1", "Authors@R": "c(\nperson(\"Jeroen\", \"Ooms\", role = \"aut\", comment = c(ORCID = \"0000-0002-4035-0289\")),\nperson(\"Bill\", \"Denney\", ,\"wdenney@humanpredictions.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID=\"0000-0002-5759-428X\")),\nperson(\"John McNamara\", role = \"cph\",\ncomment = \"Author of libxlsxwriter (see AUTHORS and COPYRIGHT files for details)\"))", "Description": "Zero-dependency data frame to xlsx exporter based on\n'libxlsxwriter' . Fast and no\nJava or Excel required.", "License": "BSD_2_clause + file LICENSE", "Copyright": "Jeroen Ooms. For copyright notices of bundled third-party\ncode (libxlsxwriter and dependencies), see COPYRIGHT.", "Encoding": "UTF-8", "URL": "https://ropensci.r-universe.dev/writexl\nhttps://docs.ropensci.org/writexl/", "BugReports": "https://github.com/ropensci/writexl/issues", "VignetteBuilder": "knitr", "Language": "en-US", "SystemRequirements": "zlib", "Config/testthat/edition": "3", "Config/roxygen2/version": "8.1.0", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-10-20 09:06:14 UTC", "User": "root" }, "Author": "Jeroen Ooms [aut] (ORCID:\n), Bill Denney [aut,\ncre] (ORCID: ), John\nMcNamara [cph] (Author of libxlsxwriter (see AUTHORS and\nCOPYRIGHT files for details))", "Maintainer": "Bill Denney ", "Config/pak/sysreqs": "zlib1g-dev", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-08-21 13:10:02 UTC", "RemoteUrl": "https://github.com/cran/writexl", "RemoteRef": "HEAD", "RemoteSha": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "_user": "cran", "_type": "src", "_file": "writexl_2.0.1.tar.gz", "_fileid": "https://r2.ropensci.org/04504418d8f3860eec51fcf3e99166d0eea80538b1166f0e74e2713cb94d6677", "_filesize": 889123, "_sha256": "04504418d8f3860eec51fcf3e99166d0eea80538b1166f0e74e2713cb94d6677", "_expires": "2027-01-28T09:12:11.000Z", "_created": "2026-10-20T09:06:14.000Z", "_published": "2026-10-20T09:12:13.113Z", "_upstream": "https://github.com/cran/writexl", "_status": "success", "_maintainer": { "name": "Bill Denney", "email": "wdenney@humanpredictions.com", "login": "billdenney", "description": "", "uuid": 10359931, "orcid": "0000-0002-5759-428X" }, "_jobs": [ { "job": 118546357173, "time": 131, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12253815772" }, { "job": 118546357236, "time": 170, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12253012232" }, { "job": 118546357326, "time": 131, "config": "linux-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12252458318" }, { "job": 118546357219, "time": 158, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12254005588" }, { "job": 118544675538, "time": 247, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12252233980" }, { "job": 118546356963, "time": 92, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12253111705" }, { "job": 118546357143, "time": 273, "config": "windows-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12253102266" }, { "job": 118546357298, "time": 160, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12253566115" }, { "job": 118546357312, "time": 306, "config": "windows-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12254545059" }, { "job": 118546357126, "time": 211, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12253381226" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971", "_commit": { "id": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "author": "Bill Denney ", "committer": "cran-robot ", "message": "version 2.0.1\n", "time": 1787317802 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "grDevices", "role": "Suggests" }, { "package": "graphics", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "readxl", "role": "Suggests" }, { "package": "nycflights13", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.2.0", "role": "Suggests" }, { "package": "xml2", "role": "Suggests" }, { "package": "bit64", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 270, "_updates": [ { "week": "2026-32", "n": 1 }, { "week": "2026-34", "n": 1 } ], "_tags": [ { "name": "2.0.0", "date": "2026-08-05" }, { "name": "2.0.1", "date": "2026-08-21" } ], "_stars": 0, "_contributors": [ { "user": "jeroen", "count": 15, "uuid": 216319 }, { "user": "billdenney", "count": 2, "uuid": 10359931 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 634, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 262612, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/writexl" }, "_mentions": 7, "_devurl": "https://github.com/ropensci/writexl", "_pkgdown": "https://docs.ropensci.org/writexl/", "_searchresults": 18112, "_topics": [ "zlib" ], "_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/writexl.html", "LICENSE" ], "_homeurl": "https://github.com/ropensci/writexl", "_realowner": "ropensci", "_cranurl": false, "_releases": [ { "version": "0.1", "date": "2017-08-30" }, { "version": "0.2", "date": "2017-09-06" }, { "version": "1.0", "date": "2018-05-10" }, { "version": "1.1", "date": "2018-12-02" }, { "version": "1.2", "date": "2019-11-27" }, { "version": "1.3", "date": "2020-05-05" }, { "version": "1.3.1", "date": "2020-08-26" }, { "version": "1.4.0", "date": "2021-04-20" }, { "version": "1.4.1", "date": "2022-10-18" }, { "version": "1.4.2", "date": "2023-01-07" }, { "version": "1.5.0", "date": "2024-02-09" }, { "version": "1.5.1", "date": "2024-10-04" }, { "version": "1.5.2", "date": "2025-03-17" }, { "version": "1.5.3", "date": "2025-04-06" }, { "version": "1.5.4", "date": "2025-04-15" }, { "version": "2.0.0", "date": "2026-08-05" }, { "version": "2.0.1", "date": "2026-08-21" } ], "_exports": [ "is_xl_comment", "is_xl_format", "is_xl_rich_string", "lxw_version", "write_xlsx", "xl_align", "xl_border", "xl_cell_general", "xl_chart", "xl_chart_axis", "xl_chart_error_bars", "xl_chart_label", "xl_chart_labels", "xl_chart_legend", "xl_chart_marker", "xl_chart_series", "xl_chart_table", "xl_chart_trendline", "xl_chartsheet", "xl_col_spec", "xl_color", "xl_comment", "xl_cond_bar", "xl_cond_cell", "xl_cond_icons", "xl_cond_scale", "xl_fill", "xl_filter", "xl_filter_keep", "xl_font", "xl_format", "xl_formula", "xl_hyperlink", "xl_hyperlink_cell", "xl_image", "xl_merge", "xl_num_format", "xl_outline", "xl_page_setup", "xl_properties", "xl_protection", "xl_rich_run", "xl_rich_string", "xl_row_spec", "xl_sheet", "xl_sheet_view", "xl_table", "xl_table_column", "xl_validation", "xl_workbook" ], "_help": [ { "page": "is_xl_comment", "title": "Test whether an object is an `xl_comment`", "concept": [ "cell content" ], "topics": [ "is_xl_comment" ] }, { "page": "is_xl_format", "title": "Test whether an object is an `xl_format`", "concept": [ "cell formatting" ], "topics": [ "is_xl_format" ] }, { "page": "writexl", "title": "Version", "topics": [ "lxw_version" ] }, { "page": "write_xlsx", "title": "Export to xlsx", "concept": [ "workbook settings" ], "topics": [ "writexl", "write_xlsx" ] }, { "page": "xl_cell_general", "title": "General cell objects for Excel writing", "concept": [ "cell content" ], "topics": [ "as.character.xl_cell_general", "xl_cell_general" ] }, { "page": "xl_chart", "title": "Add a chart to a worksheet", "concept": [ "images and charts" ], "topics": [ "xl_chart" ] }, { "page": "xl_chart_axis", "title": "An axis of a chart", "concept": [ "images and charts" ], "topics": [ "xl_chart_axis" ] }, { "page": "xl_chart_error_bars", "title": "Error bars on a chart series", "concept": [ "images and charts" ], "topics": [ "xl_chart_error_bars" ] }, { "page": "xl_chart_labels", "title": "Data labels on a chart series", "concept": [ "images and charts" ], "topics": [ "xl_chart_label", "xl_chart_labels" ] }, { "page": "xl_chart_legend", "title": "A chart's legend", "concept": [ "images and charts" ], "topics": [ "xl_chart_legend" ] }, { "page": "xl_chart_marker", "title": "A marker on a chart series", "concept": [ "images and charts" ], "topics": [ "xl_chart_marker" ] }, { "page": "xl_chart_series", "title": "A data series within a chart", "concept": [ "images and charts" ], "topics": [ "xl_chart_series" ] }, { "page": "xl_chart_table", "title": "The table of values under a chart", "concept": [ "images and charts" ], "topics": [ "xl_chart_table" ] }, { "page": "xl_chart_trendline", "title": "A trendline on a chart series", "concept": [ "images and charts" ], "topics": [ "xl_chart_trendline" ] }, { "page": "xl_chartsheet", "title": "A sheet holding a single chart", "concept": [ "images and charts" ], "topics": [ "xl_chartsheet" ] }, { "page": "xl_color", "title": "Normalize a color to a libxlsxwriter RGB integer", "concept": [ "cell formatting" ], "topics": [ "xl_color" ] }, { "page": "xl_colrow_spec", "title": "Column and row specifications for a worksheet", "concept": [ "worksheet layout" ], "topics": [ "xl_colrow_spec", "xl_col_spec", "xl_row_spec" ] }, { "page": "xl_comment", "title": "Create a cell comment", "concept": [ "cell content" ], "topics": [ "xl_comment" ] }, { "page": "xl_conditional", "title": "Format cells according to their contents", "concept": [ "worksheet features" ], "topics": [ "xl_conditional", "xl_cond_bar", "xl_cond_cell", "xl_cond_icons", "xl_cond_scale" ] }, { "page": "xl_filter", "title": "Filter an autofilter column, hiding the rows that do not match", "concept": [ "worksheet features" ], "topics": [ "xl_filter" ] }, { "page": "xl_filter_keep", "title": "Which rows an Excel autofilter would leave visible", "concept": [ "worksheet features" ], "topics": [ "xl_filter_keep" ] }, { "page": "xl_format", "title": "Combine cell-formatting groups into a single format", "concept": [ "cell formatting" ], "topics": [ "+.xl_format", "xl_format" ] }, { "page": "xl_format_groups", "title": "Cell formatting groups", "concept": [ "cell formatting" ], "topics": [ "xl_align", "xl_border", "xl_fill", "xl_font", "xl_format_groups", "xl_num_format", "xl_protection" ] }, { "page": "xl_formula", "title": "Excel Types", "concept": [ "cell content" ], "topics": [ "xl_formula", "xl_hyperlink", "xl_hyperlink_cell" ] }, { "page": "xl_image", "title": "Insert an image into a worksheet", "concept": [ "images and charts" ], "topics": [ "xl_image" ] }, { "page": "xl_merge", "title": "Merge a range of cells", "concept": [ "worksheet features" ], "topics": [ "xl_merge" ] }, { "page": "xl_outline", "title": "Control how outline (grouping) symbols are drawn", "concept": [ "worksheet layout" ], "topics": [ "xl_outline" ] }, { "page": "xl_page_setup", "title": "How a worksheet prints", "concept": [ "worksheet layout" ], "topics": [ "xl_page_setup" ] }, { "page": "xl_properties", "title": "Workbook properties, defaults, and metadata", "concept": [ "workbook settings" ], "topics": [ "xl_properties" ] }, { "page": "xl_rich_run", "title": "One run of a rich (multi-format) string", "concept": [ "cell content" ], "topics": [ "xl_rich_run" ] }, { "page": "xl_rich_string", "title": "A cell whose text has several formats", "concept": [ "cell content" ], "topics": [ "as.character.xl_rich_string", "is_xl_rich_string", "xl_rich_string" ] }, { "page": "xl_sheet", "title": "A worksheet with formatting and layout options", "concept": [ "worksheet layout" ], "topics": [ "xl_sheet" ] }, { "page": "xl_sheet_view", "title": "How a worksheet appears when it opens", "concept": [ "worksheet layout" ], "topics": [ "xl_sheet_view" ] }, { "page": "xl_table", "title": "Add a worksheet table", "concept": [ "worksheet features" ], "topics": [ "xl_table" ] }, { "page": "xl_table_column", "title": "Describe a column of a worksheet table", "concept": [ "worksheet features" ], "topics": [ "xl_table_column" ] }, { "page": "xl_validation", "title": "Restrict what can be typed into a range", "concept": [ "worksheet features" ], "topics": [ "xl_validation" ] }, { "page": "xl_workbook", "title": "A workbook: sheets plus workbook-level properties", "concept": [ "workbook settings" ], "topics": [ "xl_workbook" ] } ], "_rundeps": [], "_sysdeps": [ { "shlib": "libz", "package": "zlib1g", "headers": "zlib1g-dev", "source": "zlib", "version": "1:1.3.dfsg+really1.3.1-1ubuntu3.1", "name": "zlib", "homepage": "http://zlib.net/", "description": "compression library - runtime" } ], "_vignettes": [ { "source": "d-charts-images.Rmd", "filename": "d-charts-images.html", "title": "Charts and images", "engine": "knitr::rmarkdown", "headings": [ "A chart", "Naming a range", "Styling", "Axes", "The parts of a series", "The chart as a whole", "A chart on a sheet of its own", "Images" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 }, { "source": "f-everything-at-once.Rmd", "filename": "f-everything-at-once.html", "title": "Everything at once", "engine": "knitr::rmarkdown", "headings": [ "Formatting --- vignette", "Cell content --- vignette", "Worksheet features --- vignette", "Printing and the sheet view --- vignette", "Charts --- vignette", "An image --- vignette", "The workbook --- vignette", "The second workbook: an embedded image", "What was written" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 }, { "source": "b-formatting.Rmd", "filename": "b-formatting.html", "title": "Formatting cells", "engine": "knitr::rmarkdown", "headings": [ "Building a format", "Applying it to cells", "Applying it to columns and rows", "Where a format comes from", "Conditional formatting", "Scales, bars and icons", "What is elsewhere" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 }, { "source": "e-formulas-and-more.Rmd", "filename": "e-formulas-and-more.html", "title": "Formulas, tables and the rest", "engine": "knitr::rmarkdown", "headings": [ "What a cell can hold", "Formulas", "Hyperlinks", "Comments", "Rich strings", "Mixed columns", "Data validation", "Autofilters", "Worksheet tables", "Merged cells", "Elsewhere" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 }, { "source": "a-getting-started.Rmd", "filename": "a-getting-started.html", "title": "Getting started with writexl", "engine": "knitr::rmarkdown", "headings": [ "One data frame", "Several sheets", "What is written", "Everything else", "Reading it back" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 }, { "source": "c-worksheets-workbooks.Rmd", "filename": "c-worksheets-workbooks.html", "title": "Worksheets and workbooks", "engine": "knitr::rmarkdown", "headings": [ "The sheet", "Grouping and outlines", "Protection", "Silencing Excel's error indicators", "The tab strip and the opening view", "Printing", "The workbook", "Memory", "Elsewhere" ], "created": "2026-08-05 14:50:02", "modified": "2026-08-05 14:50:02", "commits": 1 } ], "_score": 12.510045281650422, "_indexed": false, "_nocasepkg": "writexl", "_universes": [ "cran" ], "_indexurl": "https://ropensci.r-universe.dev/writexl", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2.0.1", "date": "2026-10-20T09:08:05.000Z", "distro": "resolute", "arch": "aarch64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/83e9364677ad754faf41473f940331d891f691528055cb06f88db538557ef8c3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.7.0", "os": "linux", "version": "2.0.1", "date": "2026-10-20T09:08:24.000Z", "distro": "resolute", "arch": "x86_64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/951e7950e3c8077a9b427aec55e0c24e0351cb637946a9b1555c7dd49ab064bd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.6.1", "os": "linux", "version": "2.0.1", "date": "2026-10-20T09:08:07.000Z", "distro": "resolute", "arch": "aarch64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/22dbe1938ffc656762366ad77d94710132400bc55f4a65fbc17eb99f3d022996", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.6.1", "os": "linux", "version": "2.0.1", "date": "2026-10-20T09:08:20.000Z", "distro": "resolute", "arch": "x86_64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/ae91e8f6e05e2b1fd45a0de8e6a12fd2d5ea19dcb817677d619771480c7eada4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.6.0", "os": "wasm", "version": "2.0.1", "date": "2026-10-20T09:08:05.000Z", "arch": "emscripten", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/b58a6bcc7ddeb48e4df4b33cc0a792846f1338279458a8b385af549f6d0a3aeb", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.7.0", "os": "win", "version": "2.0.1", "date": "2026-10-20T09:09:27.000Z", "arch": "aarch64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/39be2c70b04583abf27af0d0a83108620ae8b264f70731fb08e1972c2b4f71ee", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.7.0", "os": "win", "version": "2.0.1", "date": "2026-10-20T09:07:29.000Z", "arch": "x86_64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/675c3bda67c0ac3f6141bb916a7becccc294fc131a7b382ed79d808bdfa3721e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.6.1", "os": "win", "version": "2.0.1", "date": "2026-10-20T09:10:04.000Z", "arch": "aarch64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/2a6046cc662f50d21e1eda3f671f280e2f110d53b95ca82a098a32e92e0c2475", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" }, { "r": "4.6.1", "os": "win", "version": "2.0.1", "date": "2026-10-20T09:07:44.000Z", "arch": "x86_64", "commit": "80b7409ee4cb9a08c75865f89a5ceb31a5b699eb", "fileid": "https://r2.ropensci.org/ad80c99957b69d13088ecf1d5de27cdb539afd4feeab2eeea06c39a4dbdbb3a3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/39397729971" } ] }