Displaying 1 result from an estimated 1 matches for "130502temp_number1".
2013 May 02
1
Problems with reading data by readWorksheetFromFile of XLConnect Package
Hi,
Attached are two datasheet to be read.
My raw data "130502temp.xlsx" contains numbers with ' symbols, and they
can't be read as numbers. Even if I copy and paste as numbers to form a new
file "130502temp_number1.xlsx", they could not be read smoothly.
1. How can I read the datasheet as numbers?
2. How can I treat the notation "-" as (1) "NA" or (2) zero?
Thanks,
Miao
> temp<-readWorksheetFromFile("130502temp.xlsx", sheet=1, header=FALSE,
startRow=2,...