Apache poi excel to html

Содержание
  1. Apache poi excel to html
  2. ExcelToHtmlConverter
  3. ExcelToHtmlConverter
  4. main
  5. process
  6. buildStyle
  7. getCssClassPrefixCell
  8. getCssClassPrefixDiv
  9. getCssClassPrefixRow
  10. getCssClassPrefixTable
  11. getDocument
  12. getStyleClassName
  13. isUseDivsToSpan
  14. processCell
  15. processColumnHeaders
  16. processColumnWidths
  17. processDocumentInformation
  18. processRow
  19. processRowNumber
  20. processSheet
  21. processSheetHeader
  22. processWorkbook
  23. setCssClassPrefixCell
  24. setCssClassPrefixDiv
  25. setCssClassPrefixRow
  26. setCssClassPrefixTable
  27. setUseDivsToSpan
  28. Apache poi excel to html
  29. Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter
  30. Methods inherited from class java.lang.Object
  31. Constructor Detail
  32. ExcelToHtmlConverter
  33. ExcelToHtmlConverter
  34. Method Detail
  35. main
  36. process
  37. process
  38. process
  39. buildStyle
  40. getCssClassPrefixCell
  41. getCssClassPrefixDiv
  42. getCssClassPrefixRow
  43. getCssClassPrefixTable
  44. getDocument
  45. getStyleClassName
  46. isUseDivsToSpan
  47. processCell
  48. processColumnHeaders
  49. processColumnWidths
  50. processDocumentInformation
  51. processRow
  52. processRowNumber
  53. processSheet
  54. processSheetHeader
  55. processWorkbook
  56. setCssClassPrefixCell
  57. setCssClassPrefixDiv
  58. setCssClassPrefixRow
  59. setCssClassPrefixTable
  60. setUseDivsToSpan
  61. Apache poi excel to html
  62. Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter
  63. Methods inherited from class java.lang.Object
  64. Constructor Detail
  65. ExcelToHtmlConverter
  66. ExcelToHtmlConverter
  67. Method Detail
  68. main
  69. process
  70. process
  71. process
  72. buildStyle
  73. getCssClassPrefixCell
  74. getCssClassPrefixDiv
  75. getCssClassPrefixRow
  76. getCssClassPrefixTable
  77. getDocument
  78. getStyleClassName
  79. isUseDivsToSpan
  80. processCell
  81. processColumnHeaders
  82. processColumnWidths
  83. processDocumentInformation
  84. processRow
  85. processRowNumber
  86. processSheet
  87. processSheetHeader
  88. processWorkbook
  89. setCssClassPrefixCell
  90. setCssClassPrefixDiv
  91. setCssClassPrefixRow
  92. setCssClassPrefixTable
  93. setUseDivsToSpan

Apache poi excel to html

Converts xls files (97-2007) to HTML file.

Author: Sergey Vladimirov (vlsergey gmail com)

Field Summary
Fields inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter
_formatter
Constructor Summary
ExcelToHtmlConverter (org.w3c.dom.Document doc)
ExcelToHtmlConverter (HtmlDocumentFacade htmlDocumentFacade)
Method Summary
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
static org.w3c.dom.Document process (java.io.File xlsFile)
Converts Excel file (97-2007) into HTML file.
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.
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).
Читайте также:  Фигуры на полях html academy
Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter
getColumnName, getColumnWidth, getDefaultColumnWidth, getFontReplacer, getRowName, isOutputColumnHeaders, isOutputHiddenColumns, isOutputHiddenRows, isOutputLeadingSpacesAsNonBreaking, isOutputRowNumbers, isTextEmpty, setFontReplacer, setOutputColumnHeaders, setOutputHiddenColumns, setOutputHiddenRows, setOutputLeadingSpacesAsNonBreaking, setOutputRowNumbers
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

ExcelToHtmlConverter

public ExcelToHtmlConverter(org.w3c.dom.Document doc)

ExcelToHtmlConverter


main

public static void main(java.lang.String[] args)

Usage: ExcelToHtmlConverter infile outfile

Where infile is an input .xls file ( Word 97-2007) which will be rendered as HTML into outfile

process

public static org.w3c.dom.Document process(java.io.File xlsFile) throws java.lang.Exception

Parameters: xlsFile — file to process Returns: DOM representation of result HTML Throws: java.lang.Exception

buildStyle

protected java.lang.String buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

getCssClassPrefixCell

public java.lang.String getCssClassPrefixCell()

getCssClassPrefixDiv

public java.lang.String getCssClassPrefixDiv()

getCssClassPrefixRow

public java.lang.String getCssClassPrefixRow()

getCssClassPrefixTable

public java.lang.String getCssClassPrefixTable()

getDocument

public org.w3c.dom.Document getDocument()

getStyleClassName

protected java.lang.String getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

isUseDivsToSpan

public boolean isUseDivsToSpan()

processCell

protected boolean processCell(HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)

processColumnHeaders

protected void processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

processColumnWidths

protected void processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

Creates COLGROUP element with width specified for all columns. (Except first if AbstractExcelConverter.isOutputRowNumbers() ==true)

processDocumentInformation


processRow

protected int processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)

processRowNumber

protected void processRowNumber(HSSFRow row, org.w3c.dom.Element tableRowNumberCellElement)

processSheet


processSheetHeader


processWorkbook


setCssClassPrefixCell

public void setCssClassPrefixCell(java.lang.String cssClassPrefixCell)

setCssClassPrefixDiv

public void setCssClassPrefixDiv(java.lang.String cssClassPrefixDiv)

setCssClassPrefixRow

public void setCssClassPrefixRow(java.lang.String cssClassPrefixRow)

setCssClassPrefixTable

public void setCssClassPrefixTable(java.lang.String cssClassPrefixTable)

setUseDivsToSpan

public 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).

Warning: after enabling this mode do not serialize result HTML with INDENT=YES option, because line breaks will make additional (unwanted) changes

Overview Package Class Use Tree Deprecated Index Help
PREV CLASS NEXT CLASS FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright 2015 The Apache Software Foundation or its licensors, as applicable.

Источник

Apache poi excel to html

Allows converter to wrap content into two additional DIVs with tricky styles, so it will wrap across empty cells (like in Excel).

Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter

Methods inherited from class java.lang.Object

Constructor Detail

ExcelToHtmlConverter

public ExcelToHtmlConverter(org.w3c.dom.Document doc)

ExcelToHtmlConverter

Method Detail

main

public static void main(java.lang.String[] args) throws java.lang.Exception

Java main() interface to interact with ExcelToHtmlConverter Usage: ExcelToHtmlConverter infile outfile Where infile is an input .xls file ( Word 97-2007) which will be rendered as HTML into outfile

process

public static org.w3c.dom.Document process(java.io.File xlsFile) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

process

public static org.w3c.dom.Document process(java.io.InputStream xlsStream) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

process

public static org.w3c.dom.Document process(HSSFWorkbook workbook) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

buildStyle

protected java.lang.String buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

getCssClassPrefixCell

public java.lang.String getCssClassPrefixCell()

getCssClassPrefixDiv

public java.lang.String getCssClassPrefixDiv()

getCssClassPrefixRow

public java.lang.String getCssClassPrefixRow()

getCssClassPrefixTable

public java.lang.String getCssClassPrefixTable()

getDocument

public org.w3c.dom.Document getDocument()

getStyleClassName

protected java.lang.String getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

isUseDivsToSpan

public boolean isUseDivsToSpan()

processCell

protected boolean processCell(HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)

processColumnHeaders

protected void processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

processColumnWidths

protected void processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

Creates COLGROUP element with width specified for all columns. (Except first if AbstractExcelConverter.isOutputRowNumbers() ==true )

processDocumentInformation

processRow

protected int processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)

processRowNumber

protected void processRowNumber(HSSFRow row, org.w3c.dom.Element tableRowNumberCellElement)

processSheet

processSheetHeader

processWorkbook

setCssClassPrefixCell

public void setCssClassPrefixCell(java.lang.String cssClassPrefixCell)

setCssClassPrefixDiv

public void setCssClassPrefixDiv(java.lang.String cssClassPrefixDiv)

setCssClassPrefixRow

public void setCssClassPrefixRow(java.lang.String cssClassPrefixRow)

setCssClassPrefixTable

public void setCssClassPrefixTable(java.lang.String cssClassPrefixTable)

setUseDivsToSpan

public 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). Warning: after enabling this mode do not serialize result HTML with INDENT=YES option, because line breaks will make additional (unwanted) changes

Copyright 2022 The Apache Software Foundation or its licensors, as applicable.

Источник

Apache poi excel to html

Allows converter to wrap content into two additional DIVs with tricky styles, so it will wrap across empty cells (like in Excel).

Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter

Methods inherited from class java.lang.Object

Constructor Detail

ExcelToHtmlConverter

public ExcelToHtmlConverter(org.w3c.dom.Document doc)

ExcelToHtmlConverter

Method Detail

main

public static void main(java.lang.String[] args) throws java.lang.Exception

Java main() interface to interact with ExcelToHtmlConverter Usage: ExcelToHtmlConverter infile outfile Where infile is an input .xls file ( Word 97-2007) which will be rendered as HTML into outfile

process

public static org.w3c.dom.Document process(java.io.File xlsFile) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

process

public static org.w3c.dom.Document process(java.io.InputStream xlsStream) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

process

public static org.w3c.dom.Document process(HSSFWorkbook workbook) throws java.io.IOException, javax.xml.parsers.ParserConfigurationException

buildStyle

protected java.lang.String buildStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

getCssClassPrefixCell

public java.lang.String getCssClassPrefixCell()

getCssClassPrefixDiv

public java.lang.String getCssClassPrefixDiv()

getCssClassPrefixRow

public java.lang.String getCssClassPrefixRow()

getCssClassPrefixTable

public java.lang.String getCssClassPrefixTable()

getDocument

public org.w3c.dom.Document getDocument()

getStyleClassName

protected java.lang.String getStyleClassName(HSSFWorkbook workbook, HSSFCellStyle cellStyle)

isUseDivsToSpan

public boolean isUseDivsToSpan()

processCell

protected boolean processCell(HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)

processColumnHeaders

protected void processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

processColumnWidths

protected void processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)

Creates COLGROUP element with width specified for all columns. (Except first if AbstractExcelConverter.isOutputRowNumbers() ==true)

processDocumentInformation

processRow

protected int processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)

processRowNumber

protected void processRowNumber(HSSFRow row, org.w3c.dom.Element tableRowNumberCellElement)

processSheet

processSheetHeader

processWorkbook

setCssClassPrefixCell

public void setCssClassPrefixCell(java.lang.String cssClassPrefixCell)

setCssClassPrefixDiv

public void setCssClassPrefixDiv(java.lang.String cssClassPrefixDiv)

setCssClassPrefixRow

public void setCssClassPrefixRow(java.lang.String cssClassPrefixRow)

setCssClassPrefixTable

public void setCssClassPrefixTable(java.lang.String cssClassPrefixTable)

setUseDivsToSpan

public 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). Warning: after enabling this mode do not serialize result HTML with INDENT=YES option, because line breaks will make additional (unwanted) changes

Copyright 2021 The Apache Software Foundation or its licensors, as applicable.

Источник

Оцените статью