[R] read.xls question

2012-07-11 Thread Tsay, Edwin
Hello, I've been using: tmp.df = read.xls(filename, stringsAsFactors = FALSE) to read in my files. Even though I get the There were 50 or more warnings thing, for the most part most of the data is read in correctly. However, there are a few select rows where there are values but they are

Re: [R] read.xls question

2009-03-16 Thread Hans-Peter Suter
2009/3/15 David Scott d.sc...@auckland.ac.nz: On Sat, 14 Mar 2009, Mathew, Abraham T wrote: [snip] Just checking on CRAN xlsReadWrite is not currently available. There is an archived version available however. Thanks for mentioning. The reason is that CRAN is strict(er) now with binary

Re: [R] read.xls question

2009-03-15 Thread David Scott
On Sat, 14 Mar 2009, Mathew, Abraham T wrote: I'm an R newbie and had a question about the read.xls function. I've heard that this is often not a reliable function to use for importing data. However, I have created numerous xls files which contain information about voter turnout and

Re: [R] read.xls question

2009-03-15 Thread Rodrigo Aluizio
To turn the function avaliable you have to load the library first, to do so: library(xlsReadWrite) Then you use your command read.xls. I'm suposing that you already had installed the xlsReadWrite package. A better alternative to this package is RODBC, which also read excel 2007 files. Take

Re: [R] read.xls question

2009-03-15 Thread Gabor Grothendieck
There are two read.xls functions: one is in gdata and one is in xlsReadWrite packages and neither is unreliable. You've simply not loaded the package. There is more info here and interfacing to Excel: http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows You should read the