Hi Gabor, > Please start at a fresh version of R. Copy and paste your session > from the R console rather than relating what happened. Also, what > version of gdata are you using? Older versions did not have > installXLSXsupport. Show:
> packageDescription("gdata")$Version > win.version() > R.version.string > packageDescription("gdata")$Version [1] "2.8.1" > win.version() [1] "Windows 7 x64 (build 7600)" > R.version.string [1] "R version 2.12.0 (2010-10-15)" Both 32 and 64 bits >> 2) >> library(gdata) >> data() >> gdata is added to the list of master dataset package > This is not clear. Please provide exact and complete output. File gdata_output.txt is attached to this email. Following lines are added to the bottom of the file:- Data sets in package ‘gdata’: MedUnits Table of conversions between Intertional Standard (SI) and US - end - B.R. Stephen L ________________________________ From: Gabor Grothendieck <ggrothendi...@gmail.com> To: Stephen Liu <sati...@yahoo.com> Cc: r-help <r-help@r-project.org> Sent: Mon, November 29, 2010 11:31:18 PM Subject: Re: [R] Where is gdata? On Mon, Nov 29, 2010 at 10:18 AM, Stephen Liu <sati...@yahoo.com> wrote: > Hi Gabor, > > - snip - > .. >> > The following object(s) are masked from 'package:utils': >> >> >: object.size >>This is just a message that it can't find perl. If you don't need to >> use read.xls then you don't need perl so you can ignore the message. >> If you do need to use read.xls then install perl and once you have >> done that then run installXLSXsupport(). > > After having installed Strawberry perl the warning disappears. > > library(gdata) > ?read.xls > works starting "Read Excel files" > > I haven't run installXLSXsupport() afterwards. > > Just did it without success. > >> installXLSXsupport() > Error: could not find function "installXLSXsupport" > > Couldn't proceed further. Please start at a fresh version of R. Copy and paste your session from the R console rather than relating what happened. Also, what version of gdata are you using? Older versions did not have installXLSXsupport. Show: packageDescription("gdata")$Version win.version() R.version.string > > > I can't resolve follows; > > 1) > library(AER) > data() > starts the datasets of AER > > 2) > library(gdata) > data() > gdata is added to the list of master dataset package This is not clear. Please provide exact and complete output. > > > B.R. > Stephen L > > > ________________________________ > From: Gabor Grothendieck <ggrothendi...@gmail.com> > To: Stephen Liu <sati...@yahoo.com> > Cc: Liviu Andronic <landronim...@gmail.com>; r-help <r-help@r-project.org> > Sent: Mon, November 29, 2010 8:39:55 PM > Subject: Re: [R] Where is gdata? > > On Mon, Nov 29, 2010 at 3:44 AM, Stephen Liu <sati...@yahoo.com> wrote: >> Hi Liviu, >> >>> Not if you >>> library(gdata) >>> first. Then >>> ?read.xls >> >>> should work. >> >> Yes, I did. >> >> >> I found something strange here which I can't explain. >> >> Win 7 64bit >> R 32/64 bit >> >> Just rebooted Win 7 and R >> >>> library(gdata) >> gdata: Unable to locate valid perl interpreter >> gdata: >> gdata: read.xls() will be unable to read Excel XLS and XLSX files >> gdata: unless the 'perl=' argument is used to specify the location of a >> gdata: valid perl intrpreter. >> gdata: >> gdata: (To avoid display of this message in the future, please ensure >> gdata: perl is installed and available on the executable search path.) >> gdata: Unable to load perl libaries needed by read.xls() >> gdata: to support 'XLX' (Excel 97-2004) files. >> >> gdata: Unable to load perl libaries needed by read.xls() >> gdata: to support 'XLSX' (Excel 2007+) files. >> >> gdata: Run the function 'installXLSXsupport()' >> gdata: to automatically download and install the perl >> gdata: libaries needed to support Excel XLS and XLSX formats. >> >> Attaching package: 'gdata' >> >> The following object(s) are masked from 'package:utils': >> >> object.size > > This is just a message that it can't find perl. If you don't need to > use read.xls then you don't need perl so you can ignore the message. > If you do need to use read.xls then install perl and once you have > done that then run installXLSXsupport(). > >> >> >> It complains. >> >> >>> ?read.xls >> starting httpd help server ... done >> >> "Read Excel files" >> >> >> Both 32 and 64 bit R worked. >> >> >> If there is NO complaint on running; >> >>> library(gdata) >> >> Then >>> ?read.xls >> >> can't work. > > Can you clarify when ?read.xls works for you and when it does not? > >> >> >> Perl seems has been installed. But I can't recall, when and how; >> >> C:\>dir C:\Users\satimiswin764\Documents\R\win-library\2.12\gdata\ >> ..... >> 11/22/2010 10:44 AM <DIR> perl >> 11/22/2010 10:44 AM <DIR> R >> 11/22/2010 10:44 AM <DIR> unitTests >> 11/22/2010 10:44 AM <DIR> xls > > > The gdata\perl folder contains perl libraries that come with gdata. > Perl itself is not distributed with gdata and you don't need perl at > all to use gdata except for read.xls and related functions. > > My understanding is that this question has nothing to do with perl nor > with read.xls and that the problem is that you seem to be able to run > this: > > library(gdata) > ?read.xls > > and sometimes it works and at other times it does not work. Is that > right? Does it occur with any other package? How about removing > gdata and reinstalling it? > > remove.packages("gdata") > ... exit R and check if gdata has been removed ... > ... restart R ... > install.packages("gdata") > > > -- > Statistics & Software Consulting > GKX Group, GKX Associates Inc. > tel: 1-877-GKX-GROUP > email: ggrothendieck at gmail.com > > -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com
Data sets in package âdatasetsâ: AirPassengers Monthly Airline Passenger Numbers 1949-1960 BJsales Sales Data with Leading Indicator BJsales.lead (BJsales) Sales Data with Leading Indicator BOD Biochemical Oxygen Demand CO2 Carbon Dioxide Uptake in Grass Plants ChickWeight Weight versus age of chicks on different diets DNase Elisa assay of DNase EuStockMarkets Daily Closing Prices of Major European Stock Indices, 1991-1998 Formaldehyde Determination of Formaldehyde HairEyeColor Hair and Eye Color of Statistics Students Harman23.cor Harman Example 2.3 Harman74.cor Harman Example 7.4 Indometh Pharmacokinetics of Indomethicin InsectSprays Effectiveness of Insect Sprays JohnsonJohnson Quarterly Earnings per Johnson & Johnson Share LakeHuron Level of Lake Huron 1875-1972 LifeCycleSavings Intercountry Life-Cycle Savings Data Loblolly Growth of Loblolly pine trees Nile Flow of the River Nile Orange Growth of Orange Trees OrchardSprays Potency of Orchard Sprays PlantGrowth Results from an Experiment on Plant Growth Puromycin Reaction Velocity of an Enzymatic Reaction Seatbelts Road Casualties in Great Britain 1969-84 Theoph Pharmacokinetics of Theophylline Titanic Survival of passengers on the Titanic ToothGrowth The Effect of Vitamin C on Tooth Growth in Guinea Pigs UCBAdmissions Student Admissions at UC Berkeley UKDriverDeaths Road Casualties in Great Britain 1969-84 UKgas UK Quarterly Gas Consumption USAccDeaths Accidental Deaths in the US 1973-1978 USArrests Violent Crime Rates by US State USJudgeRatings Lawyers' Ratings of State Judges in the US Superior Court USPersonalExpenditure Personal Expenditure Data VADeaths Death Rates in Virginia (1940) WWWusage Internet Usage per Minute WorldPhones The World's Telephones ability.cov Ability and Intelligence Tests airmiles Passenger Miles on Commercial US Airlines, 1937-1960 airquality New York Air Quality Measurements anscombe Anscombe's Quartet of "Identical" Simple Linear Regressions attenu The Joyner-Boore Attenuation Data attitude The Chatterjee-Price Attitude Data austres Quarterly Time Series of the Number of Australian Residents beaver1 (beavers) Body Temperature Series of Two Beavers beaver2 (beavers) Body Temperature Series of Two Beavers cars Speed and Stopping Distances of Cars chickwts Chicken Weights by Feed Type co2 Mauna Loa Atmospheric CO2 Concentration crimtab Student's 3000 Criminals Data discoveries Yearly Numbers of Important Discoveries esoph Smoking, Alcohol and (O)esophageal Cancer euro Conversion Rates of Euro Currencies euro.cross (euro) Conversion Rates of Euro Currencies eurodist Distances Between European Cities faithful Old Faithful Geyser Data fdeaths (UKLungDeaths) Monthly Deaths from Lung Diseases in the UK freeny Freeny's Revenue Data freeny.x (freeny) Freeny's Revenue Data freeny.y (freeny) Freeny's Revenue Data infert Infertility after Spontaneous and Induced Abortion iris Edgar Anderson's Iris Data iris3 Edgar Anderson's Iris Data islands Areas of the World's Major Landmasses ldeaths (UKLungDeaths) Monthly Deaths from Lung Diseases in the UK lh Luteinizing Hormone in Blood Samples longley Longley's Economic Regression Data lynx Annual Canadian Lynx trappings 1821-1934 mdeaths (UKLungDeaths) Monthly Deaths from Lung Diseases in the UK morley Michaelson-Morley Speed of Light Data mtcars Motor Trend Car Road Tests nhtemp Average Yearly Temperatures in New Haven nottem Average Monthly Temperatures at Nottingham, 1920-1939 occupationalStatus Occupational Status of Fathers and their Sons precip Annual Precipitation in US Cities presidents Quarterly Approval Ratings of US Presidents pressure Vapor Pressure of Mercury as a Function of Temperature quakes Locations of Earthquakes off Fiji randu Random Numbers from Congruential Generator RANDU rivers Lengths of Major North American Rivers rock Measurements on Petroleum Rock Samples sleep Student's Sleep Data stack.loss (stackloss) Brownlee's Stack Loss Plant Data stack.x (stackloss) Brownlee's Stack Loss Plant Data stackloss Brownlee's Stack Loss Plant Data state.abb (state) US State Facts and Figures state.area (state) US State Facts and Figures state.center (state) US State Facts and Figures state.division (state) US State Facts and Figures state.name (state) US State Facts and Figures state.region (state) US State Facts and Figures state.x77 (state) US State Facts and Figures sunspot.month Monthly Sunspot Data, 1749-1997 sunspot.year Yearly Sunspot Data, 1700-1988 sunspots Monthly Sunspot Numbers, 1749-1983 swiss Swiss Fertility and Socioeconomic Indicators (1888) Data treering Yearly Treering Data, -6000-1979 trees Girth, Height and Volume for Black Cherry Trees uspop Populations Recorded by the US Census volcano Topographic Information on Auckland's Maunga Whau Volcano warpbreaks The Number of Breaks in Yarn during Weaving women Average Heights and Weights for American Women Data sets in package âgdataâ: MedUnits Table of conversions between Intertional Standard (SI) and US Use âdata(package = .packages(all.available = TRUE))â to list the data sets in all *available* packages.
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.