XLConnect error "cat not found"

[satishpandey]

Hi All,

Despite having XLConnect and Java installed and also having the updated R version, I am getting the below issue-Please help

Error: package or namespace load failed for ‘XLConnect’:
.onLoad failed in loadNamespace() for 'XLConnect', details:
call: system2("cat", c("/etc/*-release"), stdout = TRUE, stderr = TRUE)
error: '"cat"' not found
In addition: Warning messages:
1: In memory.limit(1.759e+13) : cannot decrease memory limit: ignored
2: package ‘lubridate’ was built under R version 3.6.3
3: package ‘readxl’ was built under R version 3.6.3
4: package ‘XLConnect’ was built under R version 3.6.3

[gsapijaszko]

@satishpandey

error: '"cat"' not found

Seems you don't have cat installed. Under linux you can check:

sapi@t5810:~$ whereis cat
cat: /usr/bin/cat /usr/share/man/man1/cat.1.gz

under windows, rtools should help: Using Rtools4 on Windows

Regards,
Grzegorz

[satishpandey]

How we can install 'cat' in windows? Please help. This is long time pending issue I am looking for. I have also uninstalled and installed the R. The same version and script works onto another colleague's PC.

[wasd]

Apologies if you have but you didn't clarify: did you install Rtools as recommended?

@gsapijaszko

Using Rtools4 on Windows

This is separate from R itself and allows R to do some things on Windows that it can do natively on other operating systems.