[R] importing data from Excel using RODBC
Richard.Rowe at jcu.edu.au
Sun Nov 10 01:07:55 CET 2002
At 22:44 08/11/02 -0500, Abu Hammour wrote:
>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?
>Ahmad Abu Hammour
use the mouse to copy the cells/sheet of interest ... move to a new sheet
then <right click>, choose 'paste special', activate the 'values' button,
Use this static sheet in your RODBC connection.
Excel formulae are stored elsewhere and, so far as I know, aren't visible
Department of Zoology and Tropical Ecology, James Cook University
Townsville, Queensland 4811, Australia
fax (61)7 47 25 1570
phone (61)7 47 81 4851
e-mail: Richard.Rowe at jcu.edu.au
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