用Java实现Excel行与列的转换

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

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

public class ExcelConverter {
    public static void main(String[] args) {
        String inputFile = "input.xlsx";
        String outputFile = "output.xlsx";

        try {
            FileInputStream fis = new FileInputStream(inputFile);
            Workbook workbook = new XSSFWorkbook(fis);
            Sheet sheet = workbook.getSheetAt(0);

            int rowCount = sheet.getLastRowNum() + 1;
            int colCount = sheet.getRow(0).getLastCellNum();

            Workbook outputWorkbook = new XSSFWorkbook();
            Sheet outputSheet = outputWorkbook.createSheet();

            for (int i = 0; i < rowCount; i++) {
                Row row = sheet.getRow(i);
                for (int j = 0; j < colCount; j++) {
                    Cell cell = row.getCell(j);
                    String value = cell.getStringCellValue();

                    Row outputRow = outputSheet.getRow(j);
                    if (outputRow == null) {
                        outputRow = outputSheet.createRow(j);
                    }

                    Cell outputCell = outputRow.createCell(i);
                    outputCell.setCellValue(value);
                }
            }

            FileOutputStream fos = new FileOutputStream(outputFile);
            outputWorkbook.write(fos);
            outputWorkbook.close();

            System.out.println("Excel行与列的转换已完成！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}