读取Excel文件复制值到另一个文件

 将1.xls里面的数据导入2.xls里面

 使用NPOI进行复制的操作

           using(FileStream fs = File.OpenRead("1.xls"))
           {
               using (Workbook wb = new HSSFWorkbook(fs))
               {
                   using(Workbook wb2 = new HSSFWorkbook())
                   {
                      for (int sheetIndex = 0; sheetIndex < wb.NumberOfSheets; sheetIndex++)
                      {
                          Sheet sheet = wb.GetSheetAt(sheetIndex);
                          Sheet sheet2 = wb2.CreateSheet(sheet.SheetName);
                          for (int rowIndex = 0; rowIndex <= sheet.LastRowNum; rowIndex++)
                          {
                              Row row = sheet.GetRow(rowIndex);
                              Row row2 = sheet2.CreateRow(rowIndex);
                              if (row == null)//为空直接跳过，以免下面row.LastCellNum出现空引用异常
                              {
                                  continue;
                              }
                              for (int cellIndex = 0; cellIndex < row.LastCellNum; cellIndex++)
                              {
                                  Cell cell = row.GetCell(cellIndex);
                                  Cell cell2 = row2.CreateCell(cellIndex);
                                  cell2.SetCellValue((cell==null)?" ":cell.ToString());//以免cell.ToString())为空异常
                              }
                          }
                      }
                      using (FileStream fs2 = File.OpenWrite("D:\\2.xls"))
                      {
                          wb2.Write(fs2);
                      }
                   }
               }
           }

 

转载于:https://www.cnblogs.com/kzai/archive/2012/05/06/Excel-NPOI.html