一、引入包(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();