Skip to content

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

Dependency Network

Dependencies Reverse dependencies rJava xlsxjars DataLoader ELT ISM AgroTech BayesianFitForecast DIETCOST DataClean GGUM InflectSSP InterfaceqPCR MadanText MadanTextNetwork RSP Relectoral bnpa +23 more reverse deps xlsx

Version History

new 0.6.5 Mar 10, 2026
updated 0.6.5 ← 0.6.4.2 diff Nov 9, 2020
updated 0.6.4.2 ← 0.6.3 diff Sep 11, 2020
updated 0.6.3 ← 0.6.2 diff Feb 27, 2020
updated 0.6.2 ← 0.6.1 diff Feb 11, 2020
updated 0.6.1 ← 0.5.7 diff Jun 10, 2018
updated 0.5.7 ← 0.5.5 diff Aug 1, 2014
updated 0.5.5 ← 0.5.1 diff Dec 9, 2013
updated 0.5.1 ← 0.5.0 diff May 20, 2013
updated 0.5.0 ← 0.4.2 diff Sep 25, 2012
updated 0.4.2 ← 0.4.1 diff Feb 10, 2012
updated 0.4.1 ← 0.4.0 diff Jan 23, 2012
updated 0.4.0 ← 0.3.0 diff Jan 14, 2012
updated 0.3.0 ← 0.2.4 diff Mar 2, 2011
updated 0.2.4 ← 0.2.3 diff Oct 12, 2010
updated 0.2.3 ← 0.2.2 diff Aug 26, 2010
updated 0.2.2 ← 0.2.1 diff Jul 23, 2010
updated 0.2.1 ← 0.2.0 diff May 15, 2010
updated 0.2.0 ← 0.1.3 diff Apr 30, 2010
updated 0.1.3 ← 0.1.1 diff Mar 16, 2010