Export grid panel data to excel

[sumesh]

Hi ,

Im using a grid panel with a large number of templated columns. i want to export the same grid to excel , whereas the format needs to be retained..

I tried using several samples .. but it exports the store data alone.. the format of the grid is not available..


Pls help me to export my ext grid panel to excel with the format , what i have designed to show in UI

[Binai]

Hi ,

Im using a grid panel with a large number of templated columns. i want to export the same grid to excel , whereas the format needs to be retained..

I tried using several samples .. but it exports the store data alone.. the format of the grid is not available..


Pls help me to export my ext grid panel to excel with the format , what i have designed to show in UI

HI you can use this code


protected void Store1_Submit(object sender, StoreSubmitDataEventArgs e)
{
string format = this.FormatType.Value.ToString();

XmlNode xml = e.Xml;

this.Response.Clear();




this.Response.ContentType = "application/vnd.ms-excel";
this.Response.AddHeader("Content-Disposition", "attachment; filename=File.xls");
System.Xml.Xsl.XslCompiledTransform xtExcel = new System.Xml.Xsl.XslCompiledTransform();
xtExcel.Load(Server.MapPath("Excel.xsl"));
xtExcel.Transform(xml, null, Response.OutputStream);
this.Response.End();

}

Javascript
********************************
var submitValue = function (grid, hiddenFormat, format) {
hiddenFormat.setValue(format);
grid.submitData(false, { isUpload: true });
};


design
*****************
<ext:Hidden ID="FormatType" runat="server" />


InStore
*****************
OnSubmitData="Store1_Submit"




<TopBar>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<ext:ToolbarFill ID="ToolbarFill1" runat="server" />


<ext:Button ID="Button3" runat="server" Text="To Excel" Icon="PageExcel">
<Listeners>
<Click Handler="submitValue(#{GridPanel1}, #{FormatType}, 'xls');" />
</Listeners>
</ext:Button>


</Items>
</ext:Toolbar>
</TopBar>