6 Answers, 1 is accepted
0
Mike
Top achievements
Rank 1
answered on 31 Oct 2014, 05:34 PM
Also, for the page setup is it possible to make the top row repeat on the top of each page when printing?
I figured how to freeze the top pane, but that doesn't take affect when printing.
I figured how to freeze the top pane, but that doesn't take affect when printing.
0
Hello,
I am afraid that exporting of images are supported only when Biff or XLSX format is used but this export formats do not support headers and footer. You can export header only if you are using an HTML as described in the following help article.
Regards,
Kostadin
Telerik
I am afraid that exporting of images are supported only when Biff or XLSX format is used but this export formats do not support headers and footer. You can export header only if you are using an HTML as described in the following help article.
Regards,
Kostadin
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Mike
Top achievements
Rank 1
answered on 05 Nov 2014, 04:27 PM
You can also create headers and footers using ExcelML too: http://www.telerik.com/help/aspnet-ajax/grid-excelml-export.html
That's what I'm using.
Could you take a look at my other question too? "For the page setup is it possible to make the top row repeat on the top of each page when printing?". This is for ExcelML too.
That's what I'm using.
Could you take a look at my other question too? "For the page setup is it possible to make the top row repeat on the top of each page when printing?". This is for ExcelML too.
0
Hi Mike,
Please excuse me for misleading you in my previous reply. You can export header and footer but you can not add an image in it. If you need a header and footer that will be displayed on each print page then you have to access the PageHeaderElement and PageFooterElement on ExcelMLWorkBookCreated event handler and assign a value on the Data property. Please check out the following code snippet.
Regards,
Kostadin
Telerik
Please excuse me for misleading you in my previous reply. You can export header and footer but you can not add an image in it. If you need a header and footer that will be displayed on each print page then you have to access the PageHeaderElement and PageFooterElement on ExcelMLWorkBookCreated event handler and assign a value on the Data property. Please check out the following code snippet.
protected
void
RadGrid1_ExcelMLWorkBookCreated(
object
sender, Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e)
{
e.WorkBook.Worksheets[0].WorksheetOptions.PageSetup.PageHeaderElement.Data =
"The page header."
;
e.WorkBook.Worksheets[0].WorksheetOptions.PageSetup.PageFooterElement.Data =
"The page footer."
;
}
Regards,
Kostadin
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Mike
Top achievements
Rank 1
answered on 10 Nov 2014, 01:18 PM
Yes, I know how to add the header and footer. I'm looking to show the top row on each page (different than header). This would be the top row which has the column headings (please see attached screenshot). If this is not an option in ExcelML, is it an option in any of the other Excel exports?
Also, can images be added to the header in other formats, like HTML? If so, can you provide an example? Thanks.
Also, can images be added to the header in other formats, like HTML? If so, can you provide an example? Thanks.
0
Hello Mike,
I am afraid that you can not set Row to repeat option with any of the supported excel formats. Nevertheless if you need to display the grid header item on each page you can add the same data on PageHeaderElement and hide the header by setting ShowHeader property to false.
Note that image exporting is supported only by Biff and XLSX formats but none of them provide an option to export page header and footer.
Regards,
Kostadin
Telerik
I am afraid that you can not set Row to repeat option with any of the supported excel formats. Nevertheless if you need to display the grid header item on each page you can add the same data on PageHeaderElement and hide the header by setting ShowHeader property to false.
Note that image exporting is supported only by Biff and XLSX formats but none of them provide an option to export page header and footer.
Regards,
Kostadin
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.