[R] Exporting a data.frame to excel using sqlSave - adds a character ' to values

jim holtman jholtman at gmail.com
Tue Mar 27 14:06:12 CEST 2012


I don't see any problem here; there is no data and no indication as to
the actual problem you are having that is causing a Find & Replace.  I
export to Excel all the time and don't have any problems.  So provide
some data and an indication of the problem.

On Tue, Mar 27, 2012 at 4:37 AM, Juliette Fabre <juliette_fabre at yahoo.fr> wrote:
> Hello Tal,
>
> I have the same problem with the ' added to all my cells when exported into
> Excel.
>
> I can drop them manually but only one by one (the Find & Replace does not
> work) ... So finally the exported Excel file can actually not be used by
> scientists to draw graphs or whatever!
>
> Did you find a solution to this problem ?
>
> Thanks,
>
> Juliette
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Exporting-a-data-frame-to-excel-using-sqlSave-adds-a-character-to-values-tp1016523p4508239.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.



More information about the R-help mailing list