Thanks Dieter,

Reading it back is fine, but still - I wish I could control this behavior.

Tal





----------------Contact
Details:-------------------------------------------------------
Contact me: Tal.Galili@gmail.com |  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com/ (English)
----------------------------------------------------------------------------------------------




On Mon, Jan 18, 2010 at 3:49 PM, Dieter Menne
<dieter.menne@menne-biomed.de>wrote:

>
>
>
> 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.
>

	[[alternative HTML version deleted]]

