Ptashny, David
2011-May-16 13:52 UTC
[R] RODBC sqlSave colnames argument - export to Excel
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}}
Maybe Matching Threads
- RODBC: problem saving a new table in an "Excel database"
- sqlSave, ...colnames=F, using "odbcConnectExcel" .... I still get colnames in top row of exprted sheet
- Problem in writing a R data frame to Excel format using RODBC package
- RODBC sqlSave problem with bigint numbers
- RODBC sqlSave with multiple schema in DB2