similar to: Server out to excel

What have I missed I have a .rhtml with the sandard form parameters <%= image_submit_tag("excel.gif", :alt => "Download List to Excel", :border => 0, :name => ''render_action'', :value => ''excel'' ) %> Which genenerates I believe a valid html fragment for a submit button. <input alt="Download List to Excel"

Hello I would like to know if there is a webpage or something else (even another thread in this forum) where there''s an explanation (preferably simple and detailed)on how to export data from a rail application to a .doc or a .xls. I have read Agile Web, Rails recipes and a few threads in this forum but I don''t know how to do it. Where is stored the model document ? How to

I want to get the Date in formation YYYY-MM-DD for the start of the current year But I cannot think how to do it... This generates a name error .rhtml view. <%= at_beginning_of_year.Time.now %> -- Posted via http://www.ruby-forum.com/.

I have one table that stores data related to math problems, and another table that stores users'' answers to those problems. To make this very simple, we''ll say that the math table has two numbers that get subtracted, and the answers table has a field that can either be "pos" or "neg" math _____ 2 5 8 3 Okay so if we do the math, we know that the

Hi, I am a rails and ruby nuby :-) How do you pass data between different controllers and views? I have a page ( a quote) that I am editing url ....quote/edit/6 6 id the current id. I then go to a catalog (url....catalog) to add an item to my quote (I do this via a line_item file that the quote reads) I now want to go back to the quote. I have tried this <%= link_to ''Back to

I have a batch job that will call script/runner, I would like in this call to create html formated email and save it to the database. This is easy enough in a controller with yournewhost.email = render_to_string :action => "email_newhost_ready", :layout => false But render_to_string is only available in controller action pack, is there a easy way to render_to_string in a Model? Or

I want to validate the uniqueness of a field if the field has a value. Is there anyway to do it? -- Posted via http://www.ruby-forum.com/.

hi, Im sending data to the browser with a utf-8 charset but somehow when I open the file in excel, some garbage characters appear. Here''s my code: send_data(excel_file, :filename => "orders.xls", :type => ''application/vnd.ms-excel; charset=utf-8'' ) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You

hey, i want to generate an excel file and send it directly to the browser (without storing it to the harddisk). does anyone has any solution? thanks in advance this is my code: -------------------- def export_excel if @request.env[''HTTP_USER_AGENT''] =~ /msie/i @headers[''Pragma''] = '''' @headers[''Cache-Control''] =

Hello Good morning to all, I am doing reports in ruby on rails,i am trying to export data throgh excel in CSV format.Now i want to set the font to the text exported to excel sheet.How can i set font..please help me regarding this ... my sample code was like this... report = StringIO.new CSV::Writer.generate(report, '','') do |csv| csv << [''Invoice History

Hi, I want to offer a CSV download of data in my Rails app (eg. An "Export to Excel" link to grab the current view of tabulated data). However, I can''t seem to break-out of the Rails framework to output this non-HTML data. Even if I eliminate my layout template from my view, the most basic view (no HTML) will still wrap the output in

I''m pretty much done with a project I''ve been developing to learn Rails, http://www.happycarpools.com . If you could take a look, that''d be awesome! Feedback would be even more awesome! Probably the coolest thing about making this has been seeing how Rails does *so much* and hardly has any superfluous parts, if any. There are so many features that I initially

I want when the user clicks on a button on the browser "Perform monthly billing run" the controller to lanch a sql DML statment to be called (in the model?) than runs something like "insert into billing (item, qnt, total_cost, billing_run_timestamp select item, qnt, item*cost as total_cost, timestamp from services where service_end_date is null" How can I run a DML

Hi, I have two columns that contain numbers along with letters (as shown below) and have different lengths. Each entry in the first column is likely to be found in the second column at most once. For each entry of the first column, if that entry is found in the second column, I would like to get the corresponding index. For instance, if the first entry of the first column is 5th entry in the

It's generally a very good idea to examine the structure of data after you have read it in. str(data2) would have shown you that read.csv() turned your strings into factors, and that's why the == operator no longer does what you think it does. use ... data_2 <- read.csv("excel_data.csv", stringsAsFactors = FALSE) ... to turn this off. Also, the %in% operator will achieve

Before I spend a lot of time trying to replicate a procmail script that automatically sorts list mail into mailboxes based on the List-ID header (and possibly some other data) I thought I'd check if someone had already done this for sieve. Basically, what I do now in procmail is 1. Get the listname from the List-ID header (or List-post/List-owner if no ID) 2. check against a list of

Combining and completing the advice from Greg and Boris the complete solution is two lines: data_2 <- read.csv("excel_data.csv", stringsAsFactors = FALSE) match_list <- match( data_2$data1, data_2$data2 ) The vector match_list will have the matching position when it exists and NA's otherwise. Its length will be the same as the length of data_2$data1. You should get

I''m attempting to use send_file to send an image file from public/images. The file is world readable. I keep getting the following error: A ActionController::MissingFile occurred in account#current_logo: Cannot read file public/images/logo.png /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/streaming.rb:55:in `send_file'' I''ve tried supplying

Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100214/4b41a017/attachment.pl>

If a user enters the Textile-based code for an image, say: !>graphic.png! the textile() method will successfully render a right-float image. Now, if I want to escape the user''s text using h(), the ''>'' is turned into an &amp;. Obviously, the image then fails to render in a browser. Is there a work around for this? I guess what I''m really asking