Re: [R] Importing Headers from excel files

2010-02-23 Thread Gabor Grothendieck
That should be skip = 1, not skip = 2 > DF <- read.xls(xlsxfile, skip = 1, col.names = paste(names(DF1), DF1)) > head(DF) A.1 B.1 C.1 1 2 4 8 2 3 9 27 3 4 16 64 4 5 25 125 5 6 36 216 6 7 49 343 On Tue, Feb 23, 2010 at 5:24 PM, Gabor Grothendieck wrote: > read.xls in th

Re: [R] Importing Headers from excel files

2010-02-23 Thread Gabor Grothendieck
read.xls in the development version of the gdata package can read xls and xlsx files and could interpret both header rows by reading the file twice. Using the ExampleExcelFile.xlsx file that comes with gdata assume that the first two rows are actually headers (so the row of 1s is a header in this e

[R] Importing Headers from excel files

2010-02-23 Thread Luis Felipe Parra
Hello I am trying to import an Excel file but I am loosing the headers, My headers are in the first to rows of the EXCEL file. In the following R output, the NA are supposed to be the second item in the Header. Is there any way to Import more than one row as headers?. Thank you Felipe Parra > Dat