肿么用Java读取两个Excel里的数据并进行

excel Java
1个回答

写回答
Sssxl

2025-12-31 10:10
+ 关注
excel
excel
要读取两个excel文件中的数据并进行比较，可以使用Java中的Apache POI库。以下是一个简单的示例代码：
Javaimport Java.io.*;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFDataValidationStructure;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDataValidationRuleCondition;import org.apache.poi.xssf.usermodel.XSSFDataValidationRuleInstance;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFDataValidationStructure;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;import org.apache.poi.xssf.usermodel.XSSFDialogData;public class excelComparison {public static void mAIn(String[] args) {File file1 = new File("file1.xlsx");File file2 = new File("file2.xlsx");Workbook workbook1 = null;Workbook workbook2 = null;try {workbook1 = new XSSFWorkbook(new FileInputStream(file1));workbook2 = new XSSFWorkbook(new FileInputStream(file2));} catch (IOException e) {e.printStackTrace();}Sheet sheet1 = workbook1.getSheetAt(0);Sheet sheet2 = workbook2.getSheetAt(0);int rowCount = sheet1.getLastRowNum();for (int i = 0; i < rowCount; i++) {Row row1 = sheet1.getRow(i);Row row2 = sheet2.getRow(i);if (row1 == null || row2 == null) {System.out.println("Row " + i + " is missing.");continue;}Cell cell1 = row1.getcell(0);Cell cell2 = row2.getcell(0);if (cell1 == null || cell2 == null) {System.out.println("Column header " + i + " is missing.");continue;}if (cell1.getStringCellValue().equals(cell2.getStringCellValue())) {System.out.println("Cells " + i + " and " + (i + 1) + " have the same value.");} else {System.out.println("Cells " + i + " and " + (i + 1) + " have different values.");}}}}
举报有用（0）分享收藏
肿么用Java读取两个Excel里的数据并进行

1个回答

Sssxl

热门话题

相关问题
