NPOI是Excel的优秀操作类库,就不多说了。直接上代码,记录一下这段代码
方法一:读取Excel
/// <summary>
/// Excel转换成DataTable(.xls)
/// </summary>
/// <param name="filePath">Excel文件路径</param>
/// <returns></returns>
public static DataTable ExcelToDataTable(string filePath,bool firstRowHeader)
{
var dt = new DataTable();
using (var file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
{
//根据文件名判断excel版本,创建workbook
IWorkbook hssfworkbook = null;
if (filePath.ToLower().IndexOf(".xlsx") > 0)
{
hssfworkbook = new XSSFWorkbook(file);
}
else
{
hssfworkbook = new HSSFWorkbook(file);
}
var sheet = hssfworkbook.GetSheetAt(0);
//表头
int startIndex = 0;// sheet.FirstRowNum;
int lastIndex = sheet.LastRowNum;
if (firstRowHeader)
{
startIndex = 1;
var row = sheet.GetRow(0);
for (int i = 0; i < row.LastCellNum; i++)
{
I