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
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
2 matches
Mail list logo
