easypoi excel指定区域转换html

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

import java.io.FileOutputStream;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;

public class ExcelToHtmlConverter {

    public static void main(String[] args) {
        try {
            // 读取Excel文件
            Workbook workbook = WorkbookFactory.create(Paths.get("input.xlsx").toFile());

            // 获取指定的Sheet
            Sheet sheet = workbook.getSheet("Sheet1");

            // 创建Html样式
            String css = "<style>" +
                    "table { border-collapse: collapse; }" +
                    "th, td { border: 1px solid black; padding: 5px; }" +
                    "</style>";

            // 创建Html表格
            StringBuilder htmlTable = new StringBuilder("<table>");

            // 循环遍历指定区域的行
            for (int r = 0; r <= sheet.getLastRowNum(); r++) {
                Row row = sheet.getRow(r);

                // 循环遍历指定区域的列
                htmlTable.append("<tr>");
                for (int c = 0; c < row.getLastCellNum(); c++) {
                    Cell cell = row.getCell(c, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);

                    // 根据单元格类型处理单元格内容
                    CellType cellType = cell.getCellType();
                    if (cellType == CellType.STRING) {
                        htmlTable.append("<td>").append(cell.getStringCellValue()).append("</td>");
                    } else if (cellType == CellType.NUMERIC) {
                        htmlTable.append("<td>").append(cell.getNumericCellValue()).append("</td>");
                    } else {
                        htmlTable.append("<td></td>");
                    }
                }
                htmlTable.append("</tr>");
            }

            htmlTable.append("</table>");

            // 将Html写入文件
            Files.writeString(Path.of("output.html"), css + htmlTable.toString());

            System.out.println("转换成功");

        } catch (IOException ex) {
            ex.printStackTrace();
        }
    }
}