Hi, with this Excel .NET component you can easily do this: Here is a sample Excel C# code (managed C++/CLI shouldn't be much different):

var ef = new ExcelFile();

var cell = ef.Worksheets.Add("Sheet 1").Cells[0, 0];
cell.Value = new DateTime(2010, 12, 16, 18, 17, 00);
cell.Style.NumberFormat = "mmm dd, yyyy hh:mm:ss AM/PM";

ef.SaveXls(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "DateTime.xls"));

Try with GemBox spreadsheet component. It is much faster and easier to use then Excel Automation.

You can try with GemBox spreadsheet component. It's much better way to read and write Excel file then Excel Automation.

Interop is very complicated way to work with Excel. Here you have list of reasons why to avoid Excel Interop. Try with GemBox Excel .NET component - it is much faster and easier way to work with Excel. Filip GemBox.Spreadsheet for .NET - Easily read and write Excel(XLS, XLSX, CSV or ODF) files or export to HTML files from your .NET apps.

Hi, You could try using GemBox spreadsheet component which is really easy to work with.

Hi, as d@nish said you could use System.Data.OleDb but for faster and easier work you should use some 3rd party component like GemBox spreadsheet component

Hi Sam, It could be that you haven't included Microsoft Excel 11.0 Object Library. But using Excel Automation is very complicated. Maybe you should try some 3rd party component. GemBox has .NET Excel component that makes programing with Excel in C# and VB much easier then Excel Automation. It also doesn't require you to have installed Microsoft Excel on computer that runs your application, it works with most spreadsheet files (xls,csv,xlsx,html) and it's free for commercial use if you need less then 150 rows. GemBox Software - .NET Components for Reading/Writing Excel files and Compound Document files