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

From: Enrico Schumann <enricoschumann_at_yahoo.de>
Date: Tue, 05 Apr 2011 10:53:35 +0200

At least for Excel 2003 on my computer (Win XP) I can "persuade" Excel to treat cells like text by prepending a ' to the entry (eg, '1000). Then sqlFetch/RODBC should import these cells as character. [But a number would not be valid column name for a data.frame, and you may run into other trouble. See ?make.names]

regards,
enrico

> -----Ursprüngliche Nachricht-----
> Von: r-help-bounces_at_r-project.org
> [mailto:r-help-bounces_at_r-project.org] Im Auftrag von Folkes, Michael
> Gesendet: Dienstag, 5. April 2011 00:05
> An: r-help_at_r-project.org
> Betreff: [R] RODBC excel - need to preserve (or extract)
> numeric column names
>
> 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.



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 Tue 05 Apr 2011 - 08:55:43 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 - 14:50: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