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

[Ivan Calandra]

Hi,

I cannot test with RODBC because it doesn't work on my Mac, but if RODBC 
is not necessary to you, you could do the same using xlsx::write.xlsx(), 
or xlsReadWrite::wirte.xls().

For example:
library(xlsx)
write.xlsx(your_df, file="file.xlsx")

HTH,
Ivan

--
Ivan CALANDRA
Université de Bourgogne
UMR CNRS/uB 6282 Biogéosciences
6 Boulevard Gabriel
21000 Dijon, FRANCE
+33(0)3.80.39.63.06
ivan.calan...@u-bourgogne.fr
http://biogeosciences.u-bourgogne.fr/calandra


Le 28/03/12 09:11, Juliette Fabre a écrit :
structure(list(Parameter_Name = c("Cd Cadmium", "Cd Cadmium",
"Cd Cadmium", "Cd Cadmium", "Cd Cadmium", "Cd Cadmium", "Cd Cadmium",
"Cd Cadmium", "Cd Cadmium", "Cd Cadmium", "Cd Cadmium", "Cd Cadmium",
"Cd Cadmium", "Cd Cadmium", "Cd Cadmium"), Unit = c("ppb ", "ppb ",
"ppb ", "ppb ", "ppb ", "ppb ", "ppb ", "ppb ", "ppb ", "ppb ",
"ppb ", "ppb ", "ppb ", "ppb ", "ppb "), date = structure(c(12851,
12872, 12906, 12956, 12993, 13025, 13041, 13070, 13094, 13118,
13126, 13161, 13180, 13193, 13223), class = "Date"), `S5 piezometre` =
c(6.41,
7.58, NA, 34.151, 11.83, 8.17, 5.86, 130.4886, 179.5569, 180.9052,
131.6477, 81.3172, NA, 97.8383, 88.5979), `S1 Source Reigous ` = c(96.74,
104.97, 76.842, 122.85, 102.29, 100.63, 79.81, 110.2931, 88.6012,
NA, 48.4062, 80.8052, 98.7633, 93.452, 83.5394), COWG = c(86.03,
87.67, 61.503, 96.359, NA, 90.44, 61.16, 100.6402, 67.2333, NA,
39.5782, 62.3266, 56.2315, 60.829, 79.3607), GAL = c(64.07, 56.33,
43.15, 79.538, 57.77, 61.81, 33.35, 79.0689, 20.6995, NA, 30.051,
40.5197, 8.2002, 32.4497, 52.7988), Confluence = c(46.774, 40.813,
86.655, 74.219, 19.19, 9.468, 80.124, 83.3786, 36.4044, NA, 77.4461,
69.923, NA, 0.0665, 82.5202), `Amous plus 1200` = c(0.2025, 0.1851,
0.745, 0.1023, 0.0756, 0.0816, 2.1559, 0.3747, 1.1879, NA, 1.7184,
2.1946, NA, 1.7998, 1.9063)), .Names = c("Parameter_Name", "Unit",
"date", "S5 piezometre", "S1 Source Reigous ", "COWG", "GAL",
"Confluence", "Amous plus 1200"), class = "data.frame", row.names = c(NA,
15L))

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