Align cells to export

[VP Geology]

I have the following problem in windows application.

I am creating columns by code and then adding rows. As in the following example:

textcolum dim as gridviewtexboxcolumn
textcolum = new gridviewtexboxcolumn
textcolum.fieldname = "name"
textcolum.textalignment = contentaligment.middlecenter
....
....

rowinfo = me.GRID.rows.addnew ()
rowinfo.cells (0). value = "Peter bad"

export to excel, the column name is not justified to center, as I indicated in the code, but is justified on the left.

help please!

[Emanuel Varga]

Hello,

Please be sure to set ExportVisualSettings to true, like this for pdf:

ExportToPDF exporter = new ExportToPDF(this.radGridView2);
exporter.ExportVisualSettings = true;
exporter.RunExport(@"C:\test.pdf");

but sadly for excel you have to format the cells, like so:

    ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
    exporter.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(exporter_ExcelCellFormatting);
    exporter.ExportVisualSettings = true;
    exporter.RunExport(@"C:\test.xls");
}

void exporter_ExcelCellFormatting(object sender, Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventArgs e)
{
    if (e.GridColumnIndex == 1)
        e.ExcelStyleElement.AlignmentElement.HorizontalAlignment = Telerik.WinControls.UI.Export.ExcelML.HorizontalAlignmentType.Center;
}

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

[Martin Vasilev]

Hello VP,

Emanuel has already provided you with a hint on how to use ExcelCellFormatting event to specify the text alignment. I would only like to add here that we will examine and improve the exporting alignment functionality further in order to allow for getting the alignment setting from the grid columns.

Best wishes,
Martin Vasilev
the Telerik team

[VP Geology]

Emanuel Varga

thank you for the help and collaboration.
thank you very much

[VP Geology]

Martin (admin)

thank you for the help and collaboration.
thank you very much

[Emanuel Varga]

Glad to be able to help,

If you have any more questions please just let me know, and if the question has been solved, please mark the all of the helpfull posts as answers, so that others can find the answers to their questions faster.

Best Regards,
Emanuel Varga
Telerik WinForms MVP