[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.calandra at 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))