[R] importing data from Excel using RODBC

Abu Hammour hammour at msn.com
Sat Nov 9 04:44:42 CET 2002


Hi,
I used RODBC to import data from an Excel spreadsheet "*.xls", but some
columns were returned as zeros. When I looked at these columns in Excel, I
found that thery are results of formula calculations and not entry. My
question is: Is there any parameter or command I need to use in order to
overcome this problem?

Thank you
Ahmad Abu Hammour
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list