[R] importing data from Excel using RODBC

Richard Rowe Richard.Rowe at jcu.edu.au
Sun Nov 10 01:07:55 CET 2002


At 22:44 08/11/02 -0500, Abu Hammour wrote:
>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


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, 
then paste.

Use this static sheet in your RODBC connection.

Excel formulae are stored elsewhere and, so far as I know, aren't visible 
to SQL,


Richard Rowe
Senior Lecturer
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
http://www.jcu.edu.au/school/tbiol/zoology/homepage.html

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