Hi all,


I have imported xlsx file (Excel 2007) into R using the following scripts.


*library(RODBC)
*
*setwd(".......") *

*query <- odbcConnectExcel2007(xls.file = "GI 2010.xlsx", readOnly = TRUE)

dat <- sqlQuery(query, "select * from [sheet1$]", as.is = TRUE, na.strings =
"exp")*


*dat* contain one column consisting of intergers and characters
(unique value which is "exp").

However, R recognises the class of this column as 'numeric' instead of
'character' (i.e via sapply(dat, class)).

In addition, all the values of this column that are supposed to be class of
'character' are presented as 'NA'.

Interestingly, when the file is saved in csv format and imported into R,
this problem does not occur.

Any advice on this problem?

Thank you as always.


-- 
Steven

	[[alternative HTML version deleted]]

