DEV GridControl导入导出Excel文件 - 简单表格数据导入(NPOI方式一)

1、命名空间

using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.POIFS.FileSystem;
using NPOI.XSSF.UserModel;

2、代码

public System.Data.DataTable ImportExcel(string strFileName)
        {
            try
            {
                System.Data.DataTable dt = new System.Data.DataTable();

                HSSFWorkbook hssfworkbook;//.xls
                //XSSFWorkbook hssfworkbook;//.xlsx
                using (FileStream file = new FileStream(strFileName, FileMode.Open, FileAccess.Read))
                {
                    hssfworkbook = new HSSFWorkbook(file);//.xls
                    //hssfworkbook = new XSSFWorkbook(file);//.xlsx
                }
                ISheet sheet = hssfworkbook.GetSheetAt(0);
                System.Collections.IEnumerator rows = sheet.GetRowEnumerator();

                IRow headerRow = sheet.GetRow(0);
                int cellCount = head