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
Problema with Excel files
2 messages · Silvano, 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