Jan 22, 2014, 10:33 AM
Export to Excel for Dynamic Grid panel
Hi Guys,
I am using Dynamic Gridpanel in Button click i added Export to Excel button in top bar of Grid Panel and showing data in Grid panel successfully but if i click on Export to excel button i am getting below exception like attached screen shot
and Mycode is as follows
Model readerGrid = new Model();
//Store storeChart = new Store { ID = "storeChart", Model = { readerChart } };
Store storeGrid = new Store();
storeGrid.ID = "storeGrid";
// Ext.Net.Store storeGrid = new Ext.Net.Store { ID = "storeGrid", Model = { readerGrid } };
storeGrid.SubmitData += storeGrid_Submit;
Ext.Net.GridPanel grid = new Ext.Net.GridPanel
{
ID = "GridPanel1",
AutoDoLayout = true,
ForceFit = false,
Collapsible = true,
Width = 950,
Height = 450
};
grid.Store.Add(storeGrid);
// storeGrid.RefreshData += new Store.AjaxRefreshDataEventHandler(store_RefreshDat a); return store; }
Ext.Net.Button but=new Ext.Net.Button
{
ID="but",
Text="To Excel",
Icon=Icon.PageExcel
};
but.Listeners.Click.Handler = "submitValue(#{GridPanel1}, #{FormatType}, 'xls');";
but.DirectEvents.Click.IsUpload = true;
grid.BottomBar.Add(new PagingToolbar());
Toolbar tbr = new Toolbar();
tbr.Items.Add(but);
grid.TopBar.Add(tbr);
storeGrid.Model.Add(readerGrid);
storeGrid.DataSource = Colms;
storeGrid.DataBind();
this.Form.Controls.Add(grid);
this.Panel.Items.Add(grid);
Please suggest to solve this
Thanks In Advance
Kavitha
I am using Dynamic Gridpanel in Button click i added Export to Excel button in top bar of Grid Panel and showing data in Grid panel successfully but if i click on Export to excel button i am getting below exception like attached screen shot
and Mycode is as follows
Model readerGrid = new Model();
//Store storeChart = new Store { ID = "storeChart", Model = { readerChart } };
Store storeGrid = new Store();
storeGrid.ID = "storeGrid";
// Ext.Net.Store storeGrid = new Ext.Net.Store { ID = "storeGrid", Model = { readerGrid } };
storeGrid.SubmitData += storeGrid_Submit;
Ext.Net.GridPanel grid = new Ext.Net.GridPanel
{
ID = "GridPanel1",
AutoDoLayout = true,
ForceFit = false,
Collapsible = true,
Width = 950,
Height = 450
};
grid.Store.Add(storeGrid);
// storeGrid.RefreshData += new Store.AjaxRefreshDataEventHandler(store_RefreshDat a); return store; }
Ext.Net.Button but=new Ext.Net.Button
{
ID="but",
Text="To Excel",
Icon=Icon.PageExcel
};
but.Listeners.Click.Handler = "submitValue(#{GridPanel1}, #{FormatType}, 'xls');";
but.DirectEvents.Click.IsUpload = true;
grid.BottomBar.Add(new PagingToolbar());
Toolbar tbr = new Toolbar();
tbr.Items.Add(but);
grid.TopBar.Add(tbr);
storeGrid.Model.Add(readerGrid);
storeGrid.DataSource = Colms;
storeGrid.DataBind();
this.Form.Controls.Add(grid);
this.Panel.Items.Add(grid);
Please suggest to solve this
Thanks In Advance
Kavitha