public class Excel extends StructSupport implements Cloneable, Struct
Collection.Key
Modifier and Type | Field and Description |
---|---|
static short |
FORMAT_HSSF |
static short |
FORMAT_SXSSF |
static short |
FORMAT_UNDEFINED |
static short |
FORMAT_XSSF |
static String |
HSSF_FORMAT |
static String |
SXSSF_FORMAT |
static String |
XSSF_FORMAT |
TYPE_LINKED, TYPE_REGULAR, TYPE_SOFT, TYPE_SYNC, TYPE_WEAKED
Constructor and Description |
---|
Excel(String sheetName,
short xmlFormat,
int rows) |
Modifier and Type | Method and Description |
---|---|
void |
clear()
clears the collection
|
boolean |
containsKey(Collection.Key key)
contains this key
|
Collection |
duplicate(boolean deepCopy) |
Iterator<Map.Entry<Collection.Key,Object>> |
entryIterator() |
Object |
get(Collection.Key key)
return a value from the collection
|
Object |
get(Collection.Key key,
Object defaultValue)
return a value from the collection, if key doesn't exist, dont throw a exception, reeturns null
|
Struct |
getSummaryInfo() |
Iterator<Collection.Key> |
keyIterator() |
Collection.Key[] |
keys() |
Iterator<String> |
keysAsStringIterator() |
Object |
remove(Collection.Key key)
removes value from collection and return it when it exists, otherwise throws a exception
|
Object |
removeEL(Collection.Key key)
removes value from collection and return it when it exists, otherwise returns null
|
Object |
set(Collection.Key key,
Object value)
sets a value to the collection
|
Object |
setEL(Collection.Key key,
Object value)
sets a value to the collection, if key doesn't exist, dont throw a exception, returns null
|
void |
setValue(int rowNumber,
int columnNumber,
String value) |
int |
size() |
Iterator<Object> |
valueIterator() |
void |
write(Resource res,
String password) |
call, callWithNamedValues, castToBoolean, castToBooleanValue, castToDateTime, castToDateTime, castToDoubleValue, castToDoubleValue, castToString, castToString, clone, compareTo, compareTo, compareTo, compareTo, containsKey, containsKey, containsValue, entrySet, equals, get, get, get, get, get, getIterator, invalidKey, isEmpty, keySet, put, putAll, remove, set, set, setEL, setEL, sizeOf, toDumpData, toString, values
getClass, hashCode, notify, notifyAll, wait, wait, wait
clone, containsKey, get, get, set, setEL
getIterator
containsKey, containsValue, entrySet, equals, get, hashCode, isEmpty, keySet, put, putAll, remove, values
call, callWithNamedValues, get, get, set, setEL
toDumpData
castToBoolean, castToBooleanValue, castToDateTime, castToDateTime, castToDoubleValue, castToDoubleValue, castToString, castToString, compareTo, compareTo, compareTo, compareTo
public static final short FORMAT_UNDEFINED
public static final short FORMAT_XSSF
public static final short FORMAT_HSSF
public static final short FORMAT_SXSSF
public static final String XSSF_FORMAT
public static final String HSSF_FORMAT
public static final String SXSSF_FORMAT
public void setValue(int rowNumber, int columnNumber, String value) throws CasterException
CasterException
public Struct getSummaryInfo()
public int size()
size
in interface Map
size
in interface Collection
public Collection.Key[] keys()
keys
in interface Collection
public Object remove(Collection.Key key) throws PageException
Collection
remove
in interface Collection
key
- key of the collectionPageException
public Object removeEL(Collection.Key key)
Collection
removeEL
in interface Collection
key
- key of the collectionpublic void clear()
Collection
clear
in interface Map
clear
in interface Collection
public Object get(Collection.Key key) throws PageException
Collection
get
in interface Collection
key
- key of the value to get must be lower casePageException
public Object get(Collection.Key key, Object defaultValue)
Collection
get
in interface Collection
key
- key of the value to getpublic Object set(Collection.Key key, Object value) throws PageException
Collection
set
in interface Collection
key
- key of the new valuevalue
- value to setPageException
public Object setEL(Collection.Key key, Object value)
Collection
setEL
in interface Collection
key
- key of the value to getvalue
- value to setpublic Collection duplicate(boolean deepCopy)
duplicate
in interface Collection
public boolean containsKey(Collection.Key key)
Collection
containsKey
in interface Collection
public Iterator<Collection.Key> keyIterator()
keyIterator
in interface Iteratorable
public Iterator<String> keysAsStringIterator()
keysAsStringIterator
in interface Iteratorable
keysAsStringIterator
in class StructSupport
public Iterator<Map.Entry<Collection.Key,Object>> entryIterator()
entryIterator
in interface Iteratorable
public Iterator<Object> valueIterator()
valueIterator
in interface Iteratorable
Copyright © 2015 Lucee