Java练习（四十一）---Java+POI&两个sheet页，判断id相同输出相同id的全部信息

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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
package exceltest;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;

import java.io.FileInputStream;
import java.io.IOException;

public class IdTest {
    public static void main(String[] args) {
        Test1();
    }


    public static void Test1() {
        String filepath = "D:\b.xls";
        FileInputStream fileInputStream = null;
        try {
            fileInputStream = new FileInputStream(filepath);
            HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fileInputStream);
            HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(0);
            HSSFSheet hssfSheet1 = hssfWorkbook.getSheetAt(1);

            //获取第一个sheet页数据放在数组中
            HSSFRow[] Row = new HSSFRow[hssfSheet.getLastRowNum()];
            for (int i = 1; i <= hssfSheet.getLastRowNum(); i++) {
                HSSFRow hssfRow = hssfSheet.getRow(i);
                Row[i - 1] = hssfRow;
            }


            //获取第二个sheet页数组，在数组中遍历一遍，相同id的输出
            for (int i = 1; i <= hssfSheet1.getLastRowNum(); i++) {
                HSSFRow hssfRow1 = hssfSheet1.getRow(i);
                HSSFCell hssfCell1 = hssfRow1.getCell(0);
                double id = hssfCell1.getNumericCellValue();

                for (int j = 1; j < Row.length; j++) {
                    if (Row[j].getCell(0).getNumericCellValue() == id) {
                            PrintRow(hssfSheet, Row[j]);
                            PrintRow(hssfSheet1, hssfRow1);
                        }

                    }
                }

        } catch (IOException e) {
            e.printStackTrace();
        }

    }

    public static void PrintRow(HSSFSheet hssfSheet, HSSFRow hssfRow) {


            for (int j = 0; j < hssfRow.getLastCellNum(); j++) {
                HSSFCell hssfCell = hssfRow.getCell(j);
                if (hssfCell.getCellType() == CellType.NUMERIC) {
                    System.out.print(hssfCell.getNumericCellValue());
                } else if (hssfCell.getCellType() == CellType.STRING) {
                    System.out.print(hssfCell.getStringCellValue());
                }
        }
        System.out.println();
    }
}