Bug: Java error when trying to load a file with 1 million row

[ovancantfort]

sessionInfo() output

R version 4.3.3 (2024-02-29 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19045)

Matrix products: default

locale:
[1] LC_COLLATE=English_United Kingdom.utf8 LC_CTYPE=English_United Kingdom.utf8
[3] LC_MONETARY=English_United Kingdom.utf8 LC_NUMERIC=C
[5] LC_TIME=English_United Kingdom.utf8

time zone: Europe/Paris
tzcode source: internal

attached base packages:
[1] stats graphics grDevices utils datasets methods base

other attached packages:
[1] XLConnect_1.1.0

Additional environment information

No response

Description

In preparation of a work involving a large number of large files, I tried loading a large file (1 sheet containing 4 columns of ~ 1 million rows in an Excel table).

wb <- loadWorkbook("Datasmall.xlsx")

Loading fails with the error:
Error: RecordFormatException (Java): Tried to allocate an array of length 235,896,887, but the maximum length for this record type is 100,000,000.

Link to the dummy file: https://1drv.ms/x/s!And7fGFnBzSXt95AV7DjOpIOtoFRKw?e=ZpW0Lr

Expected behavior

Expected the loadWorkbook not to fail.

How to Reproduce

1. download the dummy file: https://1drv.ms/x/s!And7fGFnBzSXt95AV7DjOpIOtoFRKw?e=ZpW0Lr
2. try to load it :
   wb <- loadWorkbook("Datasmall.xlsx")