一、下载引用
下载需要引用的dll,即:NPOI.dll,NPOI.OOXML.dll,NPOI.OpenXml4Net.dll,ICSharpCode.SharpZipLib.dll(office2007版需要此dll)。
程序集下载地址:点击打开链接
二、excel转datatable类
- using System;
- using System.Data;
- using System.IO;
- using NPOI.SS.UserModel;
- using NPOI.XSSF.UserModel;
- using NPOI.HSSF.UserModel;
- namespace NPOIOprateExcel
- {
- public class ExcelUtility
- {
- /// <summary>
- /// 将excel导入到datatable
- /// </summary>
- /// <param name="filePath">excel路径</param>
- /// <param name="isColumnName">第一行是否是列名</param>
- /// <returns>返回datatable</returns>
- public static DataTable ExcelToDataTable(string filePath, bool isColumnName)
- {
- DataTable dataTable = null;
- FileStream fs = null;
- DataColumn column = null;
- DataRow dataRow = null;
- IWorkbook workbook = null;
- ISheet sheet = null;
- IRow row = null;
- ICell cell = null;
- int startRow = 0;
- try
- {
- using (fs = File.OpenRead(filePath))
- {
- // 2007版本
- if (filePath.IndexOf(".xlsx"<