Export whole page to Excel with infragistics in ASP.NET C#

Override the render for the ASP.NET page. Look through all the controls (See my other tiptrick for iterating controls). Notes:

• You will probably need to handle itemtemplates in your grid/details views if you use anything other than a string literal.
• I put all detailsViews on the first page and grids on their own worksheet as that was my need but you probably won't want it exactly that way.

Note: Utilities.FindControls is located here: Findcontrol using a non recursive approach with no new fangled crap.[^]

 protected override void Render(HtmlTextWriter writer)
    {
        base.Render(writer);
        
        Workbook workBook = new Workbook();
        List<control> controlList = Utilities.FindControls(this);
        int detailsRowStart = 0;
        Worksheet detailsSheet = workBook.Worksheets.Add("Details");
        detailsSheet.Columns[0].Width = 8000;
        foreach (var item in controlList )
        {
            if (item.GetType() == typeof(GridView))
            {
                Utilities.RenderControlInExcel((GridView)item, workBook);
            }
            if (item.GetType() == typeof(DetailsView))
            {
                detailsRowStart = Utilities.RenderControlInExcel((DetailsView)item, detailsSheet, detailsRowStart);
            }
        }

        ExcelExporter.WriteToResponse(workBook,String.Format( "report{0}.xls", Guid.NewGuid().ToString()), Response);
    }

Render the gridview detailsview:

    public static void RenderControlInExcel(GridView view, Workbook book)
    {

        if (view.Rows.Count == 0 || view.Columns.Count==0)
        {
            return;
        }
        
        Worksheet workSheet = book.Worksheets.Add(view.ID);

        for (int i = 0; i < view.Columns.Count; ++i)
        {
            WorksheetCell cell = workSheet.Rows[0].Cells[i];
            cell.Value = view.Columns[i].HeaderText;
            cell.CellFormat.Font.Bold =ExcelDefaultableBoolean.True;
        }

        const int HeaderOffset = 1;
        // Add one row for header columns
        for (int row = 0; row < view.Rows.Count; ++row)
        {
            for (int col = 0; col < view.Columns.Count; ++col)
            {
                int destRow = row + HeaderOffset;
                try
                {
                    if (view.Rows[row].Cells[col].Controls.Count > 0)
                    {
                        if (view.Rows[row].Cells[col].Controls[0].GetType() == typeof(DataBoundLiteralControl))
                        {
                            workSheet.Rows[destRow].Cells[col].Value = ((System.Web.UI.DataBoundLiteralControl)(view.Rows[row].Cells[col].Controls[0])).Text.Trim();
                        }
                    }
                    else
                    {
                        if (view.Rows[row].Cells[col].Text == " ")
                        {
                            continue;
                        }
                        workSheet.Rows[destRow].Cells[col].Value = view.Rows[row].Cells[col].Text;
                    }
                }
                catch
                {
                    workSheet.Rows[destRow].Cells[col].Value = "Error";
                }
            }
        }
    }
}

 public static int RenderControlInExcel(DetailsView view, Worksheet workSheet, int rowStart )
    {

        if (view.Rows.Count == 0 )
        {
            return rowStart;
        }
       
        // Add A space up front in case we are the second detailsview printing
        ++rowStart;
        WorksheetCell cell = workSheet.Rows[rowStart].Cells[0];
        cell.Value = view.HeaderRow.Cells[0].Text;
        cell.CellFormat.Font.Bold = ExcelDefaultableBoolean.True;
        // Add a space to put the cursor past the header row
        ++rowStart;

        for (int row=0; row < view.Rows.Count; ++row)
        {
            for (int col = 0; col <view.rows[row].cells.count;>            {
                int destRow = rowStart + row;
                if (view.Rows[row].Cells[col].Controls.Count > 0)
                {
                    if (view.Rows[row].Cells[col].Controls[0].GetType() == typeof(DataBoundLiteralControl))
                    {
                        workSheet.Rows[destRow].Cells[col].Value = ((System.Web.UI.DataBoundLiteralControl)(view.Rows[row].Cells[col].Controls[0])).Text.Trim();    
                    }
                }
                else
                {
                    if (view.Rows[row].Cells[col].Text == " ")
                    {
                        continue;
                    }
                    workSheet.Rows[destRow].Cells[col].Value = view.Rows[row].Cells[col].Text;
                }
            }
        }

        // Set the start of the next grid.
        rowStart += view.Rows.Count;
        return rowStart;
    }

Write with infragistics Excel object (could be rewritten easily).

    /// <summary>
    /// This helper function will take an Excel Workbook 
    /// and write it to the response stream. In this fashion, 
    /// the end user will be prompted to download or open the
    /// resulting Excel file. 
    /// 
    /// 
    /// 
    /// 
    public static void WriteToResponse(Workbook theWorkBook, string FileName, HttpResponse resp)
    {
        //Create the Stream class
        System.IO.MemoryStream theStream = new System.IO.MemoryStream();

        if (theWorkBook.Worksheets.Count == 0)
        {
            return;
        }
        //Write the in memory Workbook object to the Stream
        BIFF8Writer.WriteWorkbookToStream(theWorkBook, theStream);

        //Create a Byte Array to contain the stream
        byte[] byteArr = (byte[])Array.CreateInstance(typeof(byte), theStream.Length);

        theStream.Position = 0;
        theStream.Read(byteArr, 0, (int)theStream.Length);
        theStream.Close();

        resp.Clear();

        resp.AddHeader("content-disposition", "attachment; filename=" + FileName);

        resp.BinaryWrite(byteArr);

        resp.End();
    }