[R] Problema with Excel files

Silvano silvano at uel.br
Mon Nov 7 18:57:51 CET 2011


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?

Thanks a lot,

--------------------------------------
Silvano Cesar da Costa
Departamento de Estatística
Universidade Estadual de Londrina
Fone: 3371-4346



More information about the R-help mailing list