similar to: odbcConnectExcel on non-Windows?

Hello, All: The "writeFindFn2xls" function in the "sos" package tries to write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it is often unable to do this because of configuration problems that are not easy to fix. I've found 3 contributed packages that provide facilities to write Excel files with

Hello, All: Jonathan Baron is "giving up" maintaining the RSiteSearch database. This breaks three things: (1) The R Site Search web service that Baron has maintained. (2) The RSiteSearch function in the utils package. (3) The sos package, for which I'm the maintainer and lead author. Might someone else be willing to take these over? For me,

Don't do anything yet. I may have found the problem by accident. I tried to use the computer from something else, and it was being drastically slowed down by some leftover processes, which turned out to be xlhtml. That is something that converts Excel files. Apparently, some excel files got into the libraries, and they were causing the indexing to hang completely. I am now running everything

Hi, Peter et al.: On 2017-01-09 4:24 AM, peter dalgaard wrote: > On 09 Jan 2017, at 10:53 , Spencer Graves <spencer.graves at prodsyse.com> wrote: > >> # Define an object of class 'dum' >> k <- 1 >> class(k) <- 'dum' >> str(k) # as expected >> >> # Define print.dum >> print.dum <- function(x, ...) >>

Hi R users: I don't know if you have had the following problem trying to export to an "xls" format file in a non windows platform. I try to use the following packages: 1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1) 2. WriteXLS (version 1.9.0) (with perl and testPerl working) Even "xlsx" package that take too long and do not finish. The data frame I try to

Hello: How can one get the number of functions and data sets in a package? I've written a function "PackageSum2" to get an extended package summary for an installed package. I get much of what I want from the object returned by "help(package=pkgName)". For example, "help(pac=...)$info[[1]]" is a character vector giving author, maintainer,

Hi, All: I'm having trouble getting deparse(substitute(x)) inside print.generic to consistently I'm having trouble getting a print.something to work consistently. Consider the following toy example: # Define an object of class 'dum' k <- 1 class(k) <- 'dum' str(k) # as expected # Define print.dum print.dum <- function(x, ...)

Hi All, I'm using R 2.11.1 on 64 bit windows XP. The little function I wrote below I use often to import the first 1001 lines in an excel sheet to R. This works fine on the 32 bit version of R but fails on the 64 bit [both on the same machine, using the same function, importing the same .xls file]. The message from 64 bit R is: Error in sqlTables(channel1) : first argument is not an

Hello everybody, I am writing a review paper about State Space models in R, and I would like to cover as many packages as I reasonably can. So far I am familiar with the following tools to deal with SS models: * StructTS, Kalman* (in stats) * packages dse[1-2] * package sspir * package dlm I would like to have some input from users who work with SS models: are there any other packages for SS

Dear R-help I would like to read Excel Spreadsheets using odbcConnectExcel() in RODBC, but data in the first row can not be read. For example, I tried to read Excel file 'Book1.xls' in the current Work Directory with the following data (Range("A1:B5") in Excel), 1 19 2 27 3 61 4 76 5 98 My commands and the result are as follows. > library(RODBC) > Book1 <-

Hi all, We know that Hermite polynomial is for Gaussian, Laguerre polynomial for Exponential distribution, Legendre polynomial for uniform distribution, Jacobi polynomial for Beta distribution. Does anyone know which kind of polynomial deals with the log-normal, Student抯 t, Inverse gamma and Fisher抯 F distribution? Thank you in advance! David [[alternative HTML version deleted]]

Folks, Is there a parameter somewhere in RODBC that enables more columns to be retrieved from an Excel worksheet? # This next bit uses an undocumented call in RODBC z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls") BQ <- sqlFetch(z, "BBaselinePtQaires") Gives me: z RODBC[1] And BQ 134 obs. of 59 variables I have all the rows in the worksheet but only the

Spencer, Thanks for the quick reply. I am open to someone who knows Perl getting an account on my site and trying to get it working. It will probably involve fixing more than one thing, as mknmz depends on some perl modules that also generate errors. My main contribution is figuring out how to extract the html help files and vignettes only, with some help from R developers and Fedora

I have probably an old question. I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC library does not work. Tried odbcConnectExcel2007 still does not work. Any ideas. Thanks Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable = "Sheet3", + na.strings = "NA", as.is = TRUE) Error in

On 9/8/2016 3:30 AM, Joris Meys wrote: > > Hi Jonathan, > > I have neither the resources nor the skills to take over, but whatever > happens I want to thank you for all the work. Too often people forget > that all these nice tools keep working due to the devotion of people > like you. > > So thank you! > I concur. People all over the world live better

On 9/8/2016 5:01 AM, Jonathan Baron wrote: > OK. It is sort of fixed and sort of works. > > We'll keep it for now, but this is not going to work forever. When > namazu fails completely I will not have the time to install a new > search engine. > > One option is to use google. For a site like this, I think they will > want some money, but I'm not sure, and I do not

OK. It is sort of fixed and sort of works. We'll keep it for now, but this is not going to work forever. When namazu fails completely I will not have the time to install a new search engine. One option is to use google. For a site like this, I think they will want some money, but I'm not sure, and I do not have the time to deal with it. We have over 10,000 packages now. I wonder if

Hello, All: I have for years copied an address like "C:\Program Files\R\R-2.15.0\library\MASS\scripts" from Windows Explorer into R, then manually replaced "\" with "/". I have a function to automate this added to the development version of "sos". However, it generates a warning in "R CMD check" ("parse error: unexpected

What software exists for digitizing video to quantify the motion of specific features in the image? I might be willing to use something that's NOT in R, though I'd prefer something in R (or at least with an R intereface). Thanks, Spencer Graves

"R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: >* checking package dependencies ... ERROR >Package suggested but not available: ?RODBC? > >The suggested packages are required for a complete check. >Checking can be attempted without them by setting the environment >variable _R_CHECK_FORCE_SUGGESTS_ to a false value.