Exporting Information from Ruby on rails to a excel sheet.

max power

Hey,

Pretty new to this and I was asked to setup a application at work that stores all the information regarding all the systems in our lab. Long story short I have everything working apart form exporting the information to a excel sheet. I tried this http://www.napcsweb.com/blog/2007/01/24/excel-export-the-stupid-simple-way/#respond,
which seems very straight forward but i still come up with the error "wrong number of arguments". Any ideas on another way to do this? or a better guide to this.

thanks.
Gearoid

improvcornartist

Without seeing your code, I don't know how to help you with your current error. However, this is what works for me.

I have defined the following method in my 'application' controller:

Expand|Select|Wrap|Line Numbers

 def download

    send_data session[:csv], :filename => params[:filename]

end

Then in the project controller, I have created a csv variable to store all my data elements, separated by commas, using "\n" for new lines. Then store the csv variable in the session and create a link to the download method, passing the filename:

Expand|Select|Wrap|Line Numbers

 session[:csv] = @csv

@filename = 'filename.csv'

@link = '<a href="/viewfolder/download?filename=' + @filename + 

'">Download</a><br/>' + "\n"
 
render :text => @link

Hopefully this helps. Let me know how it works out.

Anthony

johnnyDispo

Quote:

Originally Posted by max power

Hey,

Pretty new to this and I was asked to setup a application at work that stores all the information regarding all the systems in our lab. Long story short I have everything working apart form exporting the information to a excel sheet. I tried this http://www.napcsweb.com/blog/2007/01/24/excel-export-the-stupid-simple-way/#respond,
which seems very straight forward but i still come up with the error "wrong number of arguments". Any ideas on another way to do this? or a better guide to this.

thanks.
Gearoid

There is also a HowTo on the Rails website, wich offers several ways. Even with the spreadsheet.gem

Exporting Information from Ruby on rails to a excel sheet.

re: Exporting Information from Ruby on rails to a excel sheet.

re: Exporting Information from Ruby on rails to a excel sheet.

Similar Ruby / Ruby on Rails bytes

/bytes/development

/bytes/it

/bytes/about