openxlsx
Read, Write and Edit xlsx Files
Description
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.
Downloads
401.5K
Last 30 days
156th
1.3M
Last 90 days
5.1M
Last year
Trend: -14.4% (30d vs prior 30d)
826
Last 30 days
2.8K
Last 90 days
11.9K
Last year
Trend: -3.6% (30d vs prior 30d)
22
Last 7 days
160
Last 30 days
7
All-time
⚠ Shared name: this package is also shipped elsewhere on openSUSE, so this count is not exclusive to autoCRAN (it is an upper bound).
6K
Last 30 days
18.9K
Last 90 days
79.9K
Last year
Trend: -0.9% (30d vs prior 30d)
13
Last 30 days
249
Last 90 days
986
Last year
Trend: -85.1% (30d vs prior 30d)
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | OK |
| r-devel-linux-x86_64-debian-gcc | OK |
| r-devel-linux-x86_64-fedora-clang | OK |
| r-devel-linux-x86_64-fedora-gcc | OK |
| r-devel-windows-x86_64 | OK |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | OK |
| r-patched-linux-x86_64 | OK |
| r-release-linux-x86_64 | OK |
| r-release-macos-arm64 | OK |
| r-release-macos-x86_64 | OK |
| r-release-windows-x86_64 | OK |
Check History
OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE May 2, 2026
NOTE 12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 22, 2026
installed package size
installed size is 7.5Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 5.1Mb
installed package size
installed size is 7.2Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 4.8Mb
ERROR 11 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 18, 2026
whether package can be installed
Installation failed. See 'd:/Rcompile/CRANpkg/local/4.6/openxlsx.Rcheck/00install.out' for details.
installed package size
installed size is 7.5Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 5.1Mb
installed package size
installed size is 7.2Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 4.8Mb
NOTE 12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
installed package size
installed size is 7.5Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 5.1Mb
installed package size
installed size is 7.2Mb
sub-directories of 1Mb or more:
extdata 1.2Mb
libs 4.8Mb
Code
Structure
Lines of code
34,889
Files
241
Compiled share
10.3%
Has compiled src
Yes
Language breakdown
API
Exported functions
87
Internal functions
130
Recent export changes
Testing & CI
Has tests
Yes
Test-to-code ratio
0.41
testthat edition
–
CI present
No
CI type
[]
PR gated
No
Docs
Return-value doc rate
29.1%
\dontrun example ratio
5.3%
Roxygen coverage
100%
Has pkgdown
No
NEWS present
Yes
Health & Security signals
Informational signals; not verdicts.
on.exit coverage
7.8%
Unsafe pattern score
0
Dep constraint coverage
0%
Secret pattern count
0
Bundled 3rd-party code
2 items
Portability & License
Min R version
3.3.0
System requirements
–
C++ standard
–
License
MIT + file LICENSE
License flags
SPDX valid, OSI approved
History
Versions
26
First release
2014-02-06
Latest release
2025-10-31
Avg cadence
134 days
Cold removal rate
100%
Dep drift
7
LOC over versions
Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.