[R] RODBC excel - need to preserve (or extract) numeric column names

From: Folkes, Michael <Michael.Folkes_at_dfo-mpo.gc.ca>
Date: Mon, 04 Apr 2011 15:05:21 -0700


I'm using RODBC to read an excel file (not mine!). But I'm struggling to find a way to preserve the column names that have a numeric value. sqlFetch() drops the value and calls them f1, f2, f3,... (ie field number). this is a different approach from read.csv, which will append "V" prior to the numeric column name. sqlFetch isn't so helpful.  

Is there a way to get the first line of data from the excel file and place it in a vector? Perhaps I can use that method and rename the dataframe column names later?  

thanks!
Michael  



Michael Folkes
Salmon Stock Assessment
Canadian Dept. of Fisheries & Oceans Pacific Biological Station
3190 Hammond Bay Rd.
Nanaimo, B.C., Canada
V9T-6N7
Ph (250) 756-7264 Fax (250) 756-7053 Michael.Folkes_at_dfo-mpo.gc.ca <mailto:Michael.Folkes_at_dfo-mpo.gc.ca>

        [[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. Received on Mon 04 Apr 2011 - 22:07:23 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 05 Apr 2011 - 09:40:27 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive