Error thrown by R function write.xlsx {xlsx}

[giannilmbd]

Hi,
There seem to be a problem trying to write an xlsx file using "write.xlsx".

Here is what happens
`
using RCall

R"library('xlsx')"
RCall.jl: Loading required package: rJava

R"write.xlsx(1,'test.xlsx')"
RCall.jl: Error in write.xlsx(1, "test.xlsx") : `

Same error if I try to write a dataframe object (instead of a simple number)

Also, it doesn't really seem that the library has been loaded
R"?write.xlsx" RCall.RObject{RCall.StrSxp} No documentation for ‘write.xlsx’ in specified packages and libraries: you could try ‘??write.xlsx’

Best,
Gianni

[randy3k]

Did you install xlsx properly? Are there error messages when the package xlsx is loaded?
For some unknown reasons, I got segfault when it was loaded

R> library('xlsx')

signal (11): Segmentation fault: 11
while loading no file, in expression starting on line 0
unknown function (ip: 0x128a5b2b3)
Allocations: 7707900 (Pool: 7706482; Big: 1418); GC: 9
Loading required package: rJava
Loading required package: xlsxjars

[giannilmbd]

No error messages by loading. Within R it works properly.

library('xlsx')

Loading required package: rJava Loading required package: xlsxjars

…

On Mon, Aug 21, 2017 at 10:22 PM, Randy Lai ***@***.***> wrote: Did you install xlsx properly? Are there error messages when the package xlsx is loaded? For some unknown reasons, I got segfault when it was loaded R> library('xlsx') signal (11): Segmentation fault: 11 while loading no file, in expression starting on line 0 unknown function (ip: 0x128a5b2b3) Allocations: 7707900 (Pool: 7706482; Big: 1418); GC: 9 Loading required package: rJava Loading required package: xlsxjars — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#200 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Addw7_TFzbKcfgCXbQ42M8AKaKfI9lFhks5saecYgaJpZM4O4f8W> .

[randy3k]

May be instead of xlsx, you should try openxlsx. It is much lightweight and it runs faster.

[randy3k]

I suspect that xlsx has some PATH issues when it is loaded by Julia. It may be hard to figure out what the exact cause is.

[giannilmbd]

Thanks. Sounds good. I'll try that! Cheers

…

On Mon, 21 Aug 2017 at 23:24, Randy Lai ***@***.***> wrote: I suspect that xlsx has some PATH issue when it is loaded by Julia. It may be hard to figure out what the exact cause is. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#200 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Addw7wyDHm76D35Be2GTdfRrKMEu4RXDks5safWbgaJpZM4O4f8W> .