支持 03 和 07 版本的 Excel 文件

ExcelToHtml.java

public static String getHtml(InputStream is) throws Exception{
    Workbook wb = WorkbookFactory.create(is);
    if (wb instanceof XSSFWorkbook) {
        XSSFWorkbook xWb = (XSSFWorkbook) wb;
        return POIReadExcelToHtml07.getExcelToHtml(xWb);
    }else if(wb instanceof HSSFWorkbook){
        HSSFWorkbook hWb = (HSSFWorkbook) wb;
        return POIReadExcelToHtml03.getHtmlExcel(hWb);
    }
    return null;
}

Test.java

public static void main(String[] args) throws Exception {
    // 输入文件
    String path = "C:\\Users\\Administrator\\Desktop\\1.xlsx";
    // 输出文件
    String outPut = "C:\\Users\\Administrator\\Desktop\\1.html";

    File sourcefile = new File(path);

    InputStream is = new FileInputStream(sourcefile);
    
    String html = ExcelToHtml.getHtml(is);
    is.close();
    
    FileOutputStream fos = new FileOutputStream(outPut);
    Writer os = new OutputStreamWriter(fos, "GBK");  
    os.write(html);  
    os.flush();  
    fos.close();  
}