export to Excel

[FMIC_DEV]

Hello All -

I have a servlet that executes the code necessary to export grid data to Excel. However i when i call it with ext.ajax it does't run propertly. when i run it from the browser it runs fine.

here is the code i used to execute the servlet.

var grid1 = new xg.GridPanel({
        id:'smGrid',
        store: statsStore,
        cm: SDcols,
        viewConfig: {
            forceFit:true
        },
        width: 600,
        height: 300,        
        collapsible: true,
        animCollapse: false,
        title: 'Simple Grid from XML Datasource',        
        tbar:[
        { 
        icon: '/main/resources/images/excel_x.gif',
        cls: 'x-btn-icon',
        tooltip: 'Export to Excel',
        listeners: { click: {fn: function (){
        
        var url="/main/ExportExcel"
        
        Ext.Ajax.request ({
            "url": url,
            "method": "GET",
            "success": function(response){/* success function. */},
            "failure": function(e){/* failure function. show an error message */},
            "scope": this
        });
        
        }}}}
        ],        renderTo: document.body
    });

the grid renders properly and when i hit the icon to export the data the servlet does in fact run but it doesn't show me the save file dialog box like it does when i run the servlet by itself.

the servlet doesn't have a response. it just executes and returns.

Any ideas here?

[hendricd]

Your best bet is to load your Excel response in a hidden iframe, returning a Content-Disposition header in your response, then the Save dialog should appear.

XMLHttpRequest does nothing with that header tho.

[Condor]

Ext will automatically submit to a hidden IFRAME instead of using XMLHttpRequest if you set isUpload: true in your request.

[hendricd]

Nice, Forgot all about that one.

[FMIC_DEV]

i created an Iframe on the html page and added isUpload to the request but still no joy.

what do i do on success?

TIA