My data is being shown in RadGrid. i am trying to export data in Excel. Properties are set for the RadGrid
like
rdGridCustomer.ExportSettings.FileName = "MyDataFile";
rdGridCustomer.ExportSettings.ExportOnlyData = true;
rdGridCustomer.ExportSettings.IgnorePaging = false ;
rdGridCustomer.ExportSettings.OpenInNewWindow = true;
rdGridCustomer.ExportSettings.Excel.FileExtension = "xls";
rdGridCustomer.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;
event on that Excel is being exported.
protected void btnExport_Click(object sender, EventArgs e)
{
rdGridCustomer.MasterTableView.ExportToExcel();
}
event of Radgrid that is generated error
Index was outside the bounds of the array.
when below event is fired after btnExport_Click event error occurs. It occurs only when
rdGridCustomer.MasterTableView.ExportToExcel(); this code of line exceuted.
protected void rgModuleGrid_PreRender(object sender, EventArgs e)
{
// Institute Maximum Page Size for Main Grid
GridPagerItem pagerItem = (GridPagerItem)rdGridCustomer.MasterTableView.GetItems(GridItemType.Pager)[1];
on this above bold line error occures.
RadNumericTextBox textBox = (RadNumericTextBox)pagerItem.FindControl("ChangePageSizeTextBox");
}
please give me solution.
Thanks.
like
rdGridCustomer.ExportSettings.FileName = "MyDataFile";
rdGridCustomer.ExportSettings.ExportOnlyData = true;
rdGridCustomer.ExportSettings.IgnorePaging = false ;
rdGridCustomer.ExportSettings.OpenInNewWindow = true;
rdGridCustomer.ExportSettings.Excel.FileExtension = "xls";
rdGridCustomer.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;
event on that Excel is being exported.
protected void btnExport_Click(object sender, EventArgs e)
{
rdGridCustomer.MasterTableView.ExportToExcel();
}
event of Radgrid that is generated error
Index was outside the bounds of the array.
when below event is fired after btnExport_Click event error occurs. It occurs only when
rdGridCustomer.MasterTableView.ExportToExcel(); this code of line exceuted.
protected void rgModuleGrid_PreRender(object sender, EventArgs e)
{
// Institute Maximum Page Size for Main Grid
GridPagerItem pagerItem = (GridPagerItem)rdGridCustomer.MasterTableView.GetItems(GridItemType.Pager)[1];
on this above bold line error occures.
RadNumericTextBox textBox = (RadNumericTextBox)pagerItem.FindControl("ChangePageSizeTextBox");
}
please give me solution.
Thanks.