使用apache poi从具有多张图纸的xlsx文件中提取基于给定图纸名称的文本

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

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

public class XLSXExtractor {
    public static void main(String[] args) {
        String filePath = "path/to/your/file.xlsx";
        String targetSheetName = "TargetSheet";

        try (FileInputStream fis = new FileInputStream(filePath);
             Workbook workbook = WorkbookFactory.create(fis)) {

            int numberOfSheets = workbook.getNumberOfSheets();

            for (int i = 0; i < numberOfSheets; i++) {
                Sheet sheet = workbook.getSheetAt(i);
                String sheetName = sheet.getSheetName();

                if (sheetName.equals(targetSheetName)) {
                    for (Row row : sheet) {
                        for (Cell cell : row) {
                            if (cell.getCellType() == CellType.STRING) {
                                String text = cell.getStringCellValue();
                                System.out.println(text);
                                // 处理提取的文本内容，例如保存到数据库、写入文件等
                            }
                        }
                    }
                    break;
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}