[R] importing data from Excel using RODBC

[Christian Schulz]

imho you can copy your complete
spreadsheet in excel and directly
after that, paste about right-mouseclick and the
special paste option.
...maybe "=B12+B18" in the cell get than the calculated value.

(..make a security-copy of your spreadsheet before you do this!)
regards,christian


----- Original Message -----
From: "Abu Hammour" <hammour at msn.com>
To: <R-help at stat.math.ethz.ch>
Sent: Saturday, November 09, 2002 4:44 AM
Subject: [R] importing data from Excel using RODBC


> 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
>
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
_._

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._