Writing a data frame in an excel file
Ok I?ve been trying to understand what is happening: the data.frame I am sending on the xls file has been constructed by the following way: I used the RODBC package to read dates and prices columns into a dataframe so the first column in excel is of type "date". In the data.frame it is not numeric but still double. So when I change the xls files I read by turning these dates datas into numbers, everything works well. So I don?t know if something has to be changed within the data.frame containing the dates or if I have to do everything in numbers and use RDCOM after to change the date column format of the excel file back into date type.
anna_l wrote:
Thanks Karl, well I am getting an error now after the following sqlSave command: sqlSave( xlsFile, datas, tablename = 'Datas_and_coefficients', rownames = FALSE ) --> [RODBC] Failed exec in Update 22018 39 [Microsoft][Driver ODBC for Excel]invalid character value for the diffusion specification (null) (null) More specifically, take a look at the 'append' and 'safer' arguments. -- Karl Ove Hufthammer
______________________________________________ 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.
----- Anna Lippel new in R so be careful I should be asking a loooooooot of questions!:teeth:
View this message in context: http://old.nabble.com/Writing-a-data-frame-in-an-excel-file-tp26378240p26416861.html Sent from the R help mailing list archive at Nabble.com.