如何使用Java从电子表格中删除整列？

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

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

public class DeleteColumnFromExcel {
    public static void main(String[] args) {
        String filePath = "path/to/your/excel/file.xlsx";
        int columnToDelete = 2; // 要删除的列的索引（从0开始）

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

            Sheet sheet = workbook.getSheetAt(0); // 获取第一个工作表

            for (Row row : sheet) {
                Cell cell = row.getCell(columnToDelete);
                if (cell != null) {
                    row.removeCell(cell); // 删除单元格
                }
            }

            // 移动列
            int lastColumn = sheet.getRow(0).getLastCellNum() - 1;
            if (columnToDelete < lastColumn) {
                for (Row row : sheet) {
                    Cell cellToDelete = row.getCell(columnToDelete);
                    Cell cellToMove = row.getCell(columnToDelete + 1);
                    if (cellToDelete != null) {
                        row.removeCell(cellToDelete);
                    }
                    if (cellToMove != null) {
                        cellToMove.setCellType(CellType.BLANK);
                        sheet.shiftRows(row.getRowNum(), row.getRowNum(), -1);
                        row.createCell(lastColumn, CellType.BLANK);
                        row.getCell(lastColumn).setCellValue(cellToMove.getStringCellValue());
                    }
                }
            }

            try (FileOutputStream fos = new FileOutputStream(filePath)) {
                workbook.write(fos);
            }

            System.out.println("列删除成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}