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

Since:

5.2062EN

Author:

Imatia Innovation SL

Field Summary

static java.lang.String	dateFormat
static java.lang.String	dateHourFormat
static java.text.DecimalFormat	decimalFormat
static java.lang.String	decimalPattern
static java.text.DecimalFormatSymbols	dfs
static java.text.DecimalFormat	numericFormat
static java.lang.String	numericPattern
static java.text.SimpleDateFormat	sdf
static java.text.SimpleDateFormat	sdfHour

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

CURRENCY_CELL, currencyPattern, currencySymbols, DATE_CELL, DATE_HOUR_CELL, DECIMAL_CELL, NUMERIC_CELL, TEXT_CELL

Constructor Summary

Poi3_5XLSExporterUtils()

Method Summary

protected static java.util.List	checkSheetNames(int size, java.util.List sheetNames)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, java.util.List columnStyles, java.util.List columnHeaderStyles, org.apache.poi.hssf.usermodel.HSSFWorkbook wb, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, java.util.List columnStyles, java.util.List columnHeaderStyles, org.apache.poi.hssf.usermodel.HSSFWorkbook wb, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.List columnSort, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.List columnSort, boolean writeHeader, boolean xlsx, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.List columnSort, java.util.List columnStyles, java.util.List columnHeaderStyles, org.apache.poi.hssf.usermodel.HSSFWorkbook wb, boolean writeHeader, boolean openFile)
void	createXLS(EntityResult rs, java.io.File output, java.lang.String sheetName, java.util.List columnSort, java.util.List columnStyles, java.util.List columnHeaderStyles, org.apache.poi.hssf.usermodel.HSSFWorkbook wb, boolean writeHeader, boolean xlsx, boolean openFile)
static void	createXLS(EntityResult rs, java.io.OutputStream os, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, boolean writeHeader, boolean xlsx)
static void	createXLS(EntityResult rs, java.io.OutputStream os, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, java.util.List columnSort, java.util.List columnStyles, java.util.List columnHeaderStyles, org.apache.poi.hssf.usermodel.HSSFWorkbook wb, boolean xlsx, boolean writeHeader)
static void	createXLS(java.util.List entityResultsList, java.io.OutputStream os, java.util.List sheetNames, java.util.Hashtable hColumnRenderers, java.util.List columnSort, boolean writeHeader)
static void	createXLS(java.util.List entityResultsList, java.io.OutputStream os, java.util.List sheetNames, java.util.Hashtable hColumnRenderers, java.util.List columnSort, boolean writeHeader, boolean xlsx)
static java.lang.Object	createXSSFWorkbook()
protected static void	writeLine(org.apache.poi.hssf.usermodel.HSSFWorkbook wb, org.apache.poi.hssf.usermodel.HSSFSheet sheet, java.util.List values, java.util.List order, java.util.Hashtable hColumnRenderers, java.util.Hashtable hColumnTypes)
protected static void	writeLine(org.apache.poi.hssf.usermodel.HSSFWorkbook wb, org.apache.poi.hssf.usermodel.HSSFSheet sheet, java.util.List values, java.util.List orderColumns, java.util.Hashtable hColumnRenderers, java.util.List columnStyles, java.util.Hashtable hColumnTypes)
protected static void	writeLine(java.lang.Object wb, org.apache.poi.xssf.usermodel.XSSFSheet sheet, java.util.List values, java.util.List orderColumns, java.util.Hashtable hColumnRenderers, java.util.List columnStyles, java.util.Hashtable hColumnTypes)
protected static void	writeSheet(org.apache.poi.hssf.usermodel.HSSFWorkbook wb, EntityResult rs, java.util.List order, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, boolean writeHeader)
protected static void	writeSheet(org.apache.poi.xssf.usermodel.XSSFWorkbook wb, EntityResult rs, java.util.List order, java.util.List columnStyles, java.util.List columnHeaderStyles, java.lang.String sheetName, java.util.Hashtable hColumnRenderers, boolean writeHeader)

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

getCellType, getCurrencySymbol

Methods inherited from class java.lang.Object

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

Field Detail

dfs

public static java.text.DecimalFormatSymbols dfs

numericPattern

public static java.lang.String numericPattern

decimalPattern

public static java.lang.String decimalPattern

numericFormat

public static java.text.DecimalFormat numericFormat

decimalFormat

public static java.text.DecimalFormat decimalFormat

dateFormat

public static java.lang.String dateFormat

sdf

public static java.text.SimpleDateFormat sdf

dateHourFormat

public static java.lang.String dateHourFormat

sdfHour

public static java.text.SimpleDateFormat sdfHour

Constructor Detail

Poi3_5XLSExporterUtils

public Poi3_5XLSExporterUtils()

Method Detail

createXLS

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

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

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

Throws:

java.io.IOException

createXLS

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

Throws:

java.io.IOException

createXLS

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

Throws:

java.io.IOException

checkSheetNames

protected static java.util.List checkSheetNames(int size,
                                                java.util.List sheetNames)

writeSheet

protected static void writeSheet(org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                                 EntityResult rs,
                                 java.util.List order,
                                 java.lang.String sheetName,
                                 java.util.Hashtable hColumnRenderers,
                                 boolean writeHeader)

writeSheet

protected static void writeSheet(org.apache.poi.xssf.usermodel.XSSFWorkbook wb,
                                 EntityResult rs,
                                 java.util.List order,
                                 java.util.List columnStyles,
                                 java.util.List columnHeaderStyles,
                                 java.lang.String sheetName,
                                 java.util.Hashtable hColumnRenderers,
                                 boolean writeHeader)

writeLine

protected static void writeLine(org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                                org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                                java.util.List values,
                                java.util.List orderColumns,
                                java.util.Hashtable hColumnRenderers,
                                java.util.List columnStyles,
                                java.util.Hashtable hColumnTypes)

writeLine

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

writeLine

protected static void writeLine(org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                                org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                                java.util.List values,
                                java.util.List order,
                                java.util.Hashtable hColumnRenderers,
                                java.util.Hashtable hColumnTypes)

createXLS

public static void createXLS(EntityResult rs,
                             java.io.OutputStream os,
                             java.lang.String sheetName,
                             java.util.Hashtable hColumnRenderers,
                             java.util.List columnSort,
                             java.util.List columnStyles,
                             java.util.List columnHeaderStyles,
                             org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                             boolean xlsx,
                             boolean writeHeader)
                      throws java.lang.Exception

Throws:

java.lang.Exception

createXLS

public void createXLS(EntityResult rs,
                      java.io.File output,
                      java.lang.String sheetName,
                      java.util.Hashtable hColumnRenderers,
                      java.util.List columnSort,
                      java.util.List columnStyles,
                      java.util.List columnHeaderStyles,
                      org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                      boolean writeHeader,
                      boolean xlsx,
                      boolean openFile)
               throws java.lang.Exception

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXSSFWorkbook

public static java.lang.Object createXSSFWorkbook()

createXLS

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

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

public void createXLS(EntityResult rs,
                      java.io.File output,
                      java.lang.String sheetName,
                      java.util.Hashtable hColumnRenderers,
                      java.util.List columnSort,
                      java.util.List columnStyles,
                      java.util.List columnHeaderStyles,
                      org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                      boolean writeHeader,
                      boolean openFile)
               throws java.lang.Exception

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

public void createXLS(EntityResult rs,
                      java.io.File output,
                      java.lang.String sheetName,
                      java.util.List columnSort,
                      boolean writeHeader,
                      boolean openFile)
               throws java.lang.Exception

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

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

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

public void createXLS(EntityResult rs,
                      java.io.File output,
                      java.lang.String sheetName,
                      java.util.List columnSort,
                      java.util.List columnStyles,
                      java.util.List columnHeaderStyles,
                      org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                      boolean writeHeader,
                      boolean xlsx,
                      boolean openFile)
               throws java.lang.Exception

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception

createXLS

public void createXLS(EntityResult rs,
                      java.io.File output,
                      java.lang.String sheetName,
                      java.util.List columnSort,
                      java.util.List columnStyles,
                      java.util.List columnHeaderStyles,
                      org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                      boolean writeHeader,
                      boolean openFile)
               throws java.lang.Exception

Specified by:

createXLS in interface XLSExporter

Throws:

java.lang.Exception