Add head title on Excel GridView Export

[Sami]

Hi, I have an application which uses GridView Exporting to excel. It works fine, and I want to add a Head Title on the Excel File, but when I put The Head Title, the Unicode Encoding or UTF8 Encoding doesn't work, this is my code:

if (dialog.ShowDialog() == true)
            {
                using (Stream stream = dialog.OpenFile())
                {
                    GridViewExportOptions exportOptions = new GridViewExportOptions();
                    exportOptions.Format = format;
                    exportOptions.ShowColumnFooters = false;
                    exportOptions.ShowColumnHeaders = true;
                    exportOptions.ShowGroupFooters = false;
                    exportOptions.Encoding = Encoding.UTF8;



                    String unicodeString = "Título de la Aplicación\n";
                    unicodeString = unicodeString + "Sub Título de la Aplicación";
                    Encoding unicode = Encoding.Unicode;
                    byte[] unicodeBytes = unicode.GetBytes(unicodeString);
                    stream.Write(unicodeBytes, 0, unicodeBytes.Length);
                    gridExport.Export(stream, exportOptions);

                }
            }

Could you help me please...

Thanks in advanced...

[Ivan Ivanov]

Hello Sami,

I have just posted an answer in the other thread you have opened. In order to achieve a fruitful and consistent dialogue, I would kindly ask you to carry out any further communication there.

Best wishes,
Ivan Ivanov
the Telerik team

[Sami]

Hi, I have read the answer in the support ticket, really good answer, that's what I wanted... 

Thank you very much
Sami

[Richard]

I'd love to see the response that you gave to SAMI, but I can't find it.  It sounds like this is the answer to my questions too, but what's the link?

Thanks!

[Ivan Ivanov]

Hello Richard,

I am attaching the example project.

Kind regards,
Ivan Ivanov
the Telerik team

[Richard]

I needed to add some info above the header line, so I used this and it created a new line between the title and the headers

byte[] title = Encoding.UTF8.GetBytes("Exporting EXCEL!" + System.Environment.NewLine);

Thanks for your quick reply with the code example.

[Leandro]

I am using your example but when I use:
exportOptions.Encoding = System.Text.Encoding.Unicode;

it doesn't work!

how can I solve this problem?

Thanks,
Leandro Christen