On Mon, May 7, 2012 at 8:54 PM, Santosh <santosh2...@gmail.com> wrote: > Hello experts!! > I apologize for posting SPlus related query here..badly in need of relevant > info.. > > I usually use R (and your advice/tips) for my daily work. Was wondering if > there is an equivalent of "sheetCount" of the package "gdata" avaailable in > Splus 8.2? I would like to get the total number of "tabs" (aka pages) in an > MS Excel workbook.
Ensure that perl is on your path, put sheetCount.pl and module-tools.pl from the gdata .tar.gz source file (http://cran.r-project.org/package=gdata) in the current directory and then try the counterpart to this R command (which no longer requires gdata): as.numeric(system("perl sheetCount.pl myfile.xls", intern = TRUE)) -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ 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.
