Hi.
I have an object with a property of type char like this:
When binding a grid to a list of this objects the values in the char property are displayed correctly in a grid column.
But when I export the grid using ExcelML the column in Excel comes up empty.
Doesn't ExcelML support exporting the char datatype?
I have an object with a property of type char like this:
public class DummyModel { public string Stringtest { get; set; } public char Chartest { get; set; } }When binding a grid to a list of this objects the values in the char property are displayed correctly in a grid column.
But when I export the grid using ExcelML the column in Excel comes up empty.
Doesn't ExcelML support exporting the char datatype?
2 Answers, 1 is accepted
0
Hello,
Due to Easter observations, we are currently operating with limited resources until May 7th. We will get back to you as soon as possible. Please excuse us for the introduced inconvenience.
Regards,
Stefan
the Telerik team
Due to Easter observations, we are currently operating with limited resources until May 7th. We will get back to you as soon as possible. Please excuse us for the introduced inconvenience.
Regards,
Stefan
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
0
Hello Tord,
Please excuse me for the delayed reply. I managed to miss this thread somehow.
To answer your question, the char data type is not recognized by Excel and this is why it is not displayed. To hand this case, you can use the ExcelCellFormatting event of the exporter, where you can convert the char to string in the exported document:
I hope that you find this useful. Once again, excuse me for the delay.
Regards,
Stefan
Telerik
Please excuse me for the delayed reply. I managed to miss this thread somehow.
To answer your question, the char data type is not recognized by Excel and this is why it is not displayed. To hand this case, you can use the ExcelCellFormatting event of the exporter, where you can convert the char to string in the exported document:
void radButton1_Click(object sender, EventArgs e){ ExportToExcelML exporter = new ExportToExcelML(this.radGridView1); string fileName = "C:\\ExportedData123.xls"; exporter.ExcelCellFormatting += exporter_ExcelCellFormatting; exporter.RunExport(fileName); Process.Start("C:\\ExportedData123.xls");}void exporter_ExcelCellFormatting(object sender, Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventArgs e){ e.ExcelCellElement.Data.DataItem = Convert.ToString(e.GridCellInfo.Value);}I hope that you find this useful. Once again, excuse me for the delay.
Regards,
Stefan
Telerik
RadChart for WinForms is obsolete. Now what?