Rails send_data return HTTP error 406

Question

I have a little problem on an export as XLS from my database. I use the gem `to_xls` and after folowing the documentation I have this error that I don't know how to get ride of and launch the download of my file: controller: ``` def export @subscribes = Subscribe.all respond_to do |format | format.xls { send_data@subscribes.to_xls, disposition: 'attachment', : filename = > 'Subscribes.xls' } end end ``` My MIME file ``` Mime::Type.register "application/vnd.ms-excel", :xls ``` And so, the error that I got with the full header: ``` Request URL:https://localhost:3000/subscribes/export Request Method:GET Status Code:406 Not Acceptable Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding:gzip,deflate,sdch Accept-Language:fr-FR,fr;q=0.8,en-US;q=0.6,en;q=0.4 Connection:keep-alive Host:localhost:3000 User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36 Cache-Control:no-cache Connection:close C…

Accepted Answer

Since you are using `format.xls`, you have to append `.xls` to the url. Try

```
curl -v https://localhost:3000/subscribes/export.xls
```

Otherwise, you can move `send_data` out of the `respond_to` block.

Rails send_data return HTTP error 406

Solution

Problem