用于从excel工作表访问数据并将特定数据写入另一个excel工作表的Java代码

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

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

public class ExcelReadWriteExample {
    public static void main(String[] args) {
        String sourceFilePath = "path/to/source/excel.xlsx";
        String destinationFilePath = "path/to/destination/excel.xlsx";

        try {
            FileInputStream fis = new FileInputStream(sourceFilePath);
            Workbook sourceWorkbook = new XSSFWorkbook(fis);
            Sheet sourceSheet = sourceWorkbook.getSheetAt(0);

            Workbook destinationWorkbook = new XSSFWorkbook();
            Sheet destinationSheet = destinationWorkbook.createSheet("Destination Sheet");

            int destinationRowIndex = 0;

            for (Row sourceRow : sourceSheet) {
                for (Cell sourceCell : sourceRow) {
                    if (sourceCell.getCellType() == CellType.STRING) {
                        String cellValue = sourceCell.getStringCellValue();
                        if (cellValue.equals("特定数据")) {
                            Row destinationRow = destinationSheet.createRow(destinationRowIndex);
                            Cell destinationCell = destinationRow.createCell(0);
                            destinationCell.setCellValue(cellValue);
                            destinationRowIndex++;
                        }
                    }
                }
            }

            fis.close();

            FileOutputStream fos = new FileOutputStream(destinationFilePath);
            destinationWorkbook.write(fos);
            fos.close();

            System.out.println("特定数据已成功写入目标Excel工作表！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}