java excel转html

您可以使用Apache POI库来读取Excel文件并将其转换为HTML格式。以下是一个简单的Java代码示例：

import java.io.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.util.*;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.w3c.dom.Document;
import org.w3c.dom.Element;

public class ExcelToHtmlConverter {
    public static void main(String[] args) {
        try {
            String inputFile = "input.xlsx";
            String outputFile = "output.html";
            Workbook workbook = WorkbookFactory.create(new File(inputFile));
            Document document = DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument();
            Element tableElement = document.createElement("table");

            for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
                Sheet sheet = workbook.getSheetAt(i);
                Iterator<Row> rowIterator = sheet.rowIterator();

                while (rowIterator.hasNext()) {
                    Row row = rowIterator.next();
                    Element trElement = document.createElement("tr");
                    Iterator<Cell> cellIterator = row.cellIterator();

                    while (cellIterator.hasNext()) {
                        Cell cell = cellIterator.next();
                        Element tdElement = document.createElement("td");
                        tdElement.setTextContent(cell.toString());
                        trElement.appendChild(tdElement);
                    }

                    tableElement.appendChild(trElement);
                }
            }

            document.appendChild(tableElement);
            FileWriter fileWriter = new FileWriter(outputFile);
            fileWriter.write(document.toString());
            fileWriter.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}

此代码将读取名为“input.xlsx”的Excel文件，并将其转换为HTML格式，然后将其写入名为“output.html”的文件中。您可以根据需要自定义代码以更好地满足您的需求。