[R] RODBC sqlSave colnames argument - export to Excel
Ptashny, David
David.Ptashny at us.cibc.com
Mon May 16 15:52:10 CEST 2011
I'm trying to export a data frame to Excel using the RODBC sqlSave function. I don't want the colnames, so I use the colnames=F option. Unfortunately, the column names still show up as the first row in my spreadsheet. If I set the colnames=T, then the column names show up in BOTH rows 1 and 2. Is there any to make the colnames option work properly?
By the way, the first row of my data cannot be used as valid names, so I cannot make the first row the column names, and simply shift the rest of the data up.
Thank you.
David
This message may contain confidential information. If y...{{dropped:17}}
More information about the R-help
mailing list