Sheik Alavudeen
Top achievements
Rank 1
Rank 1
Sheik Alavudeen
asked on 24 Jul 2010, 03:20 PM
Hi,
I need to add the Company Logo for each grid export options. In footer of report, we need to show the User Name and Page Info and Printed Date and Time for each page of the data report. I tried with the below method. but its not working.
Will you please help me to implement the Export for PDF, CSV, WORD, EXCEL with Header of Logo and Footer of Report Info in each page.
We are in implementation time. your immediate solution will help us.
Regards,
Sheik
I need to add the Company Logo for each grid export options. In footer of report, we need to show the User Name and Page Info and Printed Date and Time for each page of the data report. I tried with the below method. but its not working.
protected
void gridSalaryInfo_GridExporting(object source, Telerik.Web.UI.GridExportingArgs e)
{
string customHTML = "<table><tr><td><asp:Image ID='Image1' runat='server' ImageUrl='~/images/KIB_LOGO.png' AlternateText='KIB' Width='100%' /></td></tr></table>";
e.ExportOutput = e.ExportOutput.Replace(
"<body>", String.Format("<body>{0}", customHTML));
}
Will you please help me to implement the Export for PDF, CSV, WORD, EXCEL with Header of Logo and Footer of Report Info in each page.
We are in implementation time. your immediate solution will help us.
Regards,
Sheik
1 Answer, 1 is accepted
0
Hello Sheik,
The CSV format doesn't support headers and footers at all.
For ExcelML - headers and footers are supported out-of-the-box
ExcelML structure / GridExcelBuilder
For HTML Excel:
Word and PDF - You could insert text in the beginning and the end of the output but it is not possible to add headers and footers on every page as it is possible in the Excel formats.
Please note that only the PDF format can handle images.
PDF export
Regards,
Daniel
the Telerik team
The CSV format doesn't support headers and footers at all.
For ExcelML - headers and footers are supported out-of-the-box
ExcelML structure / GridExcelBuilder
For HTML Excel:
protected void RadGrid1_GridExporting(object source, GridExportingArgs e){ if (e.ExportType == ExportType.Excel) { string header = "My Header"; string footer = "My Footer"; string css = String.Format("<style> table @page {{ mso-header-data:\"{0}\"; mso-footer-data:\"{1}\"; }}</style>", header, footer); e.ExportOutput = e.ExportOutput.Replace("<head>", "<head>" + css); }}Word and PDF - You could insert text in the beginning and the end of the output but it is not possible to add headers and footers on every page as it is possible in the Excel formats.
Please note that only the PDF format can handle images.
PDF export
Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items