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

Class XlsxToHtmlConverter

AbstractExcelConverter
net.datenwerke.rs.jxlsreport.service.jxlsreport.utils.XlsxToHtmlConverter
public class XlsxToHtmlConverter extends AbstractExcelConverter
adapted from Sergey Vladimirov (vlsergey {at} gmail {dot} com)

  • Constructor Details

    • XlsxToHtmlConverter

      public XlsxToHtmlConverter(Document doc)

    • XlsxToHtmlConverter

      public XlsxToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)

  • Method Details

    • getCssClassPrefixCell

      public String getCssClassPrefixCell()

    • getCssClassPrefixDiv

      public String getCssClassPrefixDiv()

    • getCssClassPrefixRow

      public String getCssClassPrefixRow()

    • getCssClassPrefixTable

      public String getCssClassPrefixTable()

    • getDocument

      public Document getDocument()

    • isUseDivsToSpan

      public boolean isUseDivsToSpan()

    • processWorkbook

      public void processWorkbook(XSSFWorkbook workbook)

    • setCssClassPrefixCell

      public void setCssClassPrefixCell(String cssClassPrefixCell)

    • setCssClassPrefixDiv

      public void setCssClassPrefixDiv(String cssClassPrefixDiv)

    • setCssClassPrefixRow

      public void setCssClassPrefixRow(String cssClassPrefixRow)

    • setCssClassPrefixTable

      public void setCssClassPrefixTable(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 String getColor(XSSFColor color)