GridPanel directly to Excel.

[zhw511006]

Thank you for sharing your code!

But Error ! IE7:
The data area passed to a system call is too small.

[mystix]

From post #1 one of this thread (emphasis added):

This needs a browser that supports data URLs. FF, Opera and IE8 will support this.

.

[snoir]

Your PHP code should be like this one:

header("Pragma: public");
header("Expires: 0"); // set expiration time
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition:attachment;filename=export");
echo $_REQUEST['ex']; 

i don't understand php code,i want jsp code

[jmcneese]

i don't understand php code,i want jsp code

dude. are you saying you use JSP and don't know enough to translate the above PHP code (which is about as simple as it gets) into JSP?

this forum isn't a soup kitchen. go hit up the php website (maybe http://www.php.net/echo and http://www.php.net/header will help) and figure it out.

[snoir]

this is my js code:

Ext.Ajax.request({
                  url: '../../exportexcel.jsp',
                  method: 'POST',
                  form: Ext.fly('frmDummy'),
                  callback: function(o, s, r) {
                      //alert(r.responseText);
                  },
                  isUpload: true,
                  params: {exportContent:vExportContent}
               })

this is jsp code:

<%
 response.setHeader("Pragma","public");
 response.setHeader("Expires","0");
 response.setHeader("Cache-Control","must-revalidate, post-check=0, pre-check=0");
 response.setHeader("Content-Type","application/force-download");
 response.setHeader("Content-Type","application/vnd.ms-excel");
 response.setHeader("Content-Disposition","attachment;filename=export");
 
 out.print(request.getParameter("exportContent"));
  %>

i can't get "exportContent" in jsp.........
i open the excel file,it's null....but in function callback can show the 'exportContent''s value......


when i delete 'form: Ext.fly('frmDummy')' ,jsp can get the params.......

How to resolve this issue？？？

[emredagli]

Hii,
I found a way to save as different filename and also working in IE 7.0 by using .NET framework in server side.
.js code:

function post_to_url(path, params, method) {
    method = method || "post"; 

    var form = document.createElement("form");
    form.setAttribute("method", method);
    form.setAttribute("action", path);

    for(var i=0; i<params.length; i++) {
        var hiddenField = document.createElement("input");
        hiddenField.setAttribute("type", "hidden");
        hiddenField.setAttribute("name", params[i].name);
        hiddenField.setAttribute("value", params[i].value);

        form.appendChild(hiddenField);
    }

    document.body.appendChild(form);   
    form.submit();
}

function exportExcell() {

    var dataURL = 'CommonPages/ExportToExcelType1.aspx';

    params =[{
        name: 'Data',
        value: resultGrid.getExcelXml()  // Mr. Animal's part...
    },{
        name: 'FileName',
        value: 'File1.xls'
    }];
    
    post_to_url(dataURL, params, 'post');
}

CommonPages/ExportToExcelType1.aspx.cs code is:

    protected void Page_Load(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("Content-Disposition", "attachment;filename=\"" + Request.Params["FileName"].ToString() + "\"");
        Response.Charset = "";
        this.EnableViewState = false;
            
        System.IO.StringWriter SW = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter HTW = new System.Web.UI.HtmlTextWriter(SW);
        HTW.WriteLine(Request.Params["Data"]);

        Response.Write(SW.ToString());
        Response.End();

    }

And do not forget to put ValidateRequest="false" in the top of the ExportToExcelType1.aspx file like:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExportToExcelType1.aspx.cs" Inherits="CommonPages_ExportToExcelType1" ValidateRequest="false"%>

In this solution there may be unnecessary parts...
But it works nicelly.
I hope it helps you... Good luck...

[snoir]

In this solution there may be unnecessary parts...
But it works nicelly.
I hope it helps you... Good luck...

thx,emredagli.the code is ok.

my js:

var exportMenu= {
      text: 'ExportToExcel',
      iconCls:'export',
      tooltip:'ExportToExcel',
      handler: function() {
          var vExportContent = grid.getExcelXml();
          if (Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2 || Ext.isSafari3) {
              var dataURL = '../../exportexcel.jsp';
              params =[{
                   name: 'ex',
                   value: vExportContent 
              },{
                  name: 'FileName',
                  value: 'excel.xls'
              }];
              post_to_url(dataURL, params, 'post');
          } else {
              document.location = 'data:application/vnd.ms-excel;base64,' + Base64.encode(vExportContent);
          }
         }
  };
 
function post_to_url(path, params, method) {
     method = method || "post"; 
     var form = document.createElement("form");
     form.setAttribute("method", method);
     form.setAttribute("action", path);
     for(var i=0; i<params.length; i++) {
         var hiddenField = document.createElement("input");
         hiddenField.setAttribute("type", "hidden");
         hiddenField.setAttribute("name", params[i].name);
         hiddenField.setAttribute("value", params[i].value);            
         form.appendChild(hiddenField);
     }   
     document.body.appendChild(form);   
     form.submit();
 }

my jsp:

<% response.setHeader("Pragma","public");
 response.setHeader("Expires","0");
 response.setHeader("Cache-Control","must-revalidate, post-check=0, pre-check=0");
 response.setHeader("Content-Type","application/force-download");
 response.setHeader("Content-Type","application/vnd.ms-excel");
 response.setHeader("Content-Disposition","attachment;filename="+request.getParameter("FileName"));
 
 out.print(request.getParameter("ex"));
 %>

[vvreddy@12]

Hi snoir,

I have used the same code given by you but could not get the output.

I am getting a blank excel sheet.
please let me know what to do ????

Thanks,
Vishnu

[emredagli]

Are you sure the excel datas created successfully?

(By putting break point on Firefox) Check the,

var vExportContent = grid.getExcelXml();

part.

[vvreddy@12]

Hi Emredagli,

The excel was blank and didn't get any data. Can you suggest me what was wrong in that piece of code.

Thanks,
Vishnu