i'm pulling data from our data warehouse that i need to send to another department in an excel workbook (multiple queries to multiple sheets). i've tried several packages and have not been 100% successful with any of them.
trying the xlsx package, i get the following error:
Loading required package: rJava
Error : cannot allocate vector of size 3.6 Gb
In addition: Warning messages:
1: package ‘xlsx’ was built under R version 3.2.2
2: package ‘rJava’ was built under R version 3.2.2
Error: package ‘rJava’ could not be loaded
XLConnect gives me:
Loading required package: XLConnectJars
Error : cannot allocate vector of size 3.6 Gb
In addition: Warning messages:
1: package ‘XLConnect’ was built under R version 3.2.2
2: package ‘XLConnectJars’ was built under R version 3.2.2
Error: package ‘XLConnectJars’ could not be loaded
WriteXLS gives
Can't locate Errno.pm in @INC (@INC contains: C:/Downloads/R-3.2.0/library/WriteXLS/...
i tried sqlSave in the RODBC package. that creates a file with one tab, but when i attempt to open it i get a message that the file is in a different format. when i open it, it looks ok, but i'd rather not get the message.
has anyone done this and been successful?
trying the xlsx package, i get the following error:
Loading required package: rJava
Error : cannot allocate vector of size 3.6 Gb
In addition: Warning messages:
1: package ‘xlsx’ was built under R version 3.2.2
2: package ‘rJava’ was built under R version 3.2.2
Error: package ‘rJava’ could not be loaded
XLConnect gives me:
Loading required package: XLConnectJars
Error : cannot allocate vector of size 3.6 Gb
In addition: Warning messages:
1: package ‘XLConnect’ was built under R version 3.2.2
2: package ‘XLConnectJars’ was built under R version 3.2.2
Error: package ‘XLConnectJars’ could not be loaded
WriteXLS gives
Can't locate Errno.pm in @INC (@INC contains: C:/Downloads/R-3.2.0/library/WriteXLS/...
i tried sqlSave in the RODBC package. that creates a file with one tab, but when i attempt to open it i get a message that the file is in a different format. when i open it, it looks ok, but i'd rather not get the message.
has anyone done this and been successful?
output r data frame to excel