Re: [R] check if excel file is

2012-04-27 Thread Duncan Murdoch
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 read

Re: [R] check if excel file is

2012-04-27 Thread Ben quant
To get around the issue below, I just wrapped it with try(), but would like to know how to know the question below. Thanks! ben On Fri, Apr 27, 2012 at 10:13 AM, Ben quant wrote: > Forgot this: the solution doesn't have to come from the xlsx package... > > thanks > > ben > > > On Fri, Apr 27,

Re: [R] check if excel file is

2012-04-27 Thread Ben quant
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 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 usi

[R] check if excel file is

2012-04-27 Thread Ben quant
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