Excel Instance


New Project, Console Application
References, Add Reference, Assemblies > Extensions
Add "Microsoft.Office.Interop.Excel"
Add the following code:

using Excel = Microsoft.Office.Interop.Excel; 

try
{
   Excel.Application oExcelApplication;
   Excel.Workbook oWorkbook;
   Excel.Worksheet oWorksheet;

   oExcelApplication = new Excel.Application();
   oExcelApplication.Visible = true;
   oWorkbook = oExcelApplication.Workbooks.Add();
   oWorksheet = oWorkbook.Sheets[1];
   oWorksheet.Name = "New Worksheet";

   for (long lRowNo = 1; lRowNo < 6; lRowNo++)
   {
      oWorksheet.get_Range("A" + lRowNo).Value = lRowNo * 10;
   }
   oWorksheet.get_Range("A" + 6).Formula = "=SUM(A1:A5)";
   oWorkbook.SaveAs(@"C:\temp\MyFile.xlsx");

   oExcelApplication.Quit();
}
catch(System.Runtime.InteropServices.COMException ex)
{
   System.Console.WriteLine(ex.ErrorCode.ToString() + " - " + ex.Message);
}

Select (Build > Build Solution)
Run



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext