search for: parseexcel

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 maybe a scripted OpenOffice conversion would be possible. Needs to deal with both xls and xlsx formats, the odd characters that ar...

when i try to get a text type cell, i always end up w/ getting the text divided by ''?''. for example, instead of getting "hello", i will get something like "h?e?l?l?o?". im really frustrated. does anyone know anything about this? plz help!!!! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in <output file>. If <output file> is not specifi...

> Hi, > > I am new to ruby on rails.I am having problem reading excel files. I > tried using gem ''parseexcel'' but still the error is coming. > Could you please help me with the code and how to use this gem? Is > there any better way to read excel sheets. > > Snippet of Code: > > require ''rubygems'' > require_gem ''parseexcel'' > > class...

...to install VICIDIAL (cause is a free outbound call solution) and vicidial wants the following perl modules: MD5 Digest::MD5 Digest::SHA1 readline Bundle::CPAN DBI (found the rpm perl-DBI) DBD::mysql (found the RPM perl-DBD-Mysql) Net::Telnet Time::HiRes Net::Server OLE::Storage_Lite Spreadsheet::ParseExcel I do not want to taint the installation if an RPM is available on the DVD or in centos extras/plus. How can I check what RPM will provide such perl modules? thanks in advance. -- ------------------------------------------------------------ Erick Perez Panama Sistemas Integradores de Telefonia...

...ere a client has large Excel files > (60.000+ records per file) and he needs an application to import them > into a database to use this data for useful operations (reporting, > calculations .. etc). > > I know about the available libraries: > > http://raa.ruby-lang.org/project/parseexcel/http://rubyforge.org/projects/spreadsheet/http://rubyforge.org/projects/roo/ I''m the author of the roo gem. Roo can handle such huge spreadsheet files without problems but it may be very slow. You can try if it is fast enough for your purposes. -Thomas --~--~---------~--~----~---------...

Hi, Does anyone know of a package that will help with generation of spreadsheets? (xls files, not csv) Thanks, Fredrik --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe

A colleague has a dozen of excel sheets and also expects to get updates regularly. He could open these in M$-Excel and export as *.csv manually, "bring back to Unix" and then read into R. Of course there must be options to start programming this in something like visual basic, but we wouldn't to really want to... We also know that probably Gnumeric could do the job (since the xls

...from common non-text file formats for searching? I'm trying to use the kinosearch add-on for twiki which is fine as far as the search goes, but it takes forever to generate the index. It uses xpdf to extract strings from pdf's, antiword for .doc, and since it is perl, the Spreadsheet::ParseExcel module for .xls. Some documents parse/index quickly, some extremely slowly, and in the .xls case some seem to hang forever. I think the real issue is when the parsers (correctly or incorrectly) detect a wide character set and the indexer is confused when trying to re-encode it. What is the b...

All, In my app., I am displaying the contents of a spreadsheet that the user uploads in a XLS/CSV file (thanks parseexcel & fasterCSV!), and then saving it into tables internally. I would like to make this data editable in my app. in a spreadsheet-like display. I am trying to think about the best way to handle the data update to the server. Here are my thoughts. I am looking for advice on how best to handle...

...ta and send it to the user using the send_file method. For a while, I''ve been testing these methods with assert_response :success, and then checking the response headers to make sure the file at least looks like what I should be getting. But it occurred to me recently that I could use the parseexcel library to actually test the correctness of the contents of the file, if I can access it. So: is there any way to save the file being sent to a temporary file from within the functional test? Can the data be accessed using the response object somehow? I''ve tried poking around at the respo...

I am having a problem in reading the columns from an xls file. Following is the code: workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file]) worksheet = workbook.worksheet(0) skip=0 worksheet.each(skip) { |row| puts row.at(0) } I am storing "Customer" in the first row first column. When I print, it is received as C[]u[]s[]t[]o[]m[]e[]r[] (I mean a box in b...

Hai, I am using parseexcel to export data to a excel,while exporting a large amount of data it shows a MaxSizeError. Ithink that i will use roo for exporting data into excel.But i dont know the codings to write data into excel can anyone help me.. Thanks in Advance -- Posted via http://www.ruby-forum.com/.

...above new options will apply to ALL worksheets created in the XLS file. Please note that after researching the potential for being able to append new worksheets to an existing XLS file, this does not appear to be a robust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros,...

...above new options will apply to ALL worksheets created in the XLS file. Please note that after researching the potential for being able to append new worksheets to an existing XLS file, this does not appear to be a robust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros,...

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

...new_date is undefined in the JDBC adapter. I have the following gems installed: *** LOCAL GEMS *** actionmailer (2.2.2) actionpack (2.2.2) activerecord (2.2.2) ActiveRecord-JDBC (0.5) activerecord-jdbc-adapter (0.9.1) activeresource (2.2.2) activesupport (2.2.2) net-sftp (2.0.2) net-ssh (2.0.11) parseexcel (0.5.2) rails (2.2.2) rake (0.8.4) rspec (1.2.0) rubyzip (0.9.1) rufus-scheduler (1.0.13) sources (0.0.1) The error dump is: undefined method `new_date'' for JdbcSpec::Oracle::Column:Module C:/jruby-1.2.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/jdbc_adapter/jdbc_oracle....

Dear all, I am interested in reading Excel spreadsheets (*.xls) directly into R (I am using version 1.1.1 at the moment). I have not had much luck so far. For the time being, I have been converting Excel files to comma delimited files (*.csv) and reading these into R (using commands such as "read.csv"). This works well, but it would be more efficient if I could read the Excel files

A client of mine has a ton of data stored in Excel spreadsheets. I''m building a web application for her (backed by a real db of course) and want to import all that data. Is there a library available to read data from Excel? Is there an easy way to upload the spreadsheets and then read the data? Thanks, Ken Kousen -- Kenneth A. Kousen, Ph.D. President Kousen IT, Inc.