How to show params in URL, but stay on this page when running AJAX search?

Question

I want to generate xls reports for AJAX search results. Is it possible to pass params for generating Excel document or add params in URL ?

Here is how I generating URL for downloading XLS document:

<%= link_to url_for(request.params.merge({:format => :xls}))  do%>
  <%= image_tag("excel.png")%> <b>Export</b>
 <% end %>

and it is working with standard search, but not with AJAX.

My js code for AJAX search

$('#run_report').submit(function () {  
  $.get(this.action, $(this).serialize(),'script');  
  return false;  
});

Can someone suggest how to do it ?

score 0 · Answer 1 · edited May 23 '17 at 10:24

0

I am not aware of an xls dataType for ajax. The dataTypes I am aware of are xml, html, script, json, jsonp, text. So using ajax with an xls file may require a two step approach.

In my search to complete a task similar to your question I came across the following which may achieve the download you are looking for : Downloading xls file .Hopefully you will also find it useful.

edited May 23 '17 at 10:24

Community

1
1

answered Sep 27 '12 at 08:23

codepuppy

1,130
2
15
25

I assume that you used something based on DanSingerman's suggestion? Ultimately I used PHPExcel which you may like to review. – codepuppy Sep 27 '12 at 09:21
I tried, but params not passing there... can I show you my code ? – MID Oct 08 '12 at 13:56
Yes why don't you edit your question and add your findings to date. – codepuppy Oct 10 '12 at 12:50
I just get the same result. Params not passing there. I will post it later today, excuse me. – MID Oct 10 '12 at 14:23

How to show params in URL, but stay on this page when running AJAX search?

1 Answers1