[R] Problema with Excel files

[David Winsemius]

On Nov 7, 2011, at 12:57 PM, Silvano wrote:

> Hi,
>
> I have a Excel file with three spreadsheets: PlanA, PlanB and PlanC.
> I'm trying to read the three spreadsheets and then adding them  
> together.
> But, when I try read the PlanA there is an error message:
>
>
> rm(list=ls())
> setwd('C:/Test/Dados/Teste')
> require(RODBC)
> Arquivo = odbcConnectExcel('T070206_1347.xls')
> (Geral = sqlFetch(Arquivo, 'PlanA'))
> (Lactacao = sqlFetch(Arquivo, 'PlanB'))
>
> Erro em as.POSIXlt.character(x, tz, ...) :
> character string is not in a standard unambiguous format
>
>
> I don't know what's happening. Can anyone help me?

It's a guess without the data, but have you got a date column in the  
spreadsheet with a non-standard format? If so, can you change it to  
YYYY-MM-DD in the format/Date/Custom (or some such) panel?


>
> Thanks a lot,
>
> --------------------------------------
> Silvano Cesar da Costa
> Departamento de Estatística
> Universidade Estadual de Londrina
> Fone: 3371-4346
>
> ______________________________________________
> 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.

David Winsemius, MD
West Hartford, CT