Hi all,
I am trying to read Excel file usingthe follwoing commnad
library(RODBC)
data=odbcConnectExcel(file.choose())
sqlTables(data)
Bdat=sqlFetch(data, "test")
odbcClose(data)
head(Bdat)
1. The above script works if the Excel file is opened. If the excel file is
not opened then I get the following message "External table is not in the
expected format" and it stops.
2. Instead of "(file.choose())" I wanted to use the following command
data <- read.table('G:/test.xlsx", header=T)
But it did not work again.
Warning message:
In read.table("G:/test.xlsx", header = T) :
incomplete final line found by readTableHeader on 'G:/test.xlsx'
Did I miss something there?
Your help is highly appreciated
Val
[[alternative HTML version deleted]]
______________________________________________
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.
