java代码将excel转为html,单元格显示公式，不显示值， 如何修改让单元格显示值

要将Excel转换为HTML并显示计算后的值而不是公式，可以在转换过程中选择“显示值”选项。以下是一个简单的Java代码示例，可以使用Apache POI库将Excel文件转换为HTML，并选择“显示值”选项：

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 org.apache.poi.hssf.util.*;
import org.apache.poi.xssf.util.*;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.hssf.converter.*;
import org.apache.poi.xssf.converter.*;

public class ExcelToHtmlConverter {

    public static void main(String[] args) throws Exception {
        // Input Excel file
        FileInputStream inputWorkbook = new FileInputStream(new File("input.xlsx"));

        // Load the workbook
        Workbook workbook = WorkbookFactory.create(inputWorkbook);

        // Create HTML file
        File outputFile = new File("output.html");
        FileOutputStream out = new FileOutputStream(outputFile);

        // Set up the HTML converter
        HtmlFileSaxWriter htmlConverter = new HtmlFileSaxWriter();

        // Set up the configuration
        ExcelToHtmlConverterConfiguration configuration = new ExcelToHtmlConverterConfiguration();
        configuration.setCssClassPrefix("excel-");

        // Convert the workbook to HTML
        if (workbook instanceof XSSFWorkbook) {
            XSSFWorkbook xssfWorkbook = (XSSFWorkbook) workbook;
            XSSFExcelExtractor extractor = new XSSFExcelExtractor(xssfWorkbook);
            extractor.setFormulasNotResults(false);
            extractor.setIncludeSheetNames(false);
            htmlConverter.processWorkbook(xssfWorkbook, configuration, extractor);
        } else if (workbook instanceof HSSFWorkbook) {
            HSSFWorkbook hssfWorkbook = (HSSFWorkbook) workbook;
            ExcelExtractor extractor = new ExcelExtractor(hssfWorkbook);
            extractor.setFormulasNotResults(false);
            extractor.setIncludeSheetNames(false);
            htmlConverter.processWorkbook(hssfWorkbook, configuration, extractor);
        }

        // Write the output HTML to the file
        out.write(htmlConverter.getDocument().getBytes("UTF-8"));
        out.close();
    }
}

请注意，上面的代码将使用“setFormulasNotResults(false)”选项来选择“显示值”，而不是公式。如果需要显示公式，请将此选项设置为“true”。