如何在Java中打开Excel工作簿并删除所有只有标题行的工作表

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>

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

public class ExcelUtils {
    public static void main(String[] args) {
        try {
            Workbook workbook = WorkbookFactory.create(new File("path/to/excel.xlsx"));
            // 进一步处理工作簿
        } catch (IOException | InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}

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

public class ExcelUtils {
    public static void main(String[] args) {
        try {
            Workbook workbook = WorkbookFactory.create(new File("path/to/excel.xlsx"));
            
            for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
                Sheet sheet = workbook.getSheetAt(i);
                if (sheet.getLastRowNum() == 0) {
                    workbook.removeSheetAt(i);
                }
            }
            
            // 进一步处理工作簿
            
        } catch (IOException | InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}

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

public class ExcelUtils {
    public static void main(String[] args) {
        try {
            Workbook workbook = WorkbookFactory.create(new File("path/to/excel.xlsx"));
            
            for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
                Sheet sheet = workbook.getSheetAt(i);
                if (sheet.getLastRowNum() == 0) {
                    workbook.removeSheetAt(i);
                }
            }
            
            // 进一步处理工作簿
            
            FileOutputStream fileOut = new FileOutputStream("path/to/modified_excel.xlsx");
            workbook.write(fileOut);
            fileOut.close();
            
        } catch (IOException | InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}