Downloading a file (Excel file) with store.load? (ExtJS 4.1)

Question

I need to download a file from a grid using a button in window. In order to send the filter parameters I use store.load however it doesn't download the file but it tries to read it. Is there any solution?

store.load({
 params: {
  startExel: parseInt(Ext.getCmp('startE').getValue())
 }
});

startExel is an extra parameter in order to indicate that I want to download an Excel file.

Is the excel file generated by a script or is it an actual file on the server? You could just wrap an tag around the data in the grid cell and direct the href to the file or script — gunnx, Jun 28 '12 at 09:00
@gunnx, the Excel file is generated serverside using the parameters send from the extjs. — ilhan, Jun 28 '12 at 09:13
why are you using the store.load could you not just use Ext.ajax instead passing the params needed. — gunnx, Jun 28 '12 at 10:59
I don't know how to get the parameters. Too much of them, some appear some times and some not. Plus they are JSON enceded. I'm looking for a simple solution. — ilhan, Jun 28 '12 at 11:04

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

I don't think its possible to do this by simple configuration changes. Because stores are loaded via AJAX calls.

Here is an idea for you:

Return a JSON object with file download url as the response to store load request. Not the actual file contents.

{ success = false, url='...'}
In client side handle the store load failure then identify and extract the returned url. You may have to tweak reader configuration a little.
Call window.open(url) to initiate the file download.

See this question from SO.

score 0 · Answer 2 · answered Jun 28 '12 at 10:34

0

On the server end when returning the file include the following header:

Content-disposition: attachment

answered Jun 28 '12 at 10:34

sha

17,824
5
63
98

I use http://phpexcel.codeplex.com/ I think it is related with the request itself. – ilhan Jun 28 '12 at 10:59
It has `Content-Disposition: attachment;filename="01simple.xlsx"` – ilhan Jun 28 '12 at 11:23

Downloading a file (Excel file) with store.load? (ExtJS 4.1)

2 Answers2