br.com.tecsinapse.dataio.util

Class WorkbookUtil

java.lang.Object

br.com.tecsinapse.dataio.util.WorkbookUtil

public class WorkbookUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
WorkbookUtil()

Method Summary

Modifier and Type	Method and Description
static boolean	isBlank(org.apache.poi.ss.usermodel.Cell cell)
static boolean	isFormula(org.apache.poi.ss.usermodel.Cell cell)
static boolean	isNumber(org.apache.poi.ss.usermodel.Cell cell)
static boolean	isString(org.apache.poi.ss.usermodel.Cell cell)
static boolean	isStringEmpty(org.apache.poi.ss.usermodel.Cell cell)
static WorkbookUtil	newWorkbookUtil()
static Color	toAwtColor(org.apache.poi.hssf.util.HSSFColor hssfColor)
static org.apache.poi.xssf.usermodel.IndexedColorMap	toIndexedColorMap(org.apache.poi.hssf.util.HSSFColor hssfColor)
static byte[]	toRgbByte(org.apache.poi.hssf.util.HSSFColor hssfColor)
org.apache.poi.ss.usermodel.Workbook	toWorkBook(org.apache.poi.ss.usermodel.Workbook wb, List<Table> tables)
org.apache.poi.ss.usermodel.Workbook	toWorkBook(org.apache.poi.ss.usermodel.Workbook wb, Table table)

Methods inherited from class java.lang.Object

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

Constructor Detail

WorkbookUtil

public WorkbookUtil()

Method Detail

newWorkbookUtil

public static WorkbookUtil newWorkbookUtil()

toWorkBook

public org.apache.poi.ss.usermodel.Workbook toWorkBook(org.apache.poi.ss.usermodel.Workbook wb,
                                                       List<Table> tables)

toWorkBook

public org.apache.poi.ss.usermodel.Workbook toWorkBook(org.apache.poi.ss.usermodel.Workbook wb,
                                                       Table table)

toRgbByte

public static byte[] toRgbByte(org.apache.poi.hssf.util.HSSFColor hssfColor)

toIndexedColorMap

public static org.apache.poi.xssf.usermodel.IndexedColorMap toIndexedColorMap(org.apache.poi.hssf.util.HSSFColor hssfColor)

toAwtColor

public static Color toAwtColor(org.apache.poi.hssf.util.HSSFColor hssfColor)

isString

public static boolean isString(org.apache.poi.ss.usermodel.Cell cell)

isNumber

public static boolean isNumber(org.apache.poi.ss.usermodel.Cell cell)

isFormula

public static boolean isFormula(org.apache.poi.ss.usermodel.Cell cell)

isStringEmpty

public static boolean isStringEmpty(org.apache.poi.ss.usermodel.Cell cell)

isBlank

public static boolean isBlank(org.apache.poi.ss.usermodel.Cell cell)