How to change the excel shet column as Date Type through C#

Arun Kumar posted at 08-May-08 08:26
    Hi,
By default column of excel sheet are of Number Type and i want to change particular column as Date Type from C#.

I am using winform application in which i am exporting grid data to excel sheet.
columns are : Part, Price, Quantity and Date of Purchase.
once i have exported the data in the excel sheet , I want to change column 'Date of Purchased' as Date Type Column.

This is required because on the exported sheet user can apply the formula for calculation.

Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  How to change the excel shet column as Date Type through C# - Arun Kumar  08-May-08 08:26 8:26:04 AM
      using Range.NumberFormat - sundar k  08-May-08 09:11 9:11:02 AM
          Re: Sundar - Arun Kumar  09-May-08 06:44 6:44:29 AM
              using Range.EntireColumn - sundar k  09-May-08 11:21 11:21:00 PM
      excel shet column - Rakesh Vikram  19-May-08 06:48 6:48:22 AM
View Posts