Hi, XLConnect can very well deal with missing values. By default, only blank cells (cells not containing any values) will be treated as missing values. Cells containing the text "NA" are not automatically treated as missing values as "NA" is a valid non-missing text string. If you want to treat the text "NA" as missing value identifier, you can use the method setMissingValue.
Generally, XLConnect determines the column type based on the cell types of the containing cells (yes, Excel cells are typed!). Therefore, if there are cells with text, XLConnect will decide to read that column in as text (treating missing value identifiers accordingly, as described above). You may also use the arguments colTypes and forceConversion for further controlling how cell values should be interpreted. Please see the reference manual for more detailed information. Regards, Martin > no change when setting it to dot. I seems that XLConnect is not able to > deal with NA in Excel, means its string instead an number after importing. ______________________________________________ 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.
