br.com.tecsinapse.exporter

Class ExcelUtil

java.lang.Object

br.com.tecsinapse.exporter.ExcelUtil

public class ExcelUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
ExcelUtil()

Method Summary

Methods

Modifier and Type	Method and Description
static void	export(String name, Table t) Deprecated. use void exportXls(String name, Table t) instead.
static void	exportCsv(String name, Table t, String chartsetName)
static void	exportCsv(Table t, String chartsetName, OutputStream out)
static void	exportCsvZip(String name, Table t, String charsetName)
static void	exportSXlsx(String name, Table t)
static void	exportTxt(String name, Table t, String chartsetName)
static void	exportXls(String name, Table t)
static void	exportXlsx(String name, Table t) Prefira void exportSXlsx(String name, Table t) por fazer cache em disco e ser mais otimizado
static int	getColumnIndexByColumnName(String columnName)
static String	getColumnNameByColumnIndex(int columnIndex)
static File	getCsvFile(Table t, File f, String charsetName)
static File	getCsvFile(Table t, String fileName, String charsetName)
static File	getSvFile(Table t, String file, String charsetName, char separator)
static File	getXlsFile(Table t, String file)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelUtil

public ExcelUtil()

Method Detail

export

@Deprecated
public static void export(String name,
                     Table t)
                   throws IOException

Deprecated. use void exportXls(String name, Table t) instead.

Throws:

IOException

exportXls

public static void exportXls(String name,
             Table t)
                      throws IOException

Throws:

IOException

exportXlsx

public static void exportXlsx(String name,
              Table t)
                       throws IOException

Prefira void exportSXlsx(String name, Table t) por fazer cache em disco e ser mais otimizado

Parameters:

name -

t -

Throws:

IOException

exportSXlsx

public static void exportSXlsx(String name,
               Table t)
                        throws IOException

Throws:

IOException

exportCsvZip

public static void exportCsvZip(String name,
                Table t,
                String charsetName)
                         throws IOException

Throws:

IOException

exportCsv

public static void exportCsv(String name,
             Table t,
             String chartsetName)
                      throws IOException

Throws:

IOException

exportTxt

public static void exportTxt(String name,
             Table t,
             String chartsetName)
                      throws IOException

Throws:

IOException

exportCsv

public static void exportCsv(Table t,
             String chartsetName,
             OutputStream out)
                      throws IOException

Throws:

IOException

getCsvFile

public static File getCsvFile(Table t,
              String fileName,
              String charsetName)
                       throws IOException

Throws:

IOException

getCsvFile

public static File getCsvFile(Table t,
              File f,
              String charsetName)
                       throws IOException

Throws:

IOException

getSvFile

public static File getSvFile(Table t,
             String file,
             String charsetName,
             char separator)
                      throws IOException

Throws:

IOException

getXlsFile

public static File getXlsFile(Table t,
              String file)
                       throws IOException

Throws:

IOException

getColumnIndexByColumnName

public static int getColumnIndexByColumnName(String columnName)

getColumnNameByColumnIndex

public static String getColumnNameByColumnIndex(int columnIndex)