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

75 阅读 0 评论 50 点赞

我是靠谱客的博主细腻雨，最近开发中收集的这篇文章主要介绍Java练习（四十一）---Java+POI&两个sheet页，判断id相同输出相同id的全部信息，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

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