ext.sulis.data

Class XlsData

Object

XlsData

public class XlsData
extends Object

commandline invocation to print version, expose methods.

Author:

mkraegeloh

Field Summary

Fields

Modifier and Type	Field and Description
static int	MAJOR
static int	MINOR

Constructor Summary

Constructors

Constructor and Description
XlsData(InputStream in, boolean useXSSF)
XlsData(String s)
XlsData(String s, Group data)
XlsData(String s, Group data, int window)
XlsData(String s, List<Map<String,String>> data)
XlsData(String s, List<Map<String,String>> data, int window)

Method Summary

Methods

Modifier and Type	Method and Description
List<String>	getColNames(int i)
List<String>	getColNames(String name)
int	getColOffset() get value off col offset
Group	getGroupFromXLS(String tabName)
List<Map<String,Object>>	getListFromXLS(int index)
List<Map<String,Object>>	getListFromXLS(String tabName)
List<List<Map<String,Object>>>	getListsFromXLS()
List<List<Object>>	getLListFromXLS(int index)
List<List<Object>>	getLListFromXLS(String tabName)
List<List<List<Object>>>	getLListsFromXLS()
int	getRowOffset() get value of row offset
Set<String>	getTabNames()
boolean	isEval() return value of evval flag
boolean	isHasHeaders() return value of hasHeaders flag
boolean	isTrimHeader() get value for trimHeader flag
static void	main(String[] args)
Group	ML2G(String name, List<List<Object>> in)
static String	nn(Att a)
static String	nn(Object o)
static String	nn(Object o, String d)
void	setColOffset(int colOffset) set value of columns offset, if > 0 will skip values (default is 0)
void	setEval(boolean eval) set value of eval flag - if true will evaluate cell formulas (default is false)
void	setHasHeaders(boolean hasHeaders) set value of hasHeaders flag - if true assume first row contains column names (default is true)
void	setRowOffset(int rowOffset) set value of row offset, if > 0 will skip rows (default is 0)
void	setTrimHeaders(boolean trimHeader) set value of trimHeader - if true will erase leading and trailing whitespace from header values (default is false)
void	updateSheet(int sheetNo, String col, List<Map<String,Object>> data)
void	write(String sheetName, List<String> colNames)

Methods inherited from class Object

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

Field Detail

MAJOR

public static final int MAJOR

See Also:

Constant Field Values

MINOR

public static final int MINOR

See Also:

Constant Field Values

Constructor Detail

XlsData

public XlsData(String s)
        throws Exception

Throws:

Exception

XlsData

public XlsData(InputStream in,
       boolean useXSSF)
        throws Exception

Throws:

Exception

XlsData

public XlsData(String s,
       List<Map<String,String>> data)
        throws Exception

Throws:

Exception

XlsData

public XlsData(String s,
       Group data,
       int window)
        throws Exception

Throws:

Exception

XlsData

public XlsData(String s,
       List<Map<String,String>> data,
       int window)
        throws Exception

Throws:

Exception

XlsData

public XlsData(String s,
       Group data)
        throws Exception

Throws:

Exception

Method Detail

isTrimHeader

public boolean isTrimHeader()

get value for trimHeader flag

Returns:

setTrimHeaders

public void setTrimHeaders(boolean trimHeader)

set value of trimHeader - if true will erase leading and trailing whitespace from header values (default is false)

Parameters:

trimHeader -

isEval

public boolean isEval()

return value of evval flag

Returns:

setEval

public void setEval(boolean eval)

set value of eval flag - if true will evaluate cell formulas (default is false)

Parameters:

eval -

isHasHeaders

public boolean isHasHeaders()

return value of hasHeaders flag

Returns:

setHasHeaders

public void setHasHeaders(boolean hasHeaders)

set value of hasHeaders flag - if true assume first row contains column names (default is true)

Parameters:

hasHeaders -

getColOffset

public int getColOffset()

get value off col offset

Returns:

setColOffset

public void setColOffset(int colOffset)

set value of columns offset, if > 0 will skip values (default is 0)

Parameters:

colOffset -

getRowOffset

public int getRowOffset()

get value of row offset

Returns:

setRowOffset

public void setRowOffset(int rowOffset)

set value of row offset, if > 0 will skip rows (default is 0)

Parameters:

colOffset -

getGroupFromXLS

public Group getGroupFromXLS(String tabName)
                      throws Exception

Throws:

Exception

getListFromXLS

public List<Map<String,Object>> getListFromXLS(int index)
                                        throws Exception

Throws:

Exception

getListsFromXLS

public List<List<Map<String,Object>>> getListsFromXLS()
                                               throws Exception

Throws:

Exception

getListFromXLS

public List<Map<String,Object>> getListFromXLS(String tabName)
                                        throws Exception

Throws:

Exception

getLListFromXLS

public List<List<Object>> getLListFromXLS(int index)
                                   throws Exception

Throws:

Exception

getLListsFromXLS

public List<List<List<Object>>> getLListsFromXLS()
                                          throws Exception

Throws:

Exception

getLListFromXLS

public List<List<Object>> getLListFromXLS(String tabName)
                                   throws Exception

Throws:

Exception

getTabNames

public Set<String> getTabNames()
                        throws Exception

Throws:

Exception

updateSheet

public void updateSheet(int sheetNo,
               String col,
               List<Map<String,Object>> data)
                 throws Exception

Throws:

Exception

write

public void write(String sheetName,
         List<String> colNames)
           throws Exception

Throws:

Exception

nn

public static String nn(Object o)

nn

public static String nn(Att a)

nn

public static String nn(Object o,
        String d)

getColNames

public List<String> getColNames(int i)

getColNames

public List<String> getColNames(String name)

ML2G

public Group ML2G(String name,
         List<List<Object>> in)

main

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

Throws:

Exception