search for: csv_xs

...CASE is ANSI-92), and also in the MS Access DB (since the Jet database engine can utilise any VBA function from within SQL). The attached script can convert from the csv file saved above into either of these two formats. To use it: - Download Perl if you don't already have it - Install Text::CSV_XS . Windows: ppm; install Text-CSV_XS; q . Unix: perl -MCPAN -e shell; install Text::CSV_XS; q - Run `perl lm2code.pl mod vba` or `perl lm2code.pl mod sql` (where 'mod' is the filename without extension from write.table) To convert to some target language other than VBA or SQ...

...l and several specific Perl modules are installed in order to function. These modules, which may already be installed on systems with Perl installed, include: OLE::Storage_Lite Parse::RecDescent Getopt::Long File::Basename Spreadsheet::WriteExcel Encode File::Glob Text::CSV_XS With the exception of the last three modules listed, for convenience all are included in the CRAN package and will be made available by adding the installed package path for these modules to the Perl @INC array. The last three modules (Encode, File::Glob and Text::CSV_XS) are 'XS'...

...l and several specific Perl modules are installed in order to function. These modules, which may already be installed on systems with Perl installed, include: OLE::Storage_Lite Parse::RecDescent Getopt::Long File::Basename Spreadsheet::WriteExcel Encode File::Glob Text::CSV_XS With the exception of the last three modules listed, for convenience all are included in the CRAN package and will be made available by adding the installed package path for these modules to the Perl @INC array. The last three modules (Encode, File::Glob and Text::CSV_XS) are 'XS'...

...::via PerlIO::scalar PerlIO::encoding POSIX Opcode ODBM_File NDBM_File MIME::Base64 List::Util IPC::SysV IO I18N::Langinfo GD BM_File Filter::Util::Call File::Glob Fcntl Encode Digest::MD5 Devel::Peek Devel::PPPort Devel::DProf Data::Dumper DB_File Cwd ByteL oader Compress::Zlib Term::ReadKey Text::CSV_XS SQL::Statement DBI Time::HiRes Apache::Symbol Apache::Leak HTML::Parser HTML::Embper l DBD::Oracle DBD::ODBC NetCDF UDUNITS Storable DBD::Pg DBD::ODBC Apache::DB Apache::Symbol Apache::Leak Digest::SHA1 Digest::MD2 Di gest::MD5 MIME::Base64 HTML::Parser Image::Magick R; linking: /usr/local/lib/per...

...tFile <- '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 able to fix this for myself. # *** However, I want to use this in the 'sos' packag...

...r version of the Perl package has a constraint where the ENTIRE Excel file cannot be larger than 7 Mb, which was a problem for my application. Here is the Perl code: #!/usr/bin/perl -w use strict; use Spreadsheet::WriteExcel::Big; use Getopt::Long; use File::Glob; use File::Basename; use Text::CSV_XS; # Initialize and get command line arguments my $CSVPath = '.'; my $CSVFiles = "*.csv"; GetOptions ('CSVpath=s' => \$CSVPath, 'CSVfiles=s' => \$CSVFiles); my $ExcelFileName = $ARGV[0]; # Create Excel XLS File print "Creating Excel File...

...re-build vignettes * creating vignettes ... ERROR Loading required package: brew Attaching package: 'sos' The following object is masked from 'package:utils': ? Loading required package: WriteXLS 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 he re. Otherwise, please install the missing modules. See the package INSTALL file for more information. Loading required package: RODBC Warning in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :...

I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or