1. 复制DLL文件
ICSharpCode.SharpZipLib.dll
NPOI.dll
NPOI.OOXML.dll
NPOI.OpenXml4Net.dll
NPOI.OpenXmlFormats.dll
2. 在工程中添加引用
3.
using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.XSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.OpenXml4Net;
4. 操作EXCEL
private void button2_Click(object sender, EventArgs e)
{
string strFileName;
FileStream fs;
string strTemp;
IWorkbook myBook = null;
ISheet mySheet = null;
strFileName = @"H:\流水_2021.7-2021.12.xlsx";
fs = File.OpenRead(strFileName);
/*
xlsx版本,需要是 new XSSFWorkBook
xls版本,需要是 new