学步园

    public DataTable ImportExcelFile(string filePath)
    {
        HSSFWorkbook hssfworkbook;
        #region//初始化信息
        try
        {
            using (FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
            {
                 hssfworkbook = new HSSFWorkbook(file);
            }
        }
        catch (Exception e)
        {
            throw e;
        }
        #endregion

        Sheet sheet = hssfworkbook.GetSheetAt(0);//读取第一张表（Sheet）
        System.Collections.IEnumerator rows = sheet.GetRowEnumerator();

        DataTable dt = new DataTable();

        //一行最后一个方格的编号 即总的列数
        for (int j = 0; j < (sheet.GetRow(0).LastCellNum); j++)
        {
            dt.Columns.Add(Convert.ToChar(((int)'A') + j).ToString());
        }

        while (rows.MoveNext())
        {
            Row row = (Row)rows.Current;
            DataRow dr = dt.NewRow();

            for (int i = 0; i < row.LastCellNum; i++)
            {
                Cell cell = row.GetCell(i);

                if (cell == null)
                {
                    dr[i] = null;
                }
                else
                {
                    dr[i] = cell.ToString();
                }
            }
            dt.Rows.Add(dr);
        }
        return dt;
    }

本文nopi版本下载地址：http://download.csdn.net/detail/aiminxmpp/5796009