[R] Writing a data frame in an excel file

[anna_l]

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.