how to make header bold while export to excel

[Gopinath]

Hi,

I need to make the header text to bold while exporting Grid to excel.

In my page ,there no Grid control.
So to use export option of Grid , i have created a dynamic Grid Control and binding the data to it. 

As per requirements, i need to provide show-dialog box with a  default name (user can change name if he wants)

Below is my code

             AuthGridView authGridView = new AuthGridView();
            authGridView.AutoGenerateColumns = true;
            authGridView.ItemsSource = this.searchResults;

            SaveFileDialog dialog = new SaveFileDialog();
            dialog.DefaultExt = "*.xls";
            dialog.Filter = "Excel files (*.xls)|*.xls";
            dialog.DefaultFileName = DateTime.Now.ToString("yyyyMMddHHmmss");

            if (dialog.ShowDialog() == true)
            {
                using (Stream stream = dialog.OpenFile())
                {
                    GridViewExportOptions exportOptions = new GridViewExportOptions();
                    exportOptions.Format = ExportFormat.ExcelML;
                    exportOptions.ShowColumnFooters = true;
                    exportOptions.ShowColumnHeaders = true;
                    exportOptions.ShowGroupFooters = true;      

                    authGridView.Export(stream, exportOptions);
                }
            }

[Pavel Pavlov]

Hi,

You can tamper with the exported content form within the ElementExporting event handler.

Kind regards,
Pavel Pavlov
the Telerik team

[Gopinath]

thanks a lot it solved my issue!!!

[Swetha]

Hi Telerik Team,

I have a table with htmltextbox in the column cells. I want to display certain texts in the table in Bold letters.
I inserted <B> </B> tags for those rows in the table and it worked fine in pdf.
But the htmltextbox is not displaying those rows in bold in Excel.

Can you please help me on this?

[Swetha]

I got it done. I applied a formatting rule for that particular columns and rows.

[Darshan]

The exact code you can use for this is below.

private static void ElementExportingToDocument(object sender, GridViewElementExportingToDocumentEventArgs e)
        {
            if (e.Element == ExportElement.HeaderRow)
            {
                (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle()
                {
                    FontSize = 16,
                    IsBold = true,
                    //Fill = new PatternFill(PatternType.Solid, Colors.Blue, Colors.Blue),
                    //ForeColor = new ThemableColor(Colors.White)
                };
            }
        }