I am facing some issue related to export to excel. I am using ImportDataTable like....
sheet.Cells.ImportDataTable(dataTable, true, "A1");
1. Date fields in Datatable are coming with whole things i.e. including time part.I need just MM/dd/YYYY value on My excel.
2. For null date type value its comming as default date value like 1999.......need to get blank in place of the default db values.
3. Some colums in my result set are description fields containg more than 500 characters. I want to implement Wrap text property with fixed width of column.
Please put your suggetion or if any samples are there for the same. If I will loop through all my rows in my result set it will create performance issue as I am exporting large # of records.