Ransack Search Results - to_xls?

Question

I have a ransack search form which is working wonderfully, I would like to add an export for the user to send the contents of the result set to an XLS file.

I have implemented the to_xls sucessfully as well, however it is giving me back the fullest possible scope of the object I am searching, and not the filtered results that are shown in the view.

def index

  @search = Expense.search(params[:q])
  @expense_list = @search.result.sort_by(&:expense_date) 

    respond_to do |format|
      format.html
      format.xml { render :xml => @expense_list }
      format.xls { send_data @expense_list.to_xls, :filename => '123.xls'}
    end

end

Does it have something to do with how ransack uses the GET method? Any help would be great.

Thanks!

Are you sure you sent the `q` filter parameters when asking for the xls file? — Christopher Creutzig, Feb 12 '13 at 07:54

maxcobmara · Accepted Answer · 2013-05-06T09:31:38.490

3

I know this is such a hack, after spending many hours of not getting it, I used it anyway.

<a href="/expenses.xls?<%= request.fullpath.split("?")[1]  %>">make xls</a>

so basically it takes the searchpath after the ?, then adds it to your model.xls output path and then it works. I hate it myself, there must be a better way, but deadlines.

There was a good link here.

edited May 06 '13 at 09:31

answered May 06 '13 at 09:25

maxcobmara

391
2
9

score 1 · Answer 2 · edited May 23 '17 at 12:33

1

Ronin gave a simple solution to this related question, but with CSV instead of XLS . In my case, using Ronin's answer, I just rewrote the link to work with XLS as shown below

<%= link_to "Download Excel", reports_path(params.merge(format: "xls")) %>

edited May 23 '17 at 12:33

Community

1
1

answered Sep 18 '14 at 09:58

Musili Alfred M.

3,085
1
15
12

Note that since the implemantation of Strong Params in Rails 5 (2016), this needs to be written as: ```link_to 'Download Excel', objects_path( {q: params.require(:q).permit(:attribute_one_eq, :attribute_two_cont)}.merge({format: :xls}))``` – Nick Gobin Jul 24 '23 at 21:51

score 0 · Answer 3 · answered Sep 25 '16 at 20:44

0

%= link_to "Download Excel", yours_controller_path(params.merge(format: "xls")) %>

answered Sep 25 '16 at 20:44

Sergey Shcherbina

1

Welcome to Stack Overflow! Although this code may help to solve the problem, it doesn't explain _why_ and/or _how_ it answers the question. Providing this additional context would significantly improve its long-term educational value. Please [edit] your answer to add explanation, including what limitations and assumptions apply. – Toby Speight Sep 26 '16 at 08:41

Ransack Search Results - to_xls?

3 Answers3

Linked