Re: [R] Using read.xls

2011-05-26 Thread Marc Schwartz
On May 26, 2011, at 10:16 AM, Gabor Grothendieck wrote: > On Thu, May 26, 2011 at 11:09 AM, Marc Schwartz wrote: >> >> On May 26, 2011, at 5:09 AM, vioravis wrote: >> >>> I am using read.xls command from the gdata package. I get the following >>> error >>> when I try to read a work sheet from

Re: [R] Using read.xls

2011-05-26 Thread Gabor Grothendieck
On Thu, May 26, 2011 at 11:09 AM, Marc Schwartz wrote: > > On May 26, 2011, at 5:09 AM, vioravis wrote: > >> I am using read.xls command from the gdata package. I get the following error >> when I try to read a work sheet from an excel sheet. >> >> Error in xls2sep(xls, sheet, verbose = verbose, .

Re: [R] Using read.xls

2011-05-26 Thread Jonathan Daily
Another workaround if you don't need to batch the process up is to highlight the cells of the excel file in question, copy it to the clipboard, and use read.table("clipboard"). I also use this often when people pass me huge, unwieldy excel files that have multiple sets of data, summaries, formula,

Re: [R] Using read.xls

2011-05-26 Thread Marc Schwartz
On May 26, 2011, at 5:09 AM, vioravis wrote: > I am using read.xls command from the gdata package. I get the following error > when I try to read a work sheet from an excel sheet. > > Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : > Intermediate file 'C:\Tmp\RtmpYvLn

[R] Using read.xls

2011-05-26 Thread vioravis
I am using read.xls command from the gdata package. I get the following error when I try to read a work sheet from an excel sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning messa