如何使用c#操作Excel

Microsoft.Office.Core.dll 是可以在VS里面引用COM 可以直接找到使用

C:\Program Files (x86)\Microsoft Visual Studio\Shared\Visual Studio Tools for Office\PIA\Office15

Microsoft.Office.Interop.Excel.dll

using Excel = Microsoft.Office.Interop.Excel;
 var excelApp = new Excel.Application();

    excelApp.Visible = true;
    excelApp.Workbooks.Add();
    Excel._Worksheet workSheet = (Excel.Worksheet)excelApp.ActiveSheet;

workSheet.Cells[1, "A"] = "ID Number";
workSheet.Cells[1, "B"] = "Current Balance";