similar to: Saving lots of editable data - best practices?

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

Does anyone have a good recommendation for implementing an editable data grid (like a spreadsheet) based on a dbase table/model? What I would like is something similar to Google Spreadsheets. Thanks, Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group,

> 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

Hello, On 16 Okt., 20:02, "AN@S" <anas.marr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > Hello, > > I''m running into a project where 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

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

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

I need 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

I have a number of actions that use the spreadsheet/excel library to generate an Excel spreadsheet based on model data 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

Hi All, I need to create an editable data grid. What would be a good way to do it? I did not explore wice_grid much - but it does not seem to allow editing. I was wondering if I could use a combination of in_place_editor and wice_grid to achieve this. -- Regards, Kashyap

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

Does anyone have experience with linux tools to parse the text 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

Dear useRs, This is to announce the RGtk2Extras R package is available on CRAN in version 0.5.1. This package provides useful extras for R programmers who wish to create graphic user interfaces. It is based on GTK, using Michael Lawrence's RGtk2 package and John Verzani's gWidgets, and some ideas from John Verzani's traitr package. The first major feature of RGtk2Extras, the

Dear useRs, This is to announce the RGtk2Extras R package is available on CRAN in version 0.5.1. This package provides useful extras for R programmers who wish to create graphic user interfaces. It is based on GTK, using Michael Lawrence's RGtk2 package and John Verzani's gWidgets, and some ideas from John Verzani's traitr package. The first major feature of RGtk2Extras, the

Hi! I''m writing a datagrid plugin and would like to render the datagrid using a .rhtml template. However, I''d like to avoid placing this template in app/views/shared, but it should reside somewhere within vendor/plugins/datagrid/... Any ideas? -- Posted via http://www.ruby-forum.com/.

I just finished posting an article on creating a lightweight but very functional web grid that does a slick job of live updating whatever content you put in. Much like Rails itself, I pulled the code from an active project effort, in the hopes that others would find it useful. http://unspace.ca/discover/datagrid Or, for the impatient, give the demo a shot: http://unspace.ca/datagrid Feedback

I''m trying to create a list of doctors with names and surnames. I want to be able to add many doctors using AJAX and then save all of them at the same time. All the doctors are associated to a patient. I want to do something like the datagrid in http://unspace.ca/datagrid/update but I would like to use RJS because this fellow used javascript before RJS came out. And also, they are

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

I''m using FasterCSV to upload some csv files and create some records based off the data in the CSV files. I''m pretty sure the problem is a character encoding issue because the CSV is full of French and German words. If I remove all the accents off the letters, then it uploads fine, otherwise it just throws a FasterCSV::MalformedCSVError. jeremy-woertinks-imac:winovations

I await Luke''s node settings implementation with interest. At the moment however, I have this sort of ugliness: $site = $hostname ? { fred => "opsera", barney => "bedrock", default => "unknown site", ... } So I''ve knocked up this little function to use CSV files instead. Now I can just do: $site =