Export Aggregated Data to Excel

1 posts, 0 answers
  1. Mark Galbreath
    Mark Galbreath avatar
    171 posts
    Member since:
    Jul 2009

    Posted 02 Dec 2009 Link to this post

    Requirements

    RadControls version

    2009_2_1028

    .NET version

    3.5

    Visual Studio version

    2008

    programming language

    VB

    browser support

    all browsers supported by RadControls


    PROJECT DESCRIPTION
    Several persons, including me, were asking in the forum how to export multiple grids displayed in the view to a single Excel worksheet.  Daniel presented a trivial example that was not practical, but it did serve as the foundation of the code I developed the following day.  My requirement was to aggregate all the data displayed in a webform and export it to Excel.  The data consists of 4 HTML tables dynamically populated by ASP labels in the code-behind, and 4 different RadGrids, each one displaying a dataset from a different database table having different schemas.  To accomplish this, I stuck a skeleton radGrid tag on the webform and wrote 2 essential methods in the code-behind (2 others are just the Excel formatting methods).  I have attached list_LIN_detail.aspx (see the radgrid tag at the bottom under the export button) and list_LIN_detail.aspx.vb (see the methods towards the end of the code obviously commented for this subject).  The Excel column headers are the radGrid's unique names.

    One caveat: there is a bug that throws an IllegalOperationException when ASP label text is nothing and it needs to be cast to an integer.  No big deal.
Back to Top