Overview  Package   Class  Tree  Deprecated  Index  Help 
Ontimize 5.2072EN
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.ontimize.util.xls
Class PoiXLSExporterUtils

java.lang.Object
  extended bycom.ontimize.util.xls.PoiXLSExporterUtils
All Implemented Interfaces:
XLSExporter
public class PoiXLSExporterUtils
extends java.lang.Object
implements XLSExporter

Field Summary
static java.text.DecimalFormat decimalFormat
           
static java.text.DecimalFormatSymbols dfs
           
 
Constructor Summary
PoiXLSExporterUtils()
           
 
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)
           
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)
           
protected static void writeLine(org.apache.poi.hssf.usermodel.HSSFSheet sheet, java.util.List values)
           
protected static void writeSheet(org.apache.poi.hssf.usermodel.HSSFWorkbook wb, EntityResult rs, java.util.List order, java.lang.String sheetName, boolean writeHeader)
           
 
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

decimalFormat

public static java.text.DecimalFormat decimalFormat
Constructor Detail

PoiXLSExporterUtils

public PoiXLSExporterUtils()
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)
                      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)
                      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,
                                 boolean writeHeader)

writeLine

protected static void writeLine(org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                                java.util.List values)

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

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
Overview  Package   Class  Tree  Deprecated  Index  Help 
Ontimize
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD