-project.org [mailto:r-help-bounces@r-
project.org] On Behalf Of Nurdiyanah Jambari
Sent: Tuesday, May 22, 2012 7:19 PM
To: Gabor Grothendieck
Cc: r-help@r-project.org
Subject: Re: [R] write.xls
Hi can you please help me with this. Ive come up with this code to read
my
file, but receive
Seems like you have a solution by now, but I didn't see:
require(xlsx)
df1 - data.frame(c1=1:2, c2=3:4, c3=5:6)
df2 - data.frame(c21=c(10.10101010101,20, 3), c22=c(50E50,60, 3) )
outFile - 'df12.xls'
wb - createWorkbook()
sh1 - createSheet(wb,'sheet1')
addDataFrame(df1,sh1)
sh2 -
Hi can you please help me with this. Ive come up with this code to read my
file, but receive an error that I ve no idea how to fix.
read-read.xlsx(D:\\FYP\\image\\Cropped
Images\\user227\\user227forger.xlsx, sheetName=Sheet1, rowIndex=1,
colIndex=varLH2y, colClasses=character, row.names=TRUE)
Hi Spencer,
it looks like you either don't have Java installed or the architectures of
R and your JVM don't match, i.e. your running 64-bit R (as noted from your
sessionInfo() output) but are using a 32-bit JVM. In any case installing
64-bit Java should resolve your issue.
Hope that helps.
On 5/19/2012 7:59 PM, Jim Holtman wrote:
I have been using XLConnect to write multisheet Excel without any problems.
Thanks very much. That looks like it will solve my problems.
Best Wishes,
Spencer
p.s. findFn{sos} identified thatt for me, but for some unknown reason,
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately,
it is often unable to do this because of
On Sun, May 20, 2012 at 8:30 AM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3 sheets
On May 19, 2012, at 8:32 PM, Spencer Graves wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it
is often unable to do this because of configuration problems that are not
On May 20, 2012, at 7:30 AM, Gabor Grothendieck wrote:
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3 sheets ('PackageSum2', 'findFn',
Hi, Gabor: Thanks. I'll try that. Spencer
On 5/20/2012 5:52 AM, Gabor Grothendieck wrote:
On Sun, May 20, 2012 at 8:30 AM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
On 5/20/2012 6:47 AM, Marc Schwartz wrote:
On May 19, 2012, at 8:32 PM, Spencer Graves wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it is often unable to do
this because
On 5/20/2012 5:52 AM, Gabor Grothendieck wrote:
On Sun, May 20, 2012 at 8:30 AM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
The writeFindFn2xls function in the sos package
Here is what it take to write out two sheets with XLConnect
# function to write out a sheet to an EXCEL file that I use
f.writeXLSheet -
function (data, sheet, fileToWrite, rownames = NULL)
{
require(XLConnect)
writeWorksheetToFile(fileToWrite, data = data, sheet = sheet,
Hi, Jim:
On 5/20/2012 4:54 PM, jim holtman wrote:
Here is what it take to write out two sheets with XLConnect
# function to write out a sheet to an EXCEL file that I use
f.writeXLSheet-
function (data, sheet, fileToWrite, rownames = NULL)
{
require(XLConnect)
On Sun, May 20, 2012 at 7:15 PM, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
On 5/20/2012 5:52 AM, Gabor Grothendieck wrote:
On Sun, May 20, 2012 at 8:30 AM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
On Sat, May 19, 2012 at 9:32 PM, Spencer Graves
On 5/20/2012 5:37 PM, Gabor Grothendieck wrote:
snip
Unfortunately this is getting increasingly complex due to the
non-standard evaluation done by dataframes2xls but if you want to do
it then this will do it. We copy dataframes2xls to the current
environment and reset write.xls's environment
Hello, All:
The writeFindFn2xls function in the sos package tries to
write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call').
Unfortunately, it is often unable to do this because of configuration
problems that are not easy to fix. I've found 3 contributed packages
that
I have been using XLConnect to write multisheet Excel without any problems.
Sent from my iPad
On May 19, 2012, at 21:32, Spencer Graves
spencer.gra...@structuremonitoring.com wrote:
Hello, All:
The writeFindFn2xls function in the sos package tries to write an
Excel file with 3
Em 20-12-2011 14:09, MacQueen, Don escreveu:
Or:
require(xlsx)
test- function(x){
+a- data.frame(A=c(1,2),B=c(10,11))
+write.xlsx(a,file=a.xlsx)
+ }
test()
list.files(patt='xlsx')
[1] a.xlsx
Thanks,
with the write.xlsx all work.
Inte
Ronaldo
--
3ª lei - Na investigação
Or:
require(xlsx)
test - function(x){
+a - data.frame(A=c(1,2),B=c(10,11))
+write.xlsx(a,file=a.xlsx)
+ }
test()
list.files(patt='xlsx')
[1] a.xlsx
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
On 12/19/11
Em 18-12-2011 18:55, Rolf Turner escreveu:
On 19/12/11 04:29, Uwe Ligges wrote:
On 18.12.2011 12:58, Ronaldo Reis Júnior wrote:
SNIP
Why the write.xls dont find the object a inside a function?
Because at least that part of the function is poorly written.
Surely this should be a fortune!
On 19.12.2011 13:30, Ronaldo Reis Júnior wrote:
Em 18-12-2011 18:55, Rolf Turner escreveu:
On 19/12/11 04:29, Uwe Ligges wrote:
On 18.12.2011 12:58, Ronaldo Reis Júnior wrote:
SNIP
Why the write.xls dont find the object a inside a function?
Because at least that part of the function
Hi,
I try to use write.xls from dataframes2xls inside a function. The
write.xls work normally in console, but inside a function it dont find
the object.
Look this example:
library(dataframes2xls)
test - function(x){
+ a - data.frame(A=c(1,2),B=c(10,11))
+ write.xls(a,file=a.xls)
+ }
On 18.12.2011 12:58, Ronaldo Reis Júnior wrote:
Hi,
I try to use write.xls from dataframes2xls inside a function. The
write.xls work normally in console, but inside a function it dont find
the object.
Look this example:
library(dataframes2xls)
test- function(x){
+ a-
On 19/12/11 04:29, Uwe Ligges wrote:
On 18.12.2011 12:58, Ronaldo Reis Júnior wrote:
SNIP
Why the write.xls dont find the object a inside a function?
Because at least that part of the function is poorly written.
Surely this should be a fortune!
cheers,
Rolf
25 matches
Mail list logo
