import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.io.*;
public class Demo3 {
public static void main(String[] args) throws IOException, BiffException {
//打款人名单
String file_path1 = "C:\\Users\\11399\\Desktop\\打款人名单.xls";
String file_path2="C:\\Users\\11399\\Desktop\\result_历史变更.xls";
InputStream tab1 = new FileInputStream(file_path1);
Workbook rwb1 = Workbook.getWorkbook(tab1);
rwb1.getNumberOfSheets();
InputStream tab2 = new FileInputStream(file_path2);
Workbook rwb2 = Workbook.getWorkbook(tab2);
rwb2.getNumberOfSheets();
Sheet sheet1=rwb1.getSheet(0);
Sheet sheet2=rwb2.getSheet(1);
int rows1=sheet1.getRows();//取得表的行
int columns1=sheet1.getColumns();//取表的列
int rows2=sheet2.getRows();
int columns2=sheet2.getColumns();
String dk="";
String bg="";
String bj="";
String gs="";
for (int i = 1; i <rows1; i++) {
Cell cell1=sheet1.getCell(4,i);//先取第一张表打款人名字
Cell cell11=sheet1.getCell(0,i);
//System.out.println(cell.getContents());
dk=cell1.getContents();
//取出的打款人名字和第二张表里的变更信息作对比
bj=cell11.getContents();
// System.out.println(cell11.getContents());
for(int m=1;m<rows2;m++){
Cell cell2=sheet2.getCell(0,m);
Cell cell22=sheet2.getCell(1,m);
bg=cell2.getContents();
gs=cell22.getContents();
if(bg.indexOf(dk)!=-1){//包含
System.out.println(bj+"!!!"+gs);
break;
}
}
}
}
}
我的代码-----Excel操作
最新推荐文章于 2023-02-14 14:36:14 发布