如何使用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";

 

 
posted @ 2022-09-17 15:34  内心澎湃的水晶侠  阅读(267)  评论(0编辑  收藏  举报