public static DataTable Import(string strFileName)

        {

            DataTable dt = new DataTable();

            HSSFWorkbook hssfworkbook;

            using (FileStream file = new FileStream(strFileName, FileMode.Open, FileAccess.Read))

            {

                hssfworkbook = new HSSFWorkbook(file);

            }

            ISheet sheet = hssfworkbook.GetSheetAt();

            System.Collections.IEnumerator rows = sheet.GetRowEnumerator();

            IRow headerRow = sheet.GetRow();

            int cellCount = headerRow.LastCellNum;

            for (int j = ; j < cellCount; j++)

            {

                ICell cell = headerRow.GetCell(j);

                dt.Columns.Add(cell.ToString());

            }

            for (int i = (sheet.FirstRowNum + ); i <= sheet.LastRowNum; i++)

            {

                IRow row = sheet.GetRow(i);

                DataRow dataRow = dt.NewRow();

                for (int j = row.FirstCellNum; j < cellCount; j++)

                {

                    if (row.GetCell(j) != null)

                    {

                        //如果是公式Cell

                        //则仅读取其Cell单元格的显示值 而不是读取公式

                        if (row.GetCell(j).CellType == CellType.Formula)

                        {

                            row.GetCell(j).SetCellType(CellType.String);

                            dataRow[j] = row.GetCell(j).StringCellValue;

                        }

                        else

                        {

                            dataRow[j] = row.GetCell(j).ToString();

                        }

                    }

                }

                dt.Rows.Add(dataRow);

            }

            return dt;

        }