excel表格生成html

将Excel表格转换为HTML格式可以通过多种方式实现，比如使用在线工具或者使用编程语言进行处理。以下是使用Java编程语言将Excel表格转换为HTML格式的示例代码：

import java.io.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.hssf.usermodel.*;

public class ExcelToHtmlConverter {
    public static void main(String[] args) throws Exception {
        String excelFilePath = "path/to/excel/file.xlsx";

        Workbook workbook = getWorkbook(excelFilePath);
        Sheet sheet = workbook.getSheetAt(0);

        StringBuilder htmlTable = new StringBuilder();
        htmlTable.append("<table>");

        for (Row row : sheet) {
            htmlTable.append("<tr>");
            for (Cell cell : row) {
                String cellValue = getCellValue(cell);
                htmlTable.append("<td>").append(cellValue).append("</td>");
            }
            htmlTable.append("</tr>");
        }

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

        System.out.println(htmlTable.toString());
    }

    private static Workbook getWorkbook(String excelFilePath) throws IOException {
        InputStream inputStream = new FileInputStream(new File(excelFilePath));
        Workbook workbook = null;
        if (excelFilePath.endsWith(".xlsx")) {
            workbook = new XSSFWorkbook(inputStream);
        } else if (excelFilePath.endsWith(".xls")) {
            workbook = new HSSFWorkbook(inputStream);
        }
        return workbook;
    }

    private static String getCellValue(Cell cell) {
        String cellValue = "";
        switch (cell.getCellTypeEnum()) {
            case STRING:
                cellValue = cell.getRichStringCellValue().getString();
                break;
            case NUMERIC:
                if (DateUtil.isCellDateFormatted(cell)) {
                    cellValue = cell.getDateCellValue().toString();
                } else {
                    cellValue = Double.toString(cell.getNumericCellValue());
                }
                break;
            case BOOLEAN:
                cellValue = Boolean.toString(cell.getBooleanCellValue());
                break;
            case FORMULA:
                cellValue = cell.getCellFormula();
                break;
            default:
                cellValue = "";
        }
        return cellValue;
    }
}

这段代码会将指定的Excel文件（xlsx或xls格式）的第一个工作表转换为HTML格式，并将其打印到控制台。可以根据需要将其保存到文件或使用其他方式进行处理。