C# Excel操作方法

一、引入包(EPPlus)

二、读写单元格值

//设置文件名称
string file_name = "D:\\XinSteel\\项目文件\\17、十大新闻评选\\数据源2.xlsx";

//指明非商业应用
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

//加载Excel工作簿
ExcelPackage package = new ExcelPackage(file_name);

//读取工作簿中名为"Sheet1"的工作表
ExcelWorksheet sheet1 = package.Workbook.Worksheets[0];
int count = 0;
for(int i = 2; i <= sheet1.Rows.Count(); i++)
{
    //读取单元格值
    string tp_value = sheet1.Cells[i, 3].Value.ToString();
    count = 0;
    for(int j = 0; j < xw_list.Count; j++)
    {
        string xw = xw_list[j];
        if (tp_value.Contains(xw))
        {
            count++;
        }

    }

    //写入单元格值
    sheet1.Cells[i, 15].Value = count.ToString();
    Console.WriteLine("计算到第" + i.ToString() + "行！");
}

//保存工作簿
package.Save();