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}} ______________________________________________ R-help@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.