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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

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