[R] Excel files first row not being read

From: Vivek Subramanian <subramanian.vivek_at_gmail.com>
Date: Thu 16 Jun 2005 - 20:21:22 EST


i am using the RODBC package to read excel files using odbcConnectExcel and susequently sqlFetch to read the contents of the file.

the file that i use is just a matrix of numbers thats all. no headers and column names. what happens is that the sqlFetch is not reading my first row of numbers.
i have tried different combinations of colnames and rownames logical values but that first row is not being read into my data frame.

i can manually set the first row to blanks in my worksheet, but since this is part of larger code where a user specifies a file to use this method is a little clumsy.

i would be grateful if you help me get around this problem.


R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Jun 16 20:28:34 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:43 EST