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,form,rowNames=FALSE)
and i got on the result:
Error in read.xls("ReadXls", LTS, colNames = FALSE, rowNames = FALSE)
:
object 'LTS' not found
also i tried to done < data(LTS, package = "xlsReadWrite")
and we got on : Warning message: In data(LTS, package =
"xlsReadWrite") :
data set 'LTS' not found
How i get on LTS in the list objects?
Note: LTS is name my data in Eexcl
&
i used another way as following:
mydata<- read.table("C:\Users\user\Desktop\LTS.xls")
but its not working how can i do it?
*/My regards,,,,/ *
--
View this message in context:
http://r.789695.n4.nabble.com/help-to-import-the-data-from-Excel-tp3893382p3893382.html
Sent from the R help mailing list archive at Nabble.com.
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,form,rowNames=FALSE)> > and i got on the result: > > Error in read.xls("ReadXls", LTS, colNames = FALSE, rowNames = FALSE) : > > object 'LTS' not found > > also i tried to done < data(LTS, package = "xlsReadWrite") > > and we got on : Warning message: In data(LTS, package = "xlsReadWrite"):> data set 'LTS' not found > > How i get on LTS in the list objects? > > Note: LTS is name my data in Eexcl > > > > & > > > > i used another way as following: > > mydata<- read.table("C:\Users\user\Desktop\LTS.xls") > > but its not working how can i do it? > > */My regards,,,,/ *Try this z <- read.xls(file="C:\\Users\\user\\Desktop\\LTS.xls", colNames=FALSE, rowNames=FALSE) Jean [[alternative HTML version deleted]]
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.
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.jpg ----- We are all like the bright moon, we still have our darker side -- View this message in context: http://r.789695.n4.nabble.com/help-to-import-the-data-from-Excel-tp3893382p3905447.html Sent from the R help mailing list archive at Nabble.com.
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 eitehr read.xls or read.table ,,,, and you are asked to report verbatim all error messages.> > 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 got me any result !How do we know "this did not get you a result". Any errors? Warnings? What does these show after: ls() # z should be in there str(z) # information about z (It seems possible that you do not understand that objects might get created without any message about that fact.) -- David Winsemius, MD West Hartford, CT
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 <Sarah_R_Edu at hotmail.com> wrote:> > /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 context: http://r.789695.n4.nabble.com/help-to-import-the-data-from-Excel-tp3893382p3906354.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. >-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?