excel完美转html（在官方demo基础上优化，支持单元格合并）

/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.ss.examples.html; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.format.CellFormat; import org.apache.poi.ss.format.CellFormatResult; import org.apache.poi.ss.usermodel.*; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.ss.util.Region; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.BufferedReader; import java.io.Closeable; import java.io.FileInputStream; import java.io.FileWriter; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.PrintWriter; import java.util.Formatter; import java.util.HashMap; import java.util.HashSet; import java.util.Iterator; import java.util.Map; import java.util.Set; import static org.apache.poi.ss.usermodel.CellStyle.*; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; /** * This example shows how to display a spreadsheet in HTML using the classes for * spreadsheet display. * * @author Ken Arnold, Industrious Media LLC */ public class ToHtml { private final Workbook wb; private final Appendable output; private boolean completeHTML; private Formatter out; private boolean gotBounds; private int firstColumn; private int endColumn; private HtmlHelper helper; private static final String DEFAULTS_CLASS = "excelDefaults"; private static final String COL_HEAD_CLASS = "colHeader"; private static final String ROW_HEAD_CLASS = "rowHeader"; private static final Map<Short, String> ALIGN = mapFor(ALIGN_LEFT, "left", ALIGN_CENTER, "center", ALIGN_RIGHT, "right", ALIGN_FILL, "left", ALIGN_JUSTIFY, "left", ALIGN_CENTER_SELECTION, "center"); private static final Map<Short, String> VERTICAL_ALIGN = mapFor( VERTICAL_BOTTOM, "bottom", VERTICAL_CENTER, "middle", VERTICAL_TOP, "top"); private static final Map<Short, String> BORDER = mapFor(BORDER_DASH_DOT, "solid 1pt", BORDER_DASH_DOT_DOT, "solid 1pt", BORDER_DASHED, "solid 1pt", BORDER_DOTTED, "dotted 1pt", BORDER_DOUBLE, "double 3pt", BORDER_HAIR, "solid 1px", BORDER_MEDIUM, "solid 2pt", BORDER_MEDIUM_DASH_DOT, "solid 2pt", BORDER_MEDIUM_DASH_DOT_DOT, "solid 2pt", BORDER_MEDIUM_DASHED, "solid 2pt", BORDER_NONE, "none", BORDER_SLANTED_DASH_DOT, "solid 2pt", BORDER_THICK, "solid 3pt", BORDER_THIN, "solid 1pt"); @SuppressWarnings({"unchecked"}) private static <K, V> Map<K, V> mapFor(Object... mapping) { Map<K, V> map = new HashMap<K, V>(); for (int i = 0; i < mapping.length; i += 2) { map.put((K) mapping[i], (V) mapping[i + 1]); } return map; } /** * Creates a new converter to HTML for the given workbook. * * @param wb The workbook. * @param output Where the HTML output will be written. * * @return An object for converting the workbook to HTML. */ public static ToHtml create(Workbook wb, Appendable output) { return new ToHtml(wb, output); } /** * Creates a new converter to HTML for the given workbook. If the path ends * with "<tt>.xlsx</tt>" an {@link XSSFWorkbook} will be used; otherwise * this will use an {@link HSSFWorkbook}. * * @param path The file that has the workbook. * @param output Where the HTML output will be written. * * @return An object for converting the workbook to HTML. */ public static ToHtml create(String path, Appendable output) throws IOException { return create(new FileInputStream(path), output); } /** * Creates a new converter to HTML for the given workbook. This attempts to * detect whether the input is XML (so it should create an {@link * XSSFWorkbook} or not (so it should create an {@link HSSFWorkbook}). * * @param in The input stream that has the workbook. * @param output Where the HTML output will be written. * * @return An object for converting the workbook to HTML. */ public static ToHtml create(InputStream in, Appendable output) throws IOException { try { Workbook wb = WorkbookFactory.create(in); return create(wb, output); } catch (InvalidFormatException e){ throw new IllegalArgumentException("Cannot create workbook from stream", e); } } private ToHtml(Workbook wb, Appendable output) { if (wb == null) throw new NullPointerException("wb"); if (output == null) throw new NullPointerException("output"); this.wb = wb; this.output = output; setupColorMap(); } private void setupColorMap() { if (wb instanceof HSSFWorkbook) helper = new HSSFHtmlHelper((HSSFWorkbook) wb); else if (wb instanceof XSSFWorkbook) helper = new XSSFHtmlHelper((XSSFWorkbook) wb); else throw new IllegalArgumentException( "unknown workbook type: " + wb.getClass().getSimpleName()); } /** * Run this class as a program * * @param args The command line arguments. * * @throws Exception Exception we don't recover from. */ public static void main(String[] args) throws Exception { if(args.length < 2){ System.err.println("usage: ToHtml inputWorkbook outputHtmlFile"); return; } ToHtml toHtml = create(args[0], new PrintWriter(new FileWriter(args[1]))); toHtml.setCompleteHTML(true); toHtml.printPage(); } public void setCompleteHTML(boolean completeHTML) { this.completeHTML = completeHTML; } public void printPage() throws IOException { try { ensureOut(); if (completeHTML) { out.format( "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>%n"); out.format("<html>%n"); out.format("<head>%n"); out.format("</head>%n"); out.format("<body>%n"); } print(); if (completeHTML) { out.format("</body>%n"); out.format("</html>%n"); } } finally { if (out != null) out.close(); if (output instanceof Closeable) { Closeable closeable = (Closeable) output; closeable.close(); } } } public void print() { printInlineStyle(); printSheets(); } private void printInlineStyle() { //out.format("<link href=\"e