sdllc
Restriction to 30896 values in a vector when using BERT
Hi Community,
i just found out that the biggest vector you can put from R to Excel via BERT has the length of 30896. Of course I could programme a workaround but does anybody know whether it is possible to put more values back to Excel on the regular way?
Greetings, Samy
I have no such issue. Perhaps if you provided more detail ...
In the BERT2\functions directory, I included the following function vec <- function(n) (1:n) and R.vec(1048576) returned the full sequence 1048576, when array entered with an entire column selected. I am using BERT version 2.4.4 which came bundled with R 3.5.0 (despite the outdated description at https://bert-toolkit.com/download-bert ) with Microsoft Office Home and Student 2019, Excel version 2101 (Build 13628.20274), under Windows 10 Home on a computer with an i7 processor and 16 GB RAM.
