Message-ID: <1263822598914-1016632.post@n4.nabble.com>
Date: 2010-01-18T13:49:58Z
From: Dieter Menne
Subject: Exporting a data.frame to excel using sqlSave - adds a character ' to values
In-Reply-To: <440d7af41001180238pa520ef7h4735e2b7a7e2193a@mail.gmail.com>
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.