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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
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 -- Readhttp://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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
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 Hammouruse 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._