Hi,
I'm trying to export a dataset to excel directly. I'm repeating, it's a dataset to excel (NOT DATA GRID OR GRID VIEW TO EXCEL). The problem I face is formatting. I'm exporting the excel which has aroung 13 columns.
A column should be in dd/MM/yyyy 00:00:00 format. Time will always be 00:00:00. It is exporting in correct format only, but for example when the date is Jan 05, 2010, when it comes from database it shows correct format as 05/01/2010 00:00:00. When it binds, it binds as 5/1/2010 00:00 which is not suppose to happen.
And the other problem is with the decimal formatting. I need 2 decimal places at the last. In c# code, I'm converting to decimal with 2 decimal places, but when it binds, it won't happen. I tried inserting a ' (colon) before the text is entered, but the cell is not converted into a text field 
Can anyone give me a solution for this?
View Complete Post