Hello everybody, here is the code I use to read an excel file containing two rows, one of date, the other of prices: library(RODBC) z <- odbcConnectExcel("SPX_HistoricalData.xls") datas <- sqlFetch(z,"Sheet1") close(z) It works pretty well but the only thing is that the datas stop at row 7530 and I donĀ“t know why datas is a data frame that contains 7531 rows with the last two ones = NA...
----- 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/Error-on-reading-an-excel-file-tp26371750p26371750.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.