R Observatory: Metrics for writexl version 2.0.1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

writexl

2.0.1Package record

Export Data Frames to Excel 'xlsx' Format

91packages dependsuggested by 68

3Mdownloads / year

83.2%test coverage

13/13flavors OK

Overview

About

Maintained by Bill DenneyCRAN page ↗GitHub ↗Website ↗Issues ↗

Zero-dependency data frame to xlsx exporter based on 'libxlsxwriter' https://libxlsxwriter.github.io. Fast and no Java or Excel required.

Changes in 2.0.1

A compiled-code cleanup requested by CRAN; nothing changes at the R level.

The bundled libxlsxwriter assigned the result of strstr()/strpbrk() on a const string to a non-const pointer in four places. With GCC 16 and glibc 2.43, where the C23 <string.h> search functions preserve const, those assignments drew "discards 'const' qualifier" warnings, and the CRAN checks on the r-devel Fedora flavors flag them as significant. The pointers were only ever read, and are now const (or gone).

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("writexl", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("ropensci/writexl")

Development version from ropensci/writexl. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-writexl

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-writexl

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-writexl

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 4.6 min · r-devel-windows-x86_64

Status changes

OK13 OK2026-08-22
WARNING12 OK, 1 WARNING2026-07-16
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 2.0.1

README· In the repository, left out of the releaseVignettesYes · 6 · evaluation depends on the environmentNEWSYes · 100% structured · mentions 2.0.1Citation fileNoWebsiteYes

Help pages: 37
Examples that run: 100%34 run in a plain check
Exported functions with examples: 92%
Documented parameters: 83%
Return-value docs: 92%
Help pages citing references: 0%

Vignettes (6)

How these are measured

Downloads

3M

CRAN downloads in the past year

Rank #204 · ~8.2K/day · ~248.4K/mo

Releases R versions

Daily download trend is not available in this view yet.

259.9K30 days

800.1K90 days

3M1 year

Compare downloads with other packages →

Also on10.9K r2u12 autocran35.8K conda_forge347 c2d4u

How downloads are counted

Repository

ropensci/writexl ↗Organization: ropensci

214Stars

19Forks

0Open issues

0Open PRs

10Releases

200Commits

8Commit identities

libxlsxwriterrxlsxexcelrstatsr-package

200 commits · Last activity 2026-08-21 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 85%
Median days to close, 50 most recently updated closed issues: 224
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-10-17 · 2112026-07-07 · 214

How these are measured

PracticesBeta

9 development-tooling and community-health practices detected across 6 families in the upstream repository

Checks run against github.com/ropensci/writexl on 2026-10-11.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Governance and community (1)

Code of conduct (inherited from ropensci)

Docs source (1)

pkgdown

Coverage (2)

Coverage reporting (Codecov).covrignore

Show all practicesHide 2 practices

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository shows signs of AI coding tools.

Claude Codefirst seen 2026-04-06
Pull request it wrote: opened by a project member
Commits: at least 29 crediting it in the message

Models named in its commits

Claude Opus 518 commits · Jul to Aug 2026
Claude Opus 4.85 commits · Jul 2026
Claude Sonnet 4.65 commits · Apr to Jul 2026
Claude Fable 51 commit · Aug 2026

Counts are commits, not lines of code. Commits by a tool's accounts count once across all of its accounts. Commits crediting it are the largest count among its credit lines, a minimum.How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

8 external dependencies (excludes base and recommended)

Installing writexl adds no packages beyond those that come with R.

Depends (0)

none

Imports (0)

none

LinkingTo (0)

none

Suggests (10)

grDevicesgraphicsspelling readxl nycflights13 testthat xml2 bit64 knitr rmarkdown

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

91direct

70indirect

Imports 91

Suggested by 68

Show the 48 most downloaded dependentsHide the 48 most downloaded dependents

Depends, Imports or LinkingTo, most downloaded first

and 43 more dependents and 68 packages that suggest it on CRAN ↗

How these are counted

Code & Tests

People & History

People (3)

Bill Denney

Author, Maintainer since 2.0.0 (2026) · added in 2.0.0

Jeroen Ooms

Author

John McNamara

Copyright holder

Author of libxlsxwriter (see AUTHORS and COPYRIGHT files for details)

Previously maintained by Jeroen Ooms (0.1 to 1.5.4).

Releases (17)

Pick two releases to compare their code metrics.

2.0.1Latest
record
2026-08-21 · current release · diff ↗
2.0.0
record
2026-08-05 · diff ↗ ·
added 46 exports
is_xl_comment, is_xl_format, is_xl_rich_string, 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_hyperlink_cell and 16 more
R
R 4.6.0 released · 2026-04-24
1.5.4
record
2025-04-15 · diff ↗
R
R 4.5.0 released · 2025-04-11
1.5.3
record
2025-04-06 · diff ↗
1.5.2
record
2025-03-17 · diff ↗
1.5.1
record
2024-10-04 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.5.0
record
2024-02-09 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.4.2
record
2023-01-06 · diff ↗
1.4.1
record
2022-10-18 · diff ↗
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
1.4.0
record
2021-04-21 · diff ↗

Show 11 earlier eventsHide 11 earlier events

1.3.1
record
2020-08-26 · diff ↗
1.3
record
2020-05-05 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.2
record
2019-11-27 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1
record
2018-12-02 · diff ↗
1.0
record
2018-05-10 · diff ↗ ·
added 2 exports
xl_formula, xl_hyperlink
R
R 3.5.0 released · 2018-04-23
0.2
record
2017-09-06 · diff ↗
0.1
record
2017-08-30
R
R 3.4.0 released · 2017-04-21

Package metadata

First published: 2017-08-30
Total releases: 17 / 9 yrs
License: BSD_2_clause + file LICENSE OSI
Copyright: Jeroen Ooms. For copyright notices of bundled third-party code (libxlsxwriter and dependencies), see COPYRIGHT.
Download size: 623 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("writexl")

Format

Denney, B., John McNamara, & Ooms, J. (2026). writexl: Export Data Frames to Excel 'xlsx' Format (Version 2.0.1) [Computer software]. https://doi.org/10.32614/CRAN.package.writexl

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for writexl version 2.0.1 [Data set]. HJJB, LLC. Data release v2026-10-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-18, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →