C# 引用interop.excel操作EXCEL拾要

在开始之前，需要引用using Microsoft.Office.Interop.Excel;
顺便 Using Excel=Microsoft.Offic.Interop.Excel;
一.新建Excel

Excel.Application xpp=new Excel.Application();
Excel.Workbook wb=xpp.Workbooks.Add();
Excel.Worksheet wsh=wb.Worksheets[1];

二.从固定路径打开Excel

Excel.Application xpp=new Excel.Application();
string path="C:\\test.xlsx";
Excel.Workbook wb=xpp.Workbooks.Open(path);
Excel.Worksheet wsh=wb.Worksheets[1];

三.保存与另存为Excel

wk.Save();
wk.Close();
xpp.Quit();
``
```csharp
string path="C:\\test.xlsx";
wk.SaveAs(path);
wk.Close();
xpp.Quit();

四.获取worksheet有内容的最后一行

int lastrow=wsh.usedrange.CurrentRegion.Rows.Count;