@Beta public class ExcelToHtmlConverter extends AbstractExcelConverter
_formatter
Constructor and Description |
---|
ExcelToHtmlConverter(org.w3c.dom.Document doc) |
ExcelToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade) |
Modifier and Type | Method and Description |
---|---|
protected java.lang.String |
buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle) |
java.lang.String |
getCssClassPrefixCell() |
java.lang.String |
getCssClassPrefixDiv() |
java.lang.String |
getCssClassPrefixRow() |
java.lang.String |
getCssClassPrefixTable() |
org.w3c.dom.Document |
getDocument() |
protected java.lang.String |
getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle) |
boolean |
isUseDivsToSpan() |
static void |
main(java.lang.String[] args)
Java main() interface to interact with
ExcelToHtmlConverter
(Java main() 接口与 ExcelToHtmlConverter 交互)
|
static org.w3c.dom.Document |
process(java.io.File xlsFile)
Converts Excel file (97-2007) into HTML file.
(将 Excel 文件 (97-2007) 转换为 HTML 文件。)
|
static org.w3c.dom.Document |
process(HSSFWorkbook workbook)
Converts Excel file (97-2007) into HTML file.
(将 Excel 文件 (97-2007) 转换为 HTML 文件。)
|
static org.w3c.dom.Document |
process(java.io.InputStream xlsStream)
Converts Excel file (97-2007) into HTML file.
(将 Excel 文件 (97-2007) 转换为 HTML 文件。)
|
protected boolean |
processCell(HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt) |
protected void |
processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table) |
protected void |
processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
Creates COLGROUP element with width specified for all columns.
(创建为所有列指定宽度的 COLGROUP 元素。)
|
protected void |
processDocumentInformation(SummaryInformation summaryInformation) |
protected int |
processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement) |
protected void |
processRowNumber(HSSFRow row, org.w3c.dom.Element tableRowNumberCellElement) |
protected void |
processSheet(HSSFSheet sheet) |
protected void |
processSheetHeader(org.w3c.dom.Element htmlBody, HSSFSheet sheet) |
void |
processWorkbook(HSSFWorkbook workbook) |
void |
setCssClassPrefixCell(java.lang.String cssClassPrefixCell) |
void |
setCssClassPrefixDiv(java.lang.String cssClassPrefixDiv) |
void |
setCssClassPrefixRow(java.lang.String cssClassPrefixRow) |
void |
setCssClassPrefixTable(java.lang.String cssClassPrefixTable) |
void |
setUseDivsToSpan(boolean useDivsToSpan)
Allows converter to wrap content into two additional DIVs with tricky styles, so it will wrap across empty cells (like in Excel).
(允许转换器将内容包装到具有复杂样式的两个附加 DIV 中,因此它将包装空单元格(如在 Excel 中)。)
|
getColumnName, getColumnWidth, getDefaultColumnWidth, getFontReplacer, getRowName, isOutputColumnHeaders, isOutputHiddenColumns, isOutputHiddenRows, isOutputLeadingSpacesAsNonBreaking, isOutputRowNumbers, isTextEmpty, setFontReplacer, setOutputColumnHeaders, setOutputHiddenColumns, setOutputHiddenRows, setOutputLeadingSpacesAsNonBreaking, setOutputRowNumbers
public ExcelToHtmlConverter(org.w3c.dom.Document doc)
public ExcelToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)
public static void main(java.lang.String[] args) throws java.lang.Exception
ExcelToHtmlConverter
Usage: ExcelToHtmlConverter infile outfile
Where infile is an input .xls file ( Word 97-2007) which will be rendered as HTML into outfile (与 ExcelToHtmlConverter 交互的 Java main() 接口 用法:ExcelToHtmlConverter infile outfile 其中 infile 是输入 .xls 文件 (Word 97-2007),它将作为 HTML 呈现到 outfile)java.lang.Exception
(java.lang.异常)
public static org.w3c.dom.Document process(java.io.File xlsFile) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException
xlsFile
- workbook file to process
(xlsFile - 要处理的工作簿文件)
java.io.IOException
- If an error occurs reading or writing files
(java.io.IOException - 如果读取或写入文件发生错误)
javax.xml.parsers.ParserConfigurationException
- If configuration is incorrect
(javax.xml.parsers.ParserConfigurationException - 如果配置不正确)
public static org.w3c.dom.Document process(java.io.InputStream xlsStream) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException
xlsStream
- workbook stream to process
(xlsStream - 要处理的工作簿流)
java.io.IOException
- If an error occurs reading or writing files
(java.io.IOException - 如果读取或写入文件发生错误)
javax.xml.parsers.ParserConfigurationException
- If configuration is incorrect
(javax.xml.parsers.ParserConfigurationException - 如果配置不正确)
public static org.w3c.dom.Document process(HSSFWorkbook workbook) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException
workbook
- workbook instance to process
(workbook - 要处理的工作簿实例)
java.io.IOException
- If an error occurs reading or writing files
(java.io.IOException - 如果读取或写入文件发生错误)
javax.xml.parsers.ParserConfigurationException
- If configuration is incorrect
(javax.xml.parsers.ParserConfigurationException - 如果配置不正确)
protected java.lang.String buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
public java.lang.String getCssClassPrefixCell()
public java.lang.String getCssClassPrefixDiv()
public java.lang.String getCssClassPrefixRow()
public java.lang.String getCssClassPrefixTable()
public org.w3c.dom.Document getDocument()
getDocument
in class
AbstractExcelConverter
(类 AbstractExcelConverter 中的 getDocument)
protected java.lang.String getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)
public boolean isUseDivsToSpan()
protected boolean processCell(HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)
protected void processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
protected void processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
AbstractExcelConverter.isOutputRowNumbers()
==true)
(创建为所有列指定宽度的 COLGROUP 元素。 (如果 AbstractExcelConverter.isOutputRowNumbers()==true 除外))
protected void processDocumentInformation(SummaryInformation summaryInformation)
protected int processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)
protected void processRowNumber(HSSFRow row, org.w3c.dom.Element tableRowNumberCellElement)
protected void processSheet(HSSFSheet sheet)
protected void processSheetHeader(org.w3c.dom.Element htmlBody, HSSFSheet sheet)
public void processWorkbook(HSSFWorkbook workbook)
public void setCssClassPrefixCell(java.lang.String cssClassPrefixCell)
public void setCssClassPrefixDiv(java.lang.String cssClassPrefixDiv)
public void setCssClassPrefixRow(java.lang.String cssClassPrefixRow)
public void setCssClassPrefixTable(java.lang.String cssClassPrefixTable)
public void setUseDivsToSpan(boolean useDivsToSpan)
Warning: after enabling this mode do not serialize result HTML with INDENT=YES option, because line breaks will make additional (unwanted) changes
(允许转换器将内容包装到具有复杂样式的两个附加 DIV 中,因此它将包装空单元格(如在 Excel 中)。警告:启用此模式后,不要使用 INDENT=YES 选项序列化结果 HTML,因为换行符会进行额外的(不需要的)更改)Copyright 2021 The Apache Software Foundation or its licensors, as applicable.