Displaying 1 result from an estimated 1 matches for "unserdatand".
Did you mean:
underdstand
2010 Jan 18
1
Exporting a data.frame to excel using sqlSave - adds a character ' to values
Hi all,
I am using RODB to export multiple data.frames into one excel file with
multiple sheets.
One thing I can't seem to unserdatand is way the command adds the character:
'
To the beginning of each of my (non numeric) values.
Here is an example code:
library(RODBC)
library(MASS)
data(anorexia)
save2excel <- function(x, t.name) sqlSave(xlsFile, x, tablename = t.name,
rownames = FALSE)
xlsFile <- odbcConnectExcel(&qu...