Re: [R] help to ... import the data from Excel

2011-11-28 Thread Hans-Peter Suter
2011/11/15 jim holtman : > Part of my problem has to do with getting through the corporate > firewall to access the other program I have to download to use it.  I > just tried today and this is what I got: > >> xls.getshlib() > Loading required package: tools > --- xls.getshlib running... --- >  -

Re: [R] help to ... import the data from Excel

2011-11-15 Thread jim holtman
Part of my problem has to do with getting through the corporate firewall to access the other program I have to download to use it. I just tried today and this is what I got: > xls.getshlib() Loading required package: tools --- xls.getshlib running... --- - download.file from 'http://dl.dropbox.

Re: [R] help to ... import the data from Excel

2011-11-15 Thread Hans-Peter Suter
Jim, 2011/10/15 jim holtman : > You might also want to consider the XLConnect package. I have had > better luck reading/writing Excel files than with xlsReadWrite. XLConnect looks good but - as the xlsReadWrite author and planing to release a xlsx/64 bit successor - I'd be interested to learn wh

Re: [R] help to ... import the data from Excel

2011-11-08 Thread writinghealth
Sarah, it seems your current directory is not where your LTS.xls file is located. What I would is the following: always use the xlsReadWrite functions in the current directory where your excel file is located Also, just reaad the ENTIR excel sheet, rather than referencing columns. This the simplest

Re: [R] help to ... import the data from Excel

2011-10-14 Thread jim holtman
You might also want to consider the XLConnect package. I have had better luck reading/writing Excel files than with xlsReadWrite. On Fri, Oct 14, 2011 at 5:57 PM, Sarah_R_edu wrote: > > /Michael Weylandt/ > > > i used read.xls() and i install the packages : xlsReadWrite and getshlib > before usi

Re: [R] help to ... import the data from Excel

2011-10-14 Thread David Winsemius
On Oct 14, 2011, at 7:37 PM, Sarah_R_edu wrote: */David/* i used the following command : z <- read.xls(file="C:\\Users\\user\\Desktop\ \LTS.xls",colNames=FALSE,rowNames=FALSE) As I pointed out earlier this would have produced an error on my system because the arguemtnts do not exist in e

Re: [R] help to ... import the data from Excel

2011-10-14 Thread Sarah_R_edu
*/David/* i used the following command : z <- read.xls(file="C:\\Users\\user\\Desktop\\LTS.xls",colNames=FALSE,rowNames=FALSE) z <- read.table(file="C:\\Users\\user\\Desktop\\LTS.xls") and i have the packages : xlsReadWrite and gdata , my R version is 2.13.2 (2011-09-30) but all these did not

Re: [R] help to ... import the data from Excel

2011-10-14 Thread R. Michael Weylandt
This is the third time you've said you've "done getshlib", but as has been pointed out to you, the command is: xls.getshlib() not just typing getshlib and it must be entered verbatim. The latter (getshlib) doesn't exist that I'm aware of. Either way, could you do xls.getshlib() again and provide

Re: [R] help to ... import the data from Excel

2011-10-14 Thread Sarah_R_edu
/Michael Weylandt/ i used read.xls() and i install the packages : xlsReadWrite and getshlib before using this command but, did not work. anyway i waiting for you. thank you so much. (Flowers) - We are all like the bright moon, we still have our darker side -- View this message in cont

Re: [R] help to ... import the data from Excel

2011-10-14 Thread R. Michael Weylandt
(Sorry if I'm repeating things: working blind b/c of the nabble->listserv interface) Since you haven't actually told us what package you are using, I'm guessing that your problem seems to be the same as the one discussed here: http://r.789695.n4.nabble.com/ReadWrite-xls-problem-td3078348.html If

Re: [R] help to ... import the data from Excel

2011-10-14 Thread David Winsemius
On Oct 14, 2011, at 11:54 AM, Sarah_R_edu wrote: I am tried z <- read.xls(file="C:\\Users\\user\\Desktop\\LTS.xls", colNames=FALSE, rowNames=FALSE) The read.xls that I have (from pkg:gdata) does not have arguments named colNames or rowNames, and those do not look correct to be passed

Re: [R] help to ... import the data from Excel

2011-10-14 Thread Sarah_R_edu
eyildiz ... if i installed the package (getshlib) appeared to me to selecting a CRAN mirror ... Any one to be selected ? Note: i am beginner to used the languge R /thanks eyildiz ( my prayers to you)/ http://r.789695.n4.nabble.com/file/n3905447/47756_429620173219_788668219_5025394_743078_n

Re: [R] help to ... import the data from Excel

2011-10-14 Thread R. Michael Weylandt
I can't remember the specifics right now, but when you load the package used to provide read.xls() you probably get a long warning message saying you need to run xls.getshlib() before using the package. If I remember right, this solves your problem. Michael On Fri, Oct 14, 2011 at 11:54 AM, Sara

Re: [R] help to ... import the data from Excel

2011-10-14 Thread Sarah_R_edu
I am tried z <- read.xls(file="C:\\Users\\user\\Desktop\\LTS.xls", colNames=FALSE, rowNames=FALSE) and the following massege is appeared: Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for 'ReadXls' My dear ,

Re: [R] help to ... import the data from Excel

2011-10-13 Thread eyildiz
Hi, i had same problem with xlsReadWrite. this function loads a required package. try this: >xls.getshlib() -- View this message in context: http://r.789695.n4.nabble.com/help-to-import-the-data-from-Excel-tp3893382p3902973.html Sent from the R help mailing list archive at Nabble.com. _

Re: [R] help to ... import the data from Excel

2011-10-11 Thread Jean V Adams
Sarah_R_edu wrote on 10/11/2011 04:57:08 AM: > > Hi every one > > i have problem in R program to import the data from excel , > > I have done the following: > > 1. install.packages("xlsReadWrite") > > 2. library(xlsReadWrite) > > 3. z<- read.xls("ReadXls",LTS,colNames=FALSE,sheet,type,f