NPOI 数据导入导出

{
//数据导入
            OpenFileDialog open = new OpenFileDialog();
            open.Filter = "Excle文件|*.xls";
            open.Title="导入数据....";
          
            if (open.ShowDialog() != true)
            {
                return;
            }
            else
            {
                string filename = open.FileName;
                using (Stream stream = File.OpenRead(filename))
                {
                    HSSFWorkbook booke = new HSSFWorkbook(stream);
                    ISheet sheet = booke.GetSheetAt(0);
                    DataTable table = new DataTable();
                    table.Columns.Add("Name");
                    table.Columns.Add("Age");
                    table.Columns.Add("Indate");
                  //  DataRow row = new DataRow();
                    //  row["Name"]=

                  
                    for(int i=1;i< sheet.LastRowNum;i++)
                    {
                        IRow HssRow=sheet.GetRow(i);
                        DataRow row = table.NewRow();
                       row["Name"] = HssRow.GetCell(0).StringCellValue;
                        if (HssRow.GetCell(1).CellType == CellType.NUMERIC)
                        {
                            row["Age"] = HssRow.GetCell(1).NumericCellValue;
                        }
                      
                        else if (HssRow.GetCell(1).CellType == CellType.STRING)
                        {
                            row["Age"] = Convert.ToInt32(HssRow.GetCell(1).NumericCellValue);
                        }
                        else
                        {
                            MessageBox.Show("数据类型出错");
                            return;
                       }
                        if (HssRow.GetCell(2).CellType == CellType.NUMERIC)
                        {
                        row["Indate"] =(DateTime) HssRow.GetCell(2).DateCellValue;}
                        table.Rows.Add(row);
                 }
                    TODB(table);
                }
          

              
            }
        }

        public void TODB(DataTable table)
        {
            using (SqlBulkCopy copy = new SqlBulkCopy("Password=HRMSys;Persist Security Info=True;User ID=HRMSys;Initial Catalog=HRMSys;Data Source=."))
            {
                copy.DestinationTableName = "T_Tex";
                copy.ColumnMappings.Add("Name","Name");
                copy.ColumnMappings.Add("Age", "Age");
                copy.ColumnMappings.Add("Indate", "Indate");
                if (table == null)
                {
                    MessageBox.Show("Table 参数为空", "错误提示" );
              return;
                }
                copy.WriteToServer(table);
                MessageBox.Show("数据导入成功","消息提示框");
                refashush();
            }
        }