RODBC seems to be the most appropriate library to export multiple dataframes
into several sheets (undetermined number) of an Excel file.
Apparently the sqlSave() function usually exports data into the appropriate
Excel format, I can't understand why in this case all columns are
transformed into str
82 Biogéosciences
> 6 Boulevard Gabriel
> 21000 Dijon, FRANCE
> +33(0)3.80.39.63.06
> ivan.calandra@
> http://biogeosciences.u-bourgogne.fr/calandra
>
>
> Le 28/03/12 09:11, Juliette Fabre a écrit :
>> structure(list(Parameter_Name = c("Cd Cadmium", "Cd Cad
hing 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)
Hello,
I encountered a situation similar as the one described by Tal above :
I use the RODBC library to export multiple dataframes into different sheets
of an Excel file.
My dataframes contain Character, Date and Numeric columns.
library("RODBC")
channel <- odbcConnectExcel(xls.file = myXlsFile
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
5 matches
Mail list logo
