xlsx
Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files
v0.6.5
·
Nov 10, 2020
·
GPL-3
Description
Provide R functions to read/write/format Excel 2007 and Excel 97/2000/XP/2003 file formats.
Downloads
31.8K
Last 30 days
653rd
103.4K
Last 90 days
546.5K
Last year
Trend: -10.2% (30d vs prior 30d)
CRAN Check Status
3
ERROR
11
OK
Show all 14 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-macos-arm64 | OK |
| r-devel-windows-x86_64 | ERROR |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | ERROR |
| 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 | ERROR |
Check details (3 non-OK)
ERROR
r-devel-windows-x86_64
tests
Running 'testthat.R' [13s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.poi.util.DocumentHelper (file:/D:/RCompile/CRANpkg/lib/4.6/xlsxjars/java/poi-ooxml-3.13-20150929.jar) to method com.sun.org.apache.xerces.internal.util.SecurityManager.setEntityExpansionLimit(int)
WARNING: Please consider reporting this to the maintainers of org.apache.poi.util.DocumentHelper
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Saving _problems/test-Workbook-21.R
Workbook has no sheets!
Saving _problems/test-write.xlsx-45.R
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
══ Skipped tests (13) ══════════════════════════════════════════════════════════
• Not presently
...[truncated]...
pFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader RJavaClassLoader @dcf3e99; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
── Error ('test-write.xlsx.R:45:3'): write password protected workbook succeeds ──
<OpenXML4JRuntimeException/RuntimeException/Exception/Throwable/Object/error/condition>
Error in `.jcheck(silent = FALSE)`: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : class org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream cannot be cast to class java.util.zip.ZipFile$ZipFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader RJavaClassLoader @dcf3e99; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
ERROR
r-oldrel-windows-x86_64
tests
Running 'testthat.R' [19s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.poi.util.DocumentHelper (file:/D:/RCompile/CRANpkg/lib/4.4/xlsxjars/java/poi-ooxml-3.13-20150929.jar) to method com.sun.org.apache.xerces.internal.util.SecurityManager.setEntityExpansionLimit(int)
WARNING: Please consider reporting this to the maintainers of org.apache.poi.util.DocumentHelper
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Saving _problems/test-Workbook-21.R
Workbook has no sheets!
Saving _problems/test-write.xlsx-45.R
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
══ Skipped tests (13) ══════════════════════════════════════════════════════════
• Not presently
...[truncated]...
write.xlsx.R:45:3'): write password protected workbook succeeds ──
<OpenXML4JRuntimeException/RuntimeException/Exception/Throwable/Object/error/condition>
Error in `.jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, .jcast(if (inherits(o, "jobjRef") || inherits(o, "jarrayRef")) o else cl, "java/lang/Object"), .jnew("java/lang/String", method), j_p, j_pc, use.true.class = TRUE, evalString = simplify, evalArray = FALSE)`: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : class org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream cannot be cast to class java.util.zip.ZipFile$ZipFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader RJavaClassLoader @156643d4; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
ERROR
r-release-windows-x86_64
tests
Running 'testthat.R' [14s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.poi.util.DocumentHelper (file:/D:/RCompile/CRANpkg/lib/4.5/xlsxjars/java/poi-ooxml-3.13-20150929.jar) to method com.sun.org.apache.xerces.internal.util.SecurityManager.setEntityExpansionLimit(int)
WARNING: Please consider reporting this to the maintainers of org.apache.poi.util.DocumentHelper
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Saving _problems/test-Workbook-21.R
Workbook has no sheets!
Saving _problems/test-write.xlsx-45.R
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
══ Skipped tests (13) ══════════════════════════════════════════════════════════
• Not presently
...[truncated]...
-write.xlsx.R:45:3'): write password protected workbook succeeds ──
<OpenXML4JRuntimeException/RuntimeException/Exception/Throwable/Object/error/condition>
Error in `.jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, .jcast(if (inherits(o, "jobjRef") || inherits(o, "jarrayRef")) o else cl, "java/lang/Object"), .jnew("java/lang/String", method), j_p, j_pc, use.true.class = TRUE, evalString = simplify, evalArray = FALSE)`: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : class org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream cannot be cast to class java.util.zip.ZipFile$ZipFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader RJavaClassLoader @dcf3e99; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
Check History
ERROR 11 OK · 0 NOTE · 0 WARNING · 3 ERROR · 0 FAILURE Mar 10, 2026
ERROR
r-devel-windows-x86_64
tests
Running 'testthat.R' [14s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflecti
...[truncated]...
dInputStream is in unnamed module of loader RJavaClassLoader @dcf3e99; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
ERROR
r-release-windows-x86_64
tests
Running 'testthat.R' [15s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflecti
...[truncated]...
dInputStream is in unnamed module of loader RJavaClassLoader @dcf3e99; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
ERROR
r-oldrel-windows-x86_64
tests
Running 'testthat.R' [19s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
> library(xlsx)
>
> test_check("xlsx")
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflecti
...[truncated]...
InputStream is in unnamed module of loader RJavaClassLoader @156643d4; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')
[ FAIL 2 | WARN 0 | SKIP 13 | PASS 130 ]
Error:
! Test failures.
Execution halted
Reverse Dependencies (38)
depends
imports
Dependency Network
Version History
new
0.6.5
Mar 10, 2026