/*?====================================================================
???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?ALIGN?=?mapFor（ALIGN_LEFT?“l(fā)eft“
????????????ALIGN_CENTER?“center“?ALIGN_RIGHT?“right“?ALIGN_FILL?“l(fā)eft“
????????????ALIGN_JUSTIFY?“l(fā)eft“?ALIGN_CENTER_SELECTION?“center“）;

????private?static?final?Map?VERTICAL_ALIGN?=?mapFor（
????????????VERTICAL_BOTTOM?“bottom“?VERTICAL_CENTER?“middle“?VERTICAL_TOP
????????????“top“）;

????p