R help - Apr 2012 - check if excel file is

Hello again,

I'd like to determine if an Excel file is open or writable. Can anyone help
me with that?

I write some stats to an .xlsx Excel file using the xlsx package. I can't
write to the file unless its closed. How do I determine if the .xlsx file
is open or closed so I can write to it?

I've looked at file.info and file.access and I couldn't get those to
work
for me.

Any help would be great!
ben

	[[alternative HTML version deleted]]

Forgot this: the solution doesn't have to come from the xlsx package...

thanks

ben

On Fri, Apr 27, 2012 at 10:08 AM, Ben quant <ccquant@gmail.com> wrote:
> Hello again,
>
> I'd like to determine if an Excel file is open or writable. Can anyone
> help me with that?
>
> I write some stats to an .xlsx Excel file using the xlsx package. I
can't
> write to the file unless its closed. How do I determine if the .xlsx file
> is open or closed so I can write to it?
>
> I've looked at file.info and file.access and I couldn't get those
to work
> for me.
>
> Any help would be great!
> ben
>
>
>
	[[alternative HTML version deleted]]

On 27/04/2012 12:08 PM, Ben quant wrote:
> Hello again,
>
> I'd like to determine if an Excel file is open or writable. Can anyone
help
> me with that?
Try to write to it.  If you fail, it wasn't writable.  (You can wrap 
your attempt in try() so that it doesn't abort your program.)

If you're not ready to write to it, then open it as a connection in 
write mode.  I think that will also fail if it's not writable.  You have 
to keep it open until you're finished writing; otherwise some other 
process could grab it after your test but before you write.

Duncan Murdoch
>
> I write some stats to an .xlsx Excel file using the xlsx package. I
can't
> write to the file unless its closed. How do I determine if the .xlsx file
> is open or closed so I can write to it?
>
> I've looked at file.info and file.access and I couldn't get those
to work
> for me.
>
> Any help would be great!
> ben
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

> Hi Uwe and Indrajit,
>
> Thank you very much for the response.
>
> Since we are talking about this package, can I ask more about how to 
> use it to deal with statistical issues please?
>
> I have this data with categorical missing values in it. Now I am 
> trying to impute them using a function called "mice" from the
MICE
> package. Here is the "normal" code:
>
> > library(mice)
> > imp=mice(data, m=100) # data was imputed for 100 times which took 
> very very long time.
>
> I tried this:
>
> > library(parallel)
> > mc=4
> > run1=do.call(data,mclapply(seq_len(mc),mice(data,m=10)))
> Error in do.call(data, mclapply(seq_len(mc), mice(data, m = 10))) :
>   'what' must be a character string or a function
> In addition: Warning message:
> In mclapply(seq_len(mc), mice(data2, m = 10)) :
>   all scheduled cores encountered errors in user code
>
>
> I have a intel dual core i5 processor, and there are 4 charts in the 
> task manager on windows xp(meaning 4 cpus or 4 cores?). However, I 
> failed to figure out how to combine the mice function with the package 
> "parallel". Any suggestions how I should write the code?
>
> Thank you very much.
>
> ya
>
>
>
>
>
>
>
> On 04/29/2012 10:47 AM, Uwe Ligges wrote:
>>
>>
>> On 29.04.2012 09:28, Indr ajit Sengupta wrote:
>>> You don't need quotes in the library statement, you can just
use
>>> library(parallel).
>>
>> Yes, a special (mis-)feature of library(). Since we are trying to 
>> teach R here, we should provide clean R code. In an ideal world, we 
>> would be able to say
>>
>> pkg <- "parallel"
>> library(pkg)
>>
>> doing the same as
>>
>> library("parallel")
>>
>> which is unfortunately not possible, because library(pkg) tries a 
>> package called "pkg".
>>
>> Best,
>> Uwe Ligges
>>
>>
>>
>>>
>>> Regards,
>>> Indrajit
>>>
>>>
>>>
>>> ________________________________
>>> From: Uwe Ligges<ligges@statistik.tu-dortmund.de>
>>> To: ya<xinxi813@163.com>
>>> Cc: r-help@r-project.org
>>> Sent: Saturday, April 28, 2012 11:57 PM
>>> Subject: Re: [R] "parallel" package
>>>
>>>
>>>
>>> On 28.04.2012 20:18, ya wrote:
>>>> Hi everyone,
>>>>
>>>> Anyone knows Where I can get the "parallel" package?
The google
>>>> results
>>>> said this package has been released since R 2.14, but I could
not
>>>> find a
>>>> place to get it.
>>>>
>>>> I am doing a multiple imputation for missing values, it is
really time
>>>> consuming. I figured maybe it's more efficient by
paralleling my
>>>> CPU. I
>>>> got an intel dual core i5 processor in a Thankpad x201 laptop.
And I
>>>> have used install.packages ("parallel") in R 2.15 on
both linux and
>>>> windows xp, no package installed. So maybe this package is not
on
>>>> cran?
>>>> Any idea?
>>>
>>> It is shipped as an R base packaage. Just use
>>>
>>> library("parallel")
>>>
>>> Uwe Ligges
>>>
>>>
>>>> Thank you very much.
>>>>
>>>> ya
>>>>
>>>> ______________________________________________
>>>> R-help@r-project.org mailing list
>>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>>> PLEASE do read the posting guide
>>>> http://www.R-project.org/posting-guide.html
>>>> and provide commented, minimal, self-contained, reproducible
code.
>>>
>>> ______________________________________________
>>> R-help@r-project.org mailing list
>>> https://stat.ethz.ch/mailman/listinfo/r-help
>>> PLEASE do read the posting guide 
>>> http://www.R-project.org/posting-guide.html
>>> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]