This is a migrated thread and some comments may be shown as answers.

Add Page Level Header in Export

1 Answer 21 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 12 Nov 2013, 05:15 PM
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

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 15 Nov 2013, 11:50 AM
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.
Tags
PivotGrid
Asked by
Daniel
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or