Tal Galili wrote:
>
> 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.
>
This might be a problem of you running in Hebrew locale; on my machine
(German) this does not occur. However, I can manually add a ' in front both
of numbers and texts to denote the column as a string; the ' only shows up
in the edit field on the top row, not in the data, indicating that this is a
"forced string" value.
Try to read back you data. I believe your strings will be ok.
Dieter
--
View this message in context:
http://n4.nabble.com/Exporting-a-data-frame-to-excel-using-sqlSave-adds-a-character-to-values-tp1016523p1016632.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
