Thank you Gabor Grothendieck for your answer !!
i have charge the pachage but now i have this massage
read.table("c:/TOTAL.xls",h=T)
[1] ÐÏ.à..
<0 rows> (or 0-length row.names)
Warning messages:
1: In read.table("c:/TOTAL.xls", h = T) :
incomplete final line found by readTableHeader on 'c:/TOTAL.xls'
2: In if (!header) rlabp <- FALSE :
the condition has length > 1 and only the first element will be used
3: In if (header) { :
the condition has length > 1 and only the first element will be used
thank you
[[alternative HTML version deleted]]
You can not import xls file by read.table. You may save xls as csv file, and import it by read.csv. 2009/8/6 Inchallah Yarab <inchallahyarab at yahoo.fr>:> Thank you Gabor Grothendieck for your answer !! > i have charge the pachage but now i have this massage > > ?read.table("c:/TOTAL.xls",h=T) > [1] ??.?.. > <0 rows> (or 0-length row.names) > Warning messages: > 1: In read.table("c:/TOTAL.xls", h = T) : > ? incomplete final line found by readTableHeader on 'c:/TOTAL.xls' > 2: In if (!header) rlabp <- FALSE : > ? the condition has length > 1 and only the first element will be used > 3: In if (header) { : > ? the condition has length > 1 and only the first element will be used > > > thank you > > > > ? ? ? ?[[alternative HTML version deleted]] > > > ______________________________________________ > 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. > >-- HUANG Ronggui, Wincent PhD Candidate Dept of Public and Social Administration City University of Hong Kong Home page: http://asrr.r-forge.r-project.org/rghuang.html
read.table is used for text data, not Excel data. Suggest you re-read the cited link. On Wed, Aug 5, 2009 at 12:16 PM, Inchallah Yarab<inchallahyarab at yahoo.fr> wrote:> Thank you Gabor Grothendieck for your answer !! > i have charge the pachage but now i have this massage > > ?read.table("c:/TOTAL.xls",h=T) > [1] ??.?.. > <0 rows> (or 0-length row.names) > Warning messages: > 1: In read.table("c:/TOTAL.xls", h = T) : > ? incomplete final line found by readTableHeader on 'c:/TOTAL.xls' > 2: In if (!header) rlabp <- FALSE : > ? the condition has length > 1 and only the first element will be used > 3: In if (header) { : > ? the condition has length > 1 and only the first element will be used > > > thank you > > > > ? ? ? ?[[alternative HTML version deleted]] > > > ______________________________________________ > 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. > >
Alternatively, you can download and install the package "gdata". The function "read.xls" in it can read Excel sheets directly from .xls files. Basically the function is doing the csv conversion for you. See ?read.xls for details. On Wed, Aug 5, 2009 at 11:16 AM, Inchallah Yarab <inchallahyarab@yahoo.fr>wrote:> Thank you Gabor Grothendieck for your answer !! > i have charge the pachage but now i have this massage > > read.table("c:/TOTAL.xls",h=T) > [1] ÐÏ.à.. > <0 rows> (or 0-length row.names) > Warning messages: > 1: In read.table("c:/TOTAL.xls", h = T) : > incomplete final line found by readTableHeader on 'c:/TOTAL.xls' > 2: In if (!header) rlabp <- FALSE : > the condition has length > 1 and only the first element will be used > 3: In if (header) { : > the condition has length > 1 and only the first element will be used > > > thank you > > > > [[alternative HTML version deleted]] > > > ______________________________________________ > R-help@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. > >-- Jun Shen PhD PK/PD Scientist BioPharma Services Millipore Corporation 15 Research Park Dr. St Charles, MO 63304 Direct: 636-720-1589 [[alternative HTML version deleted]]