Package org.javlo.utils

Class XLSTools

java.lang.Object

org.javlo.utils.XLSTools

public class XLSTools
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static String	REQUEST_ATTRIBUTE_KEY
static String	TYPE

Constructor Summary

Constructors

Constructor	Description
XLSTools()

Method Summary

Modifier and Type	Method	Description
static String	cleanSheetName(String sheetName)
static Cell[][]	createArray(int x, int y)
static Cell[][]	getArray(ContentContext ctx, File file)
static Cell[][]	getArray(ContentContext ctx, File file, String sheetNames)
static Cell[][]	getArray(ContentContext ctx, URL url)
static Cell[][]	getArray(ContentContext ctx, URL url, String sheetNames)
static Map<String,Cell[][]>	getArrayXSLXAllSheet(ContentContext ctx, InputStream in)
static Cell[][]	getCellArray(String[][] array)
protected static Collection<String>	getExcelSheets(File xslxFile)
static List<Map<String,Cell>>	getItems(ContentContext ctx, Cell[][] data)
protected static Cell[][]	getXLSArray(ContentContext ctx, File xslxFile, String sheetName)
static Cell[][]	getXLSXArray(ContentContext ctx, File xslxFile, String sheetName)
static Cell[][]	getXLSXArray(ContentContext ctx, InputStream in, String sheetName)
static void	main(String[] args)
protected static String	renderCell(String content)
static void	structureExcelSheetOnCol(File excelFile, String referenceColomn, OutputStream out)	link all scheet with "synchroCol" col as referent
static void	test()
static void	test2()
static void	writeXLS(Cell[][] array, OutputStream out)
static void	writeXLSX(Map<String,Cell[][]> arrays, File file)
static void	writeXLSX(Map<String,Cell[][]> arrays, OutputStream out)
static void	writeXLSX(Cell[][] array, File out)
static void	writeXLSX(Cell[][] array, OutputStream out)
static void	writeXLSX(Cell[][] array, OutputStream out, File sourceFile, String sheetName)

Methods inherited from class java.lang.Object

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

Field Detail

REQUEST_ATTRIBUTE_KEY

public static final String REQUEST_ATTRIBUTE_KEY

See Also:

Constant Field Values

TYPE

public static final String TYPE

See Also:

Constant Field Values

Constructor Detail

XLSTools

public XLSTools()

Method Detail

getArray

public static Cell[][] getArray(ContentContext ctx,
                                File file)
                         throws Exception

Throws:

Exception

getArray

public static Cell[][] getArray(ContentContext ctx,
                                URL url)
                         throws Exception

Throws:

Exception

getArray

public static Cell[][] getArray(ContentContext ctx,
                                URL url,
                                String sheetNames)
                         throws Exception

Throws:

Exception

getArray

public static Cell[][] getArray(ContentContext ctx,
                                File file,
                                String sheetNames)
                         throws Exception

Throws:

Exception

getCellArray

public static Cell[][] getCellArray(String[][] array)

cleanSheetName

public static String cleanSheetName(String sheetName)

getXLSXArray

public static Cell[][] getXLSXArray(ContentContext ctx,
                                    File xslxFile,
                                    String sheetName)
                             throws Exception

Throws:

Exception

getArrayXSLXAllSheet

public static Map<String,Cell[][]> getArrayXSLXAllSheet(ContentContext ctx,
                                                              InputStream in)
                                                       throws IOException

Throws:

IOException

getXLSXArray

public static Cell[][] getXLSXArray(ContentContext ctx,
                                    InputStream in,
                                    String sheetName)
                             throws Exception

Throws:

Exception

createArray

public static Cell[][] createArray(int x,
                                   int y)
                            throws Exception

Throws:

Exception

getItems

public static final List<Map<String,Cell>> getItems(ContentContext ctx,
                                                          Cell[][] data)

getExcelSheets

protected static Collection<String> getExcelSheets(File xslxFile)
                                            throws Exception

Throws:

Exception

structureExcelSheetOnCol

public static void structureExcelSheetOnCol(File excelFile,
                                            String referenceColomn,
                                            OutputStream out)
                                     throws Exception

link all scheet with "synchroCol" col as referent

Parameters:

excelFile -

referenceColomn - , the title of the column with linked code between line if different sheet.

Throws:

Exception

getXLSArray

protected static Cell[][] getXLSArray(ContentContext ctx,
                                      File xslxFile,
                                      String sheetName)
                               throws Exception

Throws:

Exception

renderCell

protected static String renderCell(String content)

writeXLS

public static void writeXLS(Cell[][] array,
                            OutputStream out)
                     throws IOException

Throws:

IOException

writeXLSX

public static void writeXLSX(Cell[][] array,
                             File out)
                      throws IOException

Throws:

IOException

writeXLSX

public static void writeXLSX(Cell[][] array,
                             OutputStream out)
                      throws IOException

Throws:

IOException

writeXLSX

public static void writeXLSX(Map<String,Cell[][]> arrays,
                             File file)
                      throws IOException

Throws:

IOException

writeXLSX

public static void writeXLSX(Map<String,Cell[][]> arrays,
                             OutputStream out)
                      throws IOException

Throws:

IOException

writeXLSX

public static void writeXLSX(Cell[][] array,
                             OutputStream out,
                             File sourceFile,
                             String sheetName)
                      throws IOException

Throws:

IOException

main

public static void main(String[] args)
                 throws Exception

Throws:

Exception

test2

public static void test2()
                  throws Exception

Throws:

Exception

test

public static void test()
                 throws Exception

Throws:

Exception