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

RadGrid ExcelML Export - Image in Header?

6 Answers 104 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 31 Oct 2014, 12:31 PM
Is it possible to add/embed an image into the header of the spreadsheet that's created with ExcelML? I'd just like to add a logo into the header and haven't been able to find if it's possible with ExcelML. Thanks!

6 Answers, 1 is accepted

Sort by
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.
0
Kostadin
Telerik team
answered on 05 Nov 2014, 07:50 AM
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
 

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.
0
Kostadin
Telerik team
answered on 10 Nov 2014, 10:07 AM
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.
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.

0
Kostadin
Telerik team
answered on 13 Nov 2014, 12:28 PM
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
 

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.

 
Tags
Grid
Asked by
Mike
Top achievements
Rank 1
Answers by
Mike
Top achievements
Rank 1
Kostadin
Telerik team
Share this question
or