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
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
0
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
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.