[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