读取excel文件转为HTML

最近写了一个公式较复杂的报表，因梳理公式与后期的数据核对会比较耗费时间，因此采用了读取EXCEL模板，然后填写数据；最后读取最终文件生成页面的方法。现整理了将EXCEL转为HTML的方法。（本人在用的xlsx文件，颜色不支持灰色，建议使用其他背景色）

POI版本：3.17

3.8版本不支持countIfs函数

package com.tarena.kcrm.performance.util;

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.Writer;
import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator;
import org.apache.poi.hssf.usermodel.HSSFPalette;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


/**
 * @功能描述 POI 读取 Excel 转 HTML 支持 03xls 和 07xlsx 版本 包含样式
 */
public class POIReadExcelToHtml {

	/**
	 * 测试
	 * 
	 * @param args
	 */
	public static void pdf2html(InputStream is, String dispath) {

		String htmlExcel = null;
		Writer wr = null;
		try {
			Workbook wb = WorkbookFactory.create(is);// 此WorkbookFactory在POI-3.10版本中使用需要添加dom4j
			if (wb instanceof XSSFWorkbook) {
				XSSFWorkbook xWb = (XSSFWorkbook) wb;
				FormulaEvaluator eval = new XSSFFormulaEvaluator(xWb);
				htmlExcel = POIReadExcelToHtml.getExcelInfo(eval,xWb, true);
			} else if (wb instanceof HSSFWorkbook) {
				HSSFWorkbook hWb = (HSSFWorkbook) wb;
				FormulaEvaluator eval = new HSSFFormulaEvaluator(hWb);
				htmlExcel = POIReadExcelToHtml.getExcelInfo(eval,hWb, true);
			}
//			HSSFWorkbook hWb = new HSSFWorkbook(is);
//			htmlExcel = POIReadExcelToHtml.getExcelInfo(hWb, true);
			File file = new File(dispath);
			if (!file.exists()) {
				file.createNewFile();
			}
			wr = new FileWriter(file);
			wr.write(htmlExcel);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (is != null) {
					is.close();
				}
				if (wr != null) {
					wr.close();
				}

			} catch (IOException e) {
				e.printStackTrace();
			}
		}

	}

	/**
	 * 程序入口方法
	 * 
	 * @param is
	 *            需要转成html的文件的输入流
	 * @param isWithStyle
	 *            是否需要表格样式 包含 字体 颜色 边框 对齐方式
	 * @return <table>
	 *         ...
	 *         </table>
	 *         字符串
	 */
	public static String readExcelToHtml(InputStream is, boolean isWithStyle) {

		String htmlExcel = null;
		try {
			Workbook wb = WorkbookFactory.create(is);
			if (wb instanceof XSSFWorkbook) {
				XSSFWorkbook xWb = (XSSFWorkbook) wb;
				FormulaEvaluator eval = new XSSFFormulaEvaluator(xWb);
				htmlExcel = POIReadExcelToHtml.getExcelInfo(eval,xWb, i