Re: [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@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

______________________________________________
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.