similar to: help

Dear All, I am using WriteXLS to write tables with multiple sheets with the command: WriteXLS("tables", ExcelFileName = fileName, SheetNames = tableList, perl = "perl", verbose = FALSE, Encoding = c("UTF-8", "latin1"), row.names = TRUE, col.names = TRUE, AdjWidth = TRUE, AutoFilter = FALSE, BoldHeaderRow = FALSE,

I am using R 2.11.1 in a Microsoft Windows 7 environment.   I tried using WriteXLS, but get the message " In system(cmd) : perl not found"   What is the "easiest" way to write an R dataframe to Excel?  (I am familiar with WriteXLS, but I do not have PERL installed, and if not needed, do not wish to install it.)   I am also familiar with write.table, but if possible, wish to

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, I don't understand why this won't work. I have entered: WriteXLS(alldata,'test.xls') and I get this error message: Error in get(x, envir = envir) : variable names are limited to 256 bytes. My variable names are not very long, and are accepted by write.csv. alldata is a list containing 4 dataframes, with each dataframe having the the same variable names, which are:

Hello! I've generated multiple data frames that I wish to export to excel using the function write.table. When I do so all the data is merged into a single column in excel. I Would like the columns of my data frame in separate columns in excel as well but it doesn't work. I tried to download the package WriteXLS and installed Perl on my computer just like it was recommended. I also tried

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

R-developers: I have a small python script that I'd like to include in an R package I'm developing, but I'm a bit unclear about which subfolder it should go in. R will be calling the script via a system() call. Thanks! --j -- Jonathan A. Greenberg, PhD Assistant Professor Global Environmental Analysis and Remote Sensing (GEARS) Laboratory Department of Geography and Geographic

Hello: What should I do regarding code to write an Excel file in a non-Windows platform? The "sos" package [new version of "RSiteSearch"] on R-Forge includes "writeFindFn2xls", which starts with "require(RODBC)". The next line calls "odbcConnectExcel". This works under Windows but fails under Linux and MacOS. What

Hi, My R package has files in the 'inst' directory that it needs to reference. How can the R scripts in my package find out the full path to the 'inst' directory after the package is installed, given that different users may have installed the package to different libraries? Thanks, Jon Malmaud

Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a function or package to export directly into *.xls. I have found xlsReadWrite which would be

Hi Team, I am tried "WriteXLS" package for merging 2 csv files. R script runs successfully but does not create CSVmerge file. Appreciate our help. ?Best Regards, Kamlesh Khollam? [[alternative HTML version deleted]]

I am using read.xls command from the gdata package. I get the following error when I try to read a work sheet from an excel sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning message: running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program

Dear list, I have some .xls files that I need to read into R. I am able to do so using read.xls in the gdata package, however the helper functions sheetNames and sheetCount fail. This is the error: Unable to open file '~/SharedFolder/MyData/mydata.xls'. Warning: running command ''/usr/bin/perl' '/usr/local/lib/R/site-library/gdata/perl/sheetCount.pl'

> On Nov 6, 2017, at 3:23 AM, Kamlesh Khollam <khollam.kamlesh33 at gmail.com> wrote: > > Hi Team, > I am tried "WriteXLS" package for merging 2 csv files. R script runs > successfully but does not create CSVmerge file. > > Appreciate our help. > > ?Best Regards, > Kamlesh Khollam? Hi, You appear to be replying to a thread from January of 2016, or

Dear R-helpers, i am trying to make a shared library from a Fortran subroutine, and i therefore used (after reading the documentation): Rcmd SHLIB forfile.f #(R1.70, Win2000) And the error is: " 'perl' is not recognized as an internal or external command,operable program or batch file." So i went ahead and tried to install Perl (from the suggested website in

Hi, I'm seeing a weird problem with rsync 2.6.9 protocol version 29 on Debian Sarge. When copying a file from one location to another between two Debian boxes, if destination includes a file with same size and name, rsync fails to see that they are not exactly the same file. The situation originates from copying a file to a place which is periodically rsynced onwards, and the rsync

R 2.5.1 compiled, passed the make check and has been successfully running for a couple years on a Sun Fire V490 running Solaris 9. I need a newer version of R, but can't get a newer version of R to pass the make check. I've tried 2.8.1, 2.7.2, 2.6.2 and 2.6.0. (2.5.1 still passes on this server) At this point I thought I'd try to compile it on another Sun server (Solaris 10),

R 2.5.1 compiled, passed the make check and has been successfully running for a couple years on a Sun Fire V490 running Solaris 9. I need a newer version of R, but can't get a newer version of R to pass the make check. I've tried 2.8.1, 2.7.2, 2.6.2 and 2.6.0. (2.5.1 still passes on this server) At this point I thought I'd try to compile it on another Sun server (Solaris 10),

Dear r helpers; I'm interested in reading from and writing to large .xlsx files fairly regularly. (Why, the naysayers may ask - and the answer is basically colleagues and clients who prefer that format). I've tried out the XLConnect and xlsx libraries, but the java implementation they use just takes too much RAM for the files I'm working with. gdata leverages perl and works really

Hi all, For several years, I have used path.package() to get the path to Perl scripts contained within WriteXLS. I have a request to change this to using system.file(), which would provide the ability to utilize WriteXLS functionality, without having to load the package, which path.package() requires. Based upon my review of the code, I don't see any obvious down sides to making the change,