I have attached a file with an Excel worksheet created by 1 of my users. It is reporting invalid data. He purposely tried to break but it still needs to be corrected.
Here is my code:
private void ExportExcelWorksheet(string fileName) { var export = new DataPresenterExcelExporter(); var tab = (TabItem)Common.MainTabControl.SelectedItem; var dg = (XamDataGrid)tab.Content; export.Export(dg, fileName, WorkbookFormat.Excel2007); }
Hello,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. So I have been looking through you post and the file you attached and it seems like I a missing something, because without a sample and expected results I am not able to conclude if the data is invalid. Could you please provide me with an isolated sample project and some information about expected results if this is still an issue for you, so I can investigate it further for you.
Feel free to write me if you have further questions.
Close the ticket. I don't remember the problem since it was a year ago.