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 string ... However I found a macro to format in the appropriate way all of my cells, but it's not really nice, I would have preferred to perform this with R!
-- View this message in context: http://r.789695.n4.nabble.com/Exporting-a-data-frame-to-excel-using-sqlSave-adds-a-character-to-values-tp1016523p4514735.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.
