openxlsx2

Read, Write and Edit 'xlsx' Files

v1.27 · May 25, 2026 · MIT + file LICENSE

CRAN GitHub Mirror

Description

Simplifies the creation of 'xlsx' files by providing a high level interface to writing, styling and editing worksheets.

Downloads

CRAN

13.9K

Last 30 days

1010th

46K

Last 90 days

154.1K

Last year

Trend: -14.4% (30d vs prior 30d)

r2u CRAN

192

Last 30 days

739

Last 90 days

3.3K

Last year

Trend: -39.1% (30d vs prior 30d)

autoCRAN

Last 7 days

Last 30 days

All-time

autoCRAN-only: this name is served only by autoCRAN, so the count is exact.

CRAN Check Status

1 ERROR

12 OK

Show all 13 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	OK	445.9s
r-devel-linux-x86_64-debian-gcc	OK	300.3s
r-devel-linux-x86_64-fedora-clang	OK	621.1s
r-devel-linux-x86_64-fedora-gcc	OK	667.2s
r-devel-windows-x86_64	OK	536s
r-oldrel-macos-arm64	OK	120s
r-oldrel-macos-x86_64	OK	433s
r-oldrel-windows-x86_64	OK	666s
r-patched-linux-x86_64	OK	437.3s
r-release-linux-x86_64	OK
r-release-macos-arm64	OK	118s
r-release-macos-x86_64	ERROR	443s
r-release-windows-x86_64	OK	533s

Check details (1 non-OK)

ERROR r-release-macos-x86_64

re-building of vignette outputs

Error(s) in re-building vignettes:
--- re-building ‘Update-from-openxlsx.Rmd’ using rmarkdown
--- finished re-building ‘Update-from-openxlsx.Rmd’

--- re-building ‘conditional-formatting.Rmd’ using rmarkdown
--- finished re-building ‘conditional-formatting.Rmd’

--- re-building ‘openxlsx2.Rmd’ using rmarkdown
--- finished re-building ‘openxlsx2.Rmd’

--- re-building ‘openxlsx2_charts_manual.Rmd’ using rmarkdown
Failed with error:  'there is no package called 'encharter''

Quitting from openxlsx2_charts_manual.Rmd:147-152 [chartsheet]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<error/rlang_error>
Error:
! object 'chart' not found
---
Backtrace:
    ▆
 1. └─openxlsx2::wb_add_encharter(wb_add_chartsheet(wb), graph = chart)
 2.   └─wb$clone(deep = TRUE)$add_encharter(...)
 3.     └─openxlsx2:::assert_class(graph, "EncharterBase")
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error: processing vignette 'openxlsx2_charts_manual.Rmd' failed with diagnostics:
object 'chart' not found
--- failed re-building ‘openxlsx2_charts_manual.Rmd’

--- re-building ‘openxlsx2_formulas_manual.Rmd’ using rmarkdown
--- finished re-building ‘openxlsx2_formulas_manual.Rmd’

--- re-building ‘openxlsx2_read_to_df.Rmd’ using rmarkdown
--- finished re-building ‘openxlsx2_read_to_df.Rmd’

--- re-building ‘openxlsx2_style_manual.Rmd’ using rmarkdown
--- finished re-building ‘openxlsx2_style_manual.Rmd’

SUMMARY: processing the following file failed:
  ‘openxlsx2_charts_manual.Rmd’

Error: Vignette re-building failed.
Execution halted

Check History

ERROR 10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 18, 2026

ERROR r-devel-windows-x86_64

whether package can be installed

Installation failed.
See 'd:/Rcompile/CRANpkg/local/4.6/openxlsx2.Rcheck/00install.out' for details.

NOTE r-oldrel-macos-arm64

installed package size

installed size is 13.5Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.0Mb

NOTE r-oldrel-macos-x86_64

installed package size

installed size is 13.7Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.2Mb

NOTE r-oldrel-windows-x86_64

installed package size

installed size is  5.3Mb
  sub-directories of 1Mb or more:
    R      1.1Mb
    libs   1.8Mb

NOTE 10 OK · 4 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 15, 2026

NOTE r-patched-linux-x86_64

compiled code

File ‘openxlsx2/libs/openxlsx2.so’:
  Found non-API call to R: ‘R_UnboundValue’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.

NOTE r-oldrel-macos-arm64

installed package size

installed size is 13.5Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.0Mb

NOTE r-oldrel-macos-x86_64

installed package size

installed size is 13.7Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.2Mb

NOTE r-oldrel-windows-x86_64

installed package size

installed size is  5.3Mb
  sub-directories of 1Mb or more:
    R      1.1Mb
    libs   1.8Mb

ERROR 9 OK · 4 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 14, 2026

ERROR r-devel-linux-x86_64-debian-gcc

tests

Running ‘testthat.R’ [90s/129s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(openxlsx2)
  > 
  > test_check("openxlsx2")
  Saving _problems/test-read_sources-479.R
  [ FAIL 1 | WARN 2 | SKIP 85 | 
...[truncated]...
_bare(quo_get_expr(.quo), quo_get_env(.quo))
   7. └─openxlsx2::wb_load(docx_path)
   8.   └─openxlsx2:::getFile(file)
   9.     └─utils::download.file(...)
  
  [ FAIL 1 | WARN 2 | SKIP 85 | PASS 2089 ]
  Error:
  ! Test failures.
  Execution halted

NOTE r-patched-linux-x86_64

compiled code

File ‘openxlsx2/libs/openxlsx2.so’:
  Found non-API call to R: ‘R_UnboundValue’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.

NOTE r-oldrel-macos-arm64

installed package size

installed size is 13.5Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.0Mb

NOTE r-oldrel-macos-x86_64

installed package size

installed size is 13.7Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.2Mb

NOTE r-oldrel-windows-x86_64

installed package size

installed size is  5.3Mb
  sub-directories of 1Mb or more:
    R      1.1Mb
    libs   1.8Mb

NOTE 11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

NOTE r-oldrel-macos-arm64

installed package size

installed size is 13.5Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.0Mb

NOTE r-oldrel-macos-x86_64

installed package size

installed size is 13.7Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.2Mb

NOTE r-oldrel-windows-x86_64

installed package size

installed size is  5.3Mb
  sub-directories of 1Mb or more:
    R      1.1Mb
    libs   1.8Mb

ERROR 10 OK · 2 NOTE · 0 WARNING · 2 ERROR · 0 FAILURE Mar 10, 2026

ERROR r-release-macos-x86_64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/big-sur-x86_64/results/4.5/openxlsx2.Rcheck/00install.out’ for details.

NOTE r-oldrel-macos-arm64

installed package size

installed size is 13.5Mb
  sub-directories of 1Mb or more:
    R      2.0Mb
    libs   9.0Mb

ERROR r-oldrel-macos-x86_64

whether package can be installed

Installation failed.
See ‘/Volumes/Builds/packages/big-sur-x86_64/results/4.4/openxlsx2.Rcheck/00install.out’ for details.

NOTE r-oldrel-windows-x86_64

installed package size

installed size is  5.3Mb
  sub-directories of 1Mb or more:
    R      1.1Mb
    libs   1.8Mb

Reverse Dependencies (28)

depends

kstIO

imports

GTAPViz PsyToolkit REDCapCAST REDCapSync RSQLite.toolkit aftables curriculr encharter flexlsx matsindf normref qol wizaRdry

linking_to

encharter

suggests

AgePopDenom REDCapTidieR aNCA biometryassist correlation dataquieR edibble periscope2 rempsyc spicy statAfrikR surveytable taxify vectra

Dependency Network

Version History

41 tracked

updated 1.27 ← 1.26 diff May 25, 2026

updated 1.26 ← 1.25 diff Apr 17, 2026

new 1.25 Mar 10, 2026

updated 1.25 ← 1.24 diff Mar 6, 2026

updated 1.24 ← 1.23.1 diff Feb 20, 2026

updated 1.23.1 ← 1.23 diff Jan 18, 2026

updated 1.23 ← 1.22 diff Jan 15, 2026

updated 1.22 ← 1.21 diff Dec 6, 2025

updated 1.21 ← 1.20 diff Oct 30, 2025

updated 1.20 ← 1.19 diff Sep 28, 2025

updated 1.19 ← 1.18 diff Aug 24, 2025

updated 1.18 ← 1.17 diff Jul 28, 2025

updated 1.17 ← 1.16 diff Jul 3, 2025

updated 1.16 ← 1.15 diff Jun 5, 2025

updated 1.15 ← 1.14 diff Apr 24, 2025