org.javlo.utils

Class XLSTools

java.lang.Object

org.javlo.utils.XLSTools

public class XLSTools
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static String	REQUEST_ATTRIBUTE_KEY
static String	TYPE

Constructor Summary

Constructors

Constructor and Description
XLSTools()

Method Summary

Modifier and Type	Method and Description
static Cell[][]	createArray(int x, int y)
static Cell[][]	getArray(ContentContext ctx, File file)
static Cell[][]	getCellArray(String[][] array)
static List<Map<String,Cell>>	getItems(ContentContext ctx, Cell[][] data)
protected static Cell[][]	getXLSArray(ContentContext ctx, File xslxFile)
protected static Cell[][]	getXLSXArray(ContentContext ctx, File xslxFile)
static void	main(String[] args)
protected static String	renderCell(String content)
static void	writeXLS(Cell[][] array, OutputStream out)
static void	writeXLSX(Cell[][] array, OutputStream out)

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

getCellArray

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

getXLSXArray

protected static Cell[][] getXLSXArray(ContentContext ctx,
                                       File xslxFile)
                                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)

getXLSArray

protected static Cell[][] getXLSArray(ContentContext ctx,
                                      File xslxFile)
                               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,
                             OutputStream out)
                      throws IOException

Throws:

IOException

main

public static void main(String[] args)