读取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);
}
}
}
}