[R] Error on reading an excel file

[anna_l]

Thanks Charlie, well yes it included one row with two NA datas. I guess there
is an explanation, let´s wait and see if someone knows more about it :)


cls59 wrote:
> 
> 
> anna_l wrote:
>> 
>> 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...
>> 
> 
> I find this occurs sometimes when I export an Excel worksheet to CSV. 
> Excel will include one or more rows of blank cells after the data stops. 
> I would imagine the behavior you are seeing with RODBC is due to the same
> issue.
> 
> I don't know if there is anything that can be done about it other than to
> trim your dataset back to the appropriate length once it gets into R.
> 
> 
> Good luck!
> 
> -Charlie
> 


-----
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-tp26371750p26376656.html
Sent from the R help mailing list archive at Nabble.com.