search for: testperl

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 export has 269363 row and 116 columns. In the first one (dataframe2xls) I get this message: Traceback (most recent call last): File "C:/PROGRA~2/R/R-211~1.1PA/library/dataframes2xls/python/...

...c2=3:4, c3=5:6) df2 <- data.frame(c21=c(10.10101010101,20, 3), c22=c(50E50,60, 3) ) outFile <- 'df12.xls' write.xls(c(df1,df2), outFile) # works do.call(write.xls, list(c(df1, df2), outFile)) # Error in get(s[i]) : object 'structure(list(c1=1:2' not found library(WriteXLS) testPerl() #Perl found. #The following Perl modules were not found on this system: #Text::CSV_XS #If you have more than one Perl installation, be sure the correct one was used here. #Otherwise, please install the missing modules. See the package INSTALL file for more information. # *** NOTE: I may be ab...

...contains. Key changes from version 1.5.0: 1. Thanks to work by Uwe Ligges and changes to the examples being used, Windows and OSX binary versions of the package will become available to enable their easier installation using install.packages() within an R session. 2. A new function called testPerl() has been added to enable the self- checking of the user's system to ensure that Perl and all required Perl modules are available to use the WriteXLS() function. The package will return either success or error messages indicating missing requirements. If you are unsure as to whether or...

...ame will be the name of the data frame it contains or can be specified by the user. Author(s): Marc Schwartz <marc_schwartz at me.com> Maintainer: Marc Schwartz <marc_schwartz at me.com> License: GPL (>=2) Changes since version 1.6.0: 1. Added \'verbose\' argument to testPerl so that it can be used in an if() manner without console output 2. Added \'SheetNames\' argument to WriteXLS to enable user specified worksheet names 3. Added various checks to code for unique worksheet names, worksheet names <= 31 chars, length(SheetNames) == length(x) 4. Added check...

...worksheet names as indicated in the 'SheetNames' argument (added recently in version 1.7.1), if present. As a result of the above change, File::Glob is no longer used and has been removed as a required Perl module for the package. References to File::Glob have been removed from the testPerl() function and all supporting files. The INSTALL file has been copied to the 'inst' package folder, so that it is installed in the main package directory. It will therefore be available both on the CRAN mirror page for the package and on the user's system as referenced in the h...

...or more data frames, in addition to the original vector of one or more data frame names. 3. Updated with newer versions of the included Perl modules. 4. Note that WorkbookBig.pm is no longer required and is therefore removed from the packaged Perl modules. 5. Fixed the underscores "_" in testPerl.Rd 6. Added check of the data frames for rows > 65536 and columns > 256. 7. Temporary CSV file names are now (1:number of data frames).csv 6. SheetNames are now always written to temporary file SheetNames.txt, so the '--SN' argument is deleted from the Perl script The major user vis...

...worksheet names as indicated in the 'SheetNames' argument (added recently in version 1.7.1), if present. As a result of the above change, File::Glob is no longer used and has been removed as a required Perl module for the package. References to File::Glob have been removed from the testPerl() function and all supporting files. The INSTALL file has been copied to the 'inst' package folder, so that it is installed in the main package directory. It will therefore be available both on the CRAN mirror page for the package and on the user's system as referenced in the h...

...or more data frames, in addition to the original vector of one or more data frame names. 3. Updated with newer versions of the included Perl modules. 4. Note that WorkbookBig.pm is no longer required and is therefore removed from the packaged Perl modules. 5. Fixed the underscores "_" in testPerl.Rd 6. Added check of the data frames for rows > 65536 and columns > 256. 7. Temporary CSV file names are now (1:number of data frames).csv 6. SheetNames are now always written to temporary file SheetNames.txt, so the '--SN' argument is deleted from the Perl script The major user vis...

...contains. Key changes from version 1.5.0: 1. Thanks to work by Uwe Ligges and changes to the examples being used, Windows and OSX binary versions of the package will become available to enable their easier installation using install.packages() within an R session. 2. A new function called testPerl() has been added to enable the self- checking of the user's system to ensure that Perl and all required Perl modules are available to use the WriteXLS() function. The package will return either success or error messages indicating missing requirements. If you are unsure as to whether or...

...ame will be the name of the data frame it contains or can be specified by the user. Author(s): Marc Schwartz <marc_schwartz at me.com> Maintainer: Marc Schwartz <marc_schwartz at me.com> License: GPL (>=2) Changes since version 1.6.0: 1. Added \'verbose\' argument to testPerl so that it can be used in an if() manner without console output 2. Added \'SheetNames\' argument to WriteXLS to enable user specified worksheet names 3. Added various checks to code for unique worksheet names, worksheet names <= 31 chars, length(SheetNames) == length(x) 4. Added check...

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