Java 将 Excel 文件在网页展示 - 使用 Apache POI 库

Java可以使用Apache POI库来读取Excel文件，将其转换成HTML格式，然后在网页上展示出来。

以下是一个简单的示例代码：

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

public class ExcelToHtml {
    public static void main(String[] args) throws Exception {
        String excelFilePath = "myExcelFile.xlsx";
        File inputFile = new File(excelFilePath);

        //Get the workbook instance for XLSX file
        Workbook workbook = null;
        if (excelFilePath.endsWith("xlsx")) {
            workbook = new XSSFWorkbook(new FileInputStream(inputFile));
        } else if (excelFilePath.endsWith("xls")) {
            workbook = new HSSFWorkbook(new FileInputStream(inputFile));
        }

        //Get the first sheet from the workbook
        Sheet sheet = workbook.getSheetAt(0);

        //Create a new HTML table
        StringBuffer htmlTable = new StringBuffer("<table>");

        //Iterate through each rows from first sheet
        Iterator<Row> rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();

            //Create a new HTML table row
            htmlTable.append("<tr>");

            //Iterate through each columns from the row
            Iterator<Cell> cellIterator = row.cellIterator();
            while (cellIterator.hasNext()) {
                Cell cell = cellIterator.next();

                //Create a new HTML table cell
                htmlTable.append("<td>");

                //Get the cell value and append to HTML table cell
                switch (cell.getCellType()) {
                    case STRING:
                        htmlTable.append(cell.getStringCellValue());
                        break;
                    case NUMERIC:
                        htmlTable.append(cell.getNumericCellValue());
                        break;
                    case BOOLEAN:
                        htmlTable.append(cell.getBooleanCellValue());
                        break;
                    case FORMULA:
                        htmlTable.append(cell.getCellFormula());
                        break;
                    case BLANK:
                        htmlTable.append("");
                        break;
                    default:
                        htmlTable.append(cell);
                }

                //Close the HTML table cell
                htmlTable.append("</td>");
            }

            //Close the HTML table row
            htmlTable.append("</tr>");
        }

        //Close the HTML table
        htmlTable.append("</table>");

        //Print the HTML table
        System.out.println(htmlTable.toString());

        //Close the workbook
        workbook.close();
    }
}

这个示例代码将读取名为'myExcelFile.xlsx'的Excel文件的第一个表格，并将其转换为HTML格式。HTML表格将存储在一个StringBuffer对象中，并在控制台上打印出来。然后，您可以将HTML表格嵌入到您的网页中。