net.datenwerke.rs.jxlsreport.service.jxlsreport.utils

Class XlsxToHtmlConverter

java.lang.Object

AbstractExcelConverter

net.datenwerke.rs.jxlsreport.service.jxlsreport.utils.XlsxToHtmlConverter

public class XlsxToHtmlConverter
extends AbstractExcelConverter

adapted from Sergey Vladimirov (vlsergey {at} gmail {dot} com)

Constructor Summary

Constructors

Constructor and Description
XlsxToHtmlConverter(org.w3c.dom.Document doc)
XlsxToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)

Method Summary

Modifier and Type	Method and Description
static CellRangeAddress[][]	buildMergedRangesMap(XSSFSheet sheet)
static java.lang.String	getColor(XSSFColor color)
java.lang.String	getCssClassPrefixCell()
java.lang.String	getCssClassPrefixDiv()
java.lang.String	getCssClassPrefixRow()
java.lang.String	getCssClassPrefixTable()
org.w3c.dom.Document	getDocument()
boolean	isUseDivsToSpan()
void	processWorkbook(XSSFWorkbook 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).

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XlsxToHtmlConverter

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

XlsxToHtmlConverter

public XlsxToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)

Method Detail

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()

isUseDivsToSpan

public boolean isUseDivsToSpan()

processWorkbook

public void processWorkbook(XSSFWorkbook workbook)

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

buildMergedRangesMap

public static CellRangeAddress[][] buildMergedRangesMap(XSSFSheet sheet)

getColor

public static java.lang.String getColor(XSSFColor color)