使用JAVA从Excel中获取数据并将行数打印到Excel中

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

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

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

        try {
            // 读取Excel文件
            FileInputStream fis = new FileInputStream(inputFile);
            Workbook workbook = WorkbookFactory.create(fis);
            Sheet sheet = workbook.getSheetAt(0);

            // 统计行数
            int rowCount = sheet.getLastRowNum() + 1;

            // 创建新的Excel文件
            Workbook newWorkbook = WorkbookFactory.create();
            Sheet newSheet = newWorkbook.createSheet();

            // 创建新的行
            Row newRow = newSheet.createRow(0);

            // 创建新的单元格
            Cell newCell = newRow.createCell(0);

            // 将行数写入单元格
            newCell.setCellValue(rowCount);

            // 写入Excel文件
            FileOutputStream fos = new FileOutputStream(outputFile);
            newWorkbook.write(fos);

            // 关闭文件输入流和文件输出流
            fis.close();
            fos.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}