Add Page Level Header in Export

2 posts, 0 answers
  1. Daniel
    Daniel avatar
    1 posts
    Member since:
    Nov 2013

    Posted 12 Nov 2013 Link to this post

    Is it possible to add a page level header when exporting to Excel?

    What I would like to see when the PivotGrid is exported to Excel would be something along the following lines:

    ------------------------------------------------------------------------------------------------------------

                                                                                     CUSTOM REPORT HEADER

    Advanced Services Ace Continential World Corp Digital Corporate Executive Imagination
    Bulgaria Sofia Microvan $93446.4 $102791.0 $93446.4 $93446.4
    Minivan $126152.6 $130825.0 $93446.4 $88774.1
    Pickup $88774.1 $70084.8 $74757.1 $116808.0
    Truck $121480.3 $112135.7 $107463.4 $56067.8
    Van $98118.7 $102791.0 $121480.3 $121480.3
    Sofia Total $527972.2 $518627.5 $490593.6 $476576.6
    Bulgaria Total $527972.2 $518627.5 $490593.6 $476576.6
    France Paris Microvan $146225.8 $191743.7 $172310.4 $122042.0
    Minivan $107790.7 $119709.6 $124460.0 $94402.4
    Pickup $127224.0 $167991.5 $134738.4 $150976.2
    Grand Total $2786144.2 $2816203.7 $2784985.4 $2668372.7
  2. Kostadin
    Admin
    Kostadin avatar
    1708 posts

    Posted 15 Nov 2013 Link to this post

    Hello Daniel,

    In order to add additional information in the exported file you could use the ShiftRowsDown method which gives you the opportunity to insert new rows at the chosen position. Then you have simply set a value of the cell which you want to be populated with data by using the Cells collection of the table. More information on this matter could be found at the following help article. Additionally I prepared a small sample and attached it to this forum post.

    Regards,
    Kostadin
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top