Package org.fugerit.java.doc.mod.poi

Class PoiUtils

java.lang.Object

org.fugerit.java.doc.mod.poi.PoiUtils

public class PoiUtils
extends Object

Method Summary

Modifier and Type	Method	Description
static Consumer<Exception>	autoresizeFailHandler(boolean failOnAutoResizeError)
static void	autoSizeColumns(org.apache.poi.ss.usermodel.Workbook workbook)
static void	closeWorkbook(org.apache.poi.ss.usermodel.Workbook workbook, DocOutput docOutput)
static short	findClosestColorIndex(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook, String color)
static WorkbookHelper	newHelper(boolean xlsx, InputStream is)
static void	resizeSheet(org.apache.poi.ss.usermodel.Sheet s)
static void	xlsFontStyle(WorkbookHelper helper, org.apache.poi.ss.usermodel.Font font, DocCell cell)
static void	xlsFormatStyle(WorkbookHelper helper, org.apache.poi.ss.usermodel.CellStyle style, DocCell cell)
static void	xlsxFontStyle(WorkbookHelper helper, org.apache.poi.ss.usermodel.Font font, DocCell cell)
static void	xlsxFormatStyle(WorkbookHelper helper, org.apache.poi.ss.usermodel.CellStyle style, DocCell cell)

Methods inherited from class java.lang.Object

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

Method Detail

resizeSheet

public static void resizeSheet(org.apache.poi.ss.usermodel.Sheet s)

autoSizeColumns

public static void autoSizeColumns(org.apache.poi.ss.usermodel.Workbook workbook)

xlsxFormatStyle

public static void xlsxFormatStyle(WorkbookHelper helper,
                                   org.apache.poi.ss.usermodel.CellStyle style,
                                   DocCell cell)

xlsxFontStyle

public static void xlsxFontStyle(WorkbookHelper helper,
                                 org.apache.poi.ss.usermodel.Font font,
                                 DocCell cell)

findClosestColorIndex

public static short findClosestColorIndex(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook,
                                          String color)

xlsFormatStyle

public static void xlsFormatStyle(WorkbookHelper helper,
                                  org.apache.poi.ss.usermodel.CellStyle style,
                                  DocCell cell)

xlsFontStyle

public static void xlsFontStyle(WorkbookHelper helper,
                                org.apache.poi.ss.usermodel.Font font,
                                DocCell cell)

closeWorkbook

public static void closeWorkbook(org.apache.poi.ss.usermodel.Workbook workbook,
                                 DocOutput docOutput)
                          throws IOException

Throws:

IOException

newHelper

public static WorkbookHelper newHelper(boolean xlsx,
                                       InputStream is)
                                throws IOException

Throws:

IOException

autoresizeFailHandler

public static Consumer<Exception> autoresizeFailHandler(boolean failOnAutoResizeError)