using Range.NumberFormat |
| sundar k replied to Arun Kumar at 08-May-08 09:11 |
lets say you want to set the Row 1, Col1 cell datatype to Date, then below code can help you out to set the cell datatype to date format,
Excel.Range rg = (Excel.Range)worksheetobject.Cells[1,1]; rg.NumberFormat = "MM/DD/YYYY";
|
|