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

1、命名空间

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

2、代码

public DataSet ImportExcelTest(string filePath)
        {
            DataSet ds = null;

            try
            {
                //打开文件
                FileStream fileStream = new FileStream(filePath, FileMode.Open);

                //.xls
                HSSFWorkbook workbook = new HSSFWorkbook(fileStream);
                //.xlsx
                //XSSFWorkbook workbook = new XSSFWorkbook(fileStream);

                ISheet sheet = null;
                IRow row = null;

                ds = new DataSet();
                System.Data.DataTable dt = null;

                for (int i = 0; i < workbook.Count; i++)
                {
                    dt = new System.Data.DataTable();