使用poi跳过或删除excel中的列

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream;
import java.io.FileOutputStream;

String filePath = "path/to/your/excel/file.xlsx";
FileInputStream fileInputStream = new FileInputStream(filePath);
Workbook workbook = new XSSFWorkbook(fileInputStream);

Sheet sheet = workbook.getSheetAt(0); // 假设要操作第一个工作表

int columnIndex = 2; // 假设要跳过或删除第3列（索引从0开始）

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

for (Row row : sheet) {
    for (int i = columnIndex + 1; i <= row.getLastCellNum(); i++) {
        Cell cell = row.getCell(i);
        if (cell != null) {
            Cell newCell = row.createCell(i - 1, cell.getCellType());
            newCell.setCellValue(cell.getStringCellValue()); // 复制单元格的值
            row.removeCell(cell); // 删除原单元格
        }
    }
}

String outputFilePath = "path/to/save/modified/excel/file.xlsx";
FileOutputStream fileOutputStream = new FileOutputStream(outputFilePath);
workbook.write(fileOutputStream);
fileOutputStream.close();