Hello Everyone,

Can anyone tell me how to export the grid to excel which will show in multiple sheets. Like for eg. If I have 1000 rows in my grid i want to show 50 rows in sheet1 and anthr 50 in sheet 2 and so on.

I am new to Infragistics and my project manager wants the above feature. Please suggest me some soln.

I had written the following code:

protected void btnExporttoExcel_Click(object sender, ImageClickEventArgs e)
    {      
        // trigger export      
        UltraWebGridExcelExporter1.DownloadName = "abc.xls";
        UltraWebGridExcelExporter1.Export(ultrawebgrid1);       
  }

and I had handled this event.

protected void UltraWebGridExcelExporter1_BeginExport(object sender, Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e)
    {

   }

regards,

Sumeet Shinde.