com.ontimize.util.xls

Class Poi3_5XLSExporterUtils

java.lang.Object

com.ontimize.util.xls.AbstractXLSExporter

com.ontimize.util.xls.Poi3_5XLSExporterUtils

All Implemented Interfaces:

XLSExporter

public class Poi3_5XLSExporterUtils
extends AbstractXLSExporter
implements XLSExporter

Factory to export to xls and xlsx using poi library (version 3.5, 3.6, 3.7, 3.8, 3.9).

For exporting to xls only requires:

• poi3.xfinal.jar
• poi-ooxml-3.x-FINAL
• commons-logging 1.1
• log4j 1.2.13

(x>=5, with the same x version for both (poi and ooxml) libraries)

For exporting to xls and xlsx requires:

• poi3.xfinal.jar
• poi-ooxml-3.x-FINAL
• commons-logging 1.1
• log4j 1.2.13
• xmlbeans-2.3.0
• dom4j-1.6.1
• ooxml-schemas-1.0

(x>=5, with the same x version for both (poi and ooxml) libraries)

Since:

5.2062EN

Author:

Imatia Innovation SL

Field Summary

Fields

Modifier and Type	Field and Description
static org.apache.poi.ss.usermodel.CellStyle	cs_currency
static org.apache.poi.ss.usermodel.CellStyle	cs_date
static org.apache.poi.ss.usermodel.CellStyle	cs_date_hour
static org.apache.poi.ss.usermodel.CellStyle	cs_percent
static org.apache.poi.ss.usermodel.CellStyle	cs_real
static org.apache.poi.ss.usermodel.CellStyle	cs_style
static String	dateFormat
static String	dateHourFormat
static DecimalFormat	decimalFormat
static String	decimalPattern
static DecimalFormatSymbols	dfs
protected static org.apache.poi.ss.usermodel.Drawing	drawing
protected static org.apache.poi.ss.usermodel.CreationHelper	helper
static int	MAX_ROWS_XLS
static int	MAX_ROWS_XLSX
static DecimalFormat	numericFormat
static String	numericPattern
static SimpleDateFormat	sdf
static SimpleDateFormat	sdfHour
protected static Charset	utf8charset

Fields inherited from class com.ontimize.util.xls.AbstractXLSExporter

CURRENCY_CELL, currencyPattern, currencySymbols, DATE_CELL, DATE_HOUR_CELL, DECIMAL_CELL, IMAGE_CELL, NUMERIC_CELL, PERCENT_CELL, REAL_CELL, TEXT_CELL

Constructor Summary

Constructors

Constructor and Description
Poi3_5XLSExporterUtils()

Method Summary

Methods

Modifier and Type	Method and Description
protected static float	calculateRowHeight(Hashtable<Object,Object> sqlColumnTypes) Calculates row height according to presence of images.
protected static List	checkSheetNames(int size, List sheetNames)
void	createXLS(EntityResult rs, File output, String sheetName, Hashtable hColumnRenderers, List columnSort, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, Hashtable hColumnRenderers, List columnSort, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, Hashtable hColumnRenderers, List columnSort, List columnStyles, List columnHeaderStyles, org.apache.poi.ss.usermodel.Workbook wb, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, Hashtable hColumnRenderers, List columnSort, List columnStyles, List columnHeaderStyles, org.apache.poi.ss.usermodel.Workbook wb, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, List columnSort, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, List columnSort, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, List columnSort, List columnStyles, List columnHeaderStyles, org.apache.poi.ss.usermodel.Workbook wb, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, File output, String sheetName, List columnSort, List columnStyles, List columnHeaderStyles, org.apache.poi.ss.usermodel.Workbook wb, boolean writeHeader, boolean xlsx, boolean openFile)
static void	createXLS(EntityResult rs, OutputStream os, String sheetName, Hashtable hColumnRenderers, List columnSort, boolean writeHeader, boolean xlsx)
static void	createXLS(EntityResult rs, OutputStream os, String sheetName, Hashtable hColumnRenderers, List columnSort, List columnStyles, List columnHeaderStyles, org.apache.poi.ss.usermodel.Workbook wb, boolean xlsx, boolean writeHeader)
static void	createXLS(List entityResultsList, OutputStream os, List sheetNames, Hashtable hColumnRenderers, List columnSort, boolean writeHeader)
static void	createXLS(List entityResultsList, OutputStream os, List sheetNames, Hashtable hColumnRenderers, List columnSort, boolean writeHeader, boolean xlsx)
static Object	createXSSFWorkbook()
static String	getDecimalPattern(DecimalFormatSymbols decimalSymbols)
static String	getNumericPattern(DecimalFormatSymbols decimalSymbols)
protected static void	setColumnStyle(org.apache.poi.ss.usermodel.Workbook wb, org.apache.poi.ss.usermodel.Sheet sheet, List orderColumns, List columnStyles, Hashtable hColumnRenderers, Hashtable hColumnTypes)
protected static void	writeLine(Object wb, org.apache.poi.xssf.usermodel.XSSFSheet sheet, List values, List orderColumns, Hashtable hColumnRenderers, List columnStyles, Hashtable hColumnTypes)
protected static void	writeLine(org.apache.poi.ss.usermodel.Workbook wb, org.apache.poi.ss.usermodel.Sheet sheet, List values, List order, Hashtable hColumnRenderers, Hashtable hColumnTypes)
protected static void	writeLine(org.apache.poi.ss.usermodel.Workbook wb, org.apache.poi.ss.usermodel.Sheet sheet, List values, List orderColumns, Hashtable hColumnRenderers, List columnStyles, Hashtable hColumnTypes)
protected static void	writeLineWithoutStyle(org.apache.poi.ss.usermodel.Workbook wb, org.apache.poi.ss.usermodel.Sheet sheet, List values, List orderColumns, Hashtable hColumnRenderers, List columnStyles, Hashtable hColumnTypes)
protected static void	writeSheet_(org.apache.poi.ss.usermodel.Workbook wb, EntityResult rs, List order, List columnStyles, List columnHeaderStyles, String sheetName, Hashtable hColumnRenderers, boolean writeHeader)
protected static void	writeSheet(org.apache.poi.ss.usermodel.Workbook wb, EntityResult rs, List order, List columnStyles, List columnHeaderStyles, String sheetName, Hashtable hColumnRenderers, boolean writeHeader)
protected static void	writeSheet(org.apache.poi.ss.usermodel.Workbook wb, EntityResult rs, List order, String sheetName, Hashtable hColumnRenderers, boolean writeHeader) Allow to define styles for columns instead of one by cell, increasing the performance.

Methods inherited from class com.ontimize.util.xls.AbstractXLSExporter

getCellType, getCurrencySymbol, getPercentSymbol

Methods inherited from class java.lang.Object

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

Field Detail

dfs

public static DecimalFormatSymbols dfs

numericPattern

public static String numericPattern

decimalPattern

public static String decimalPattern

utf8charset

protected static Charset utf8charset

numericFormat

public static DecimalFormat numericFormat

decimalFormat

public static DecimalFormat decimalFormat

dateFormat

public static String dateFormat

sdf

public static SimpleDateFormat sdf

dateHourFormat

public static String dateHourFormat

sdfHour

public static SimpleDateFormat sdfHour

cs_style

public static org.apache.poi.ss.usermodel.CellStyle cs_style

cs_date_hour

public static org.apache.poi.ss.usermodel.CellStyle cs_date_hour

cs_date

public static org.apache.poi.ss.usermodel.CellStyle cs_date

cs_currency

public static org.apache.poi.ss.usermodel.CellStyle cs_currency

cs_percent

public static org.apache.poi.ss.usermodel.CellStyle cs_percent

cs_real

public static org.apache.poi.ss.usermodel.CellStyle cs_real

helper

protected static org.apache.poi.ss.usermodel.CreationHelper helper

drawing

protected static org.apache.poi.ss.usermodel.Drawing drawing

MAX_ROWS_XLSX

public static final int MAX_ROWS_XLSX

See Also:

Constant Field Values

MAX_ROWS_XLS

public static final int MAX_ROWS_XLS

See Also:

Constant Field Values

Constructor Detail

Poi3_5XLSExporterUtils

public Poi3_5XLSExporterUtils()

Method Detail

getDecimalPattern

public static String getDecimalPattern(DecimalFormatSymbols decimalSymbols)

getNumericPattern

public static String getNumericPattern(DecimalFormatSymbols decimalSymbols)

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             boolean writeHeader,
             boolean xlsx,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public static void createXLS(List entityResultsList,
             OutputStream os,
             List sheetNames,
             Hashtable hColumnRenderers,
             List columnSort,
             boolean writeHeader,
             boolean xlsx)
                      throws IOException

Throws:

IOException

calculateRowHeight

protected static float calculateRowHeight(Hashtable<Object,Object> sqlColumnTypes)

Calculates row height according to presence of images.

Parameters:

sqlColumnTypes - Sql types

Returns:

row height

Since:

5.3.8

createXLS

public static void createXLS(List entityResultsList,
             OutputStream os,
             List sheetNames,
             Hashtable hColumnRenderers,
             List columnSort,
             boolean writeHeader)
                      throws IOException

Throws:

IOException

createXLS

public static void createXLS(EntityResult rs,
             OutputStream os,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             boolean writeHeader,
             boolean xlsx)
                      throws IOException

Throws:

IOException

checkSheetNames

protected static List checkSheetNames(int size,
                   List sheetNames)

writeSheet

protected static void writeSheet(org.apache.poi.ss.usermodel.Workbook wb,
              EntityResult rs,
              List order,
              String sheetName,
              Hashtable hColumnRenderers,
              boolean writeHeader)

Allow to define styles for columns instead of one by cell, increasing the performance.

Parameters:

wb -

columns -

Since:

5.2080EN

setColumnStyle

protected static void setColumnStyle(org.apache.poi.ss.usermodel.Workbook wb,
                  org.apache.poi.ss.usermodel.Sheet sheet,
                  List orderColumns,
                  List columnStyles,
                  Hashtable hColumnRenderers,
                  Hashtable hColumnTypes)

writeSheet

protected static void writeSheet(org.apache.poi.ss.usermodel.Workbook wb,
              EntityResult rs,
              List order,
              List columnStyles,
              List columnHeaderStyles,
              String sheetName,
              Hashtable hColumnRenderers,
              boolean writeHeader)

writeLineWithoutStyle

protected static void writeLineWithoutStyle(org.apache.poi.ss.usermodel.Workbook wb,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         List values,
                         List orderColumns,
                         Hashtable hColumnRenderers,
                         List columnStyles,
                         Hashtable hColumnTypes)

writeSheet_

protected static void writeSheet_(org.apache.poi.ss.usermodel.Workbook wb,
               EntityResult rs,
               List order,
               List columnStyles,
               List columnHeaderStyles,
               String sheetName,
               Hashtable hColumnRenderers,
               boolean writeHeader)

writeLine

protected static void writeLine(org.apache.poi.ss.usermodel.Workbook wb,
             org.apache.poi.ss.usermodel.Sheet sheet,
             List values,
             List orderColumns,
             Hashtable hColumnRenderers,
             List columnStyles,
             Hashtable hColumnTypes)

writeLine

protected static void writeLine(Object wb,
             org.apache.poi.xssf.usermodel.XSSFSheet sheet,
             List values,
             List orderColumns,
             Hashtable hColumnRenderers,
             List columnStyles,
             Hashtable hColumnTypes)

writeLine

protected static void writeLine(org.apache.poi.ss.usermodel.Workbook wb,
             org.apache.poi.ss.usermodel.Sheet sheet,
             List values,
             List order,
             Hashtable hColumnRenderers,
             Hashtable hColumnTypes)

createXLS

public static void createXLS(EntityResult rs,
             OutputStream os,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             List columnStyles,
             List columnHeaderStyles,
             org.apache.poi.ss.usermodel.Workbook wb,
             boolean xlsx,
             boolean writeHeader)
                      throws Exception

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             List columnStyles,
             List columnHeaderStyles,
             org.apache.poi.ss.usermodel.Workbook wb,
             boolean writeHeader,
             boolean xlsx,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXSSFWorkbook

public static Object createXSSFWorkbook()

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             boolean writeHeader,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             Hashtable hColumnRenderers,
             List columnSort,
             List columnStyles,
             List columnHeaderStyles,
             org.apache.poi.ss.usermodel.Workbook wb,
             boolean writeHeader,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             List columnSort,
             boolean writeHeader,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             List columnSort,
             boolean writeHeader,
             boolean xlsx,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             List columnSort,
             List columnStyles,
             List columnHeaderStyles,
             org.apache.poi.ss.usermodel.Workbook wb,
             boolean writeHeader,
             boolean xlsx,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception

createXLS

public void createXLS(EntityResult rs,
             File output,
             String sheetName,
             List columnSort,
             List columnStyles,
             List columnHeaderStyles,
             org.apache.poi.ss.usermodel.Workbook wb,
             boolean writeHeader,
             boolean openFile)
               throws Exception

Specified by:

createXLS in interface XLSExporter

Throws:

Exception