com.extentech.ExtenXLS.binder
Class DataBoundCellRange

java.lang.Object
  com.extentech.ExtenXLS.CellRange
      com.extentech.ExtenXLS.binder.DataBoundCellRange

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

BeanBoundCellRange

public class DataBoundCellRange
extends CellRange

Binds a Cell range to a JDBC Recordset.

Since:

1.3

Version:

3.0

Author:

John McMahon -- Copyright ©2011Extentech Inc.

See Also:

ExtenDataObject, CellHandle, Serialized Form

Field Summary

Fields inherited from class com.extentech.ExtenXLS.CellRange

cells, COPY_CONTENTS, COPY_FORMATS, COPY_FORMULAS, DEBUG, REMOVE_MERGED_CELLS, RETAIN_MERGED_CELLS, xmlResponsePost, xmlResponsePre

Constructor Summary

DataBoundCellRange(String range, String field, WorkBook b, boolean createblanks)

DataBoundCellRange(String range, WorkBook b, boolean createblanks)

Method Summary

List	getAddedRows()
String	getChartSeriesAddition()
String	getChartSeriesBase()
String	getHlink(DataObject dobj, int t) Get the Hyperlink for the DataBoundCellRange
String	getQueryName()
Map	getRESTEmit()
static String	handleHlinkParams(String hl, String params, DataObject dobj, int t)
void	setAddedRows(List vector)
void	setChartSeriesAddition(String chartSeriesAddition)
void	setChartSeriesBase(String chartSeriesBase)
void	setCopyFormats(boolean b)
void	setDebug(boolean b)
void	setHlink(String string)
void	setHlinkParameters(String string)
void	setPageSize(int t)
void	setQueryName(String string)
void	setShiftRows(boolean b)
void	updateCells(Object dob, int off) update the databound cells with new data
void	updateCells(Object dob, int off, boolean overwriteFormulas) update the databound cells with new data

Methods inherited from class com.extentech.ExtenXLS.CellRange

addCellToRange, clear, clearContents, clearFormats, contains, contains, copy, getCellList, getCellRangeXML, getCellRecs, getCells, getCells, getColInts, getCols, getCreateBlanks, getEdgePositions, getHeight, getJSON, getJSON, getR1C1Range, getRange, getRangeCoords, getRowInts, getRows, getSheet, getWidth, getWorkBook, getXML, init, initCells, intersects, isMerged, mergeCells, removeCells, setAsPrintArea, setBorder, setCreateBlanks, setFormatID, setRange, setSheet, setURL, setWorkBook, toString, unMergeCells, update

Methods inherited from class java.lang.Object

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

Constructor Detail

DataBoundCellRange

public DataBoundCellRange(String range,
                          WorkBook b,
                          boolean createblanks)
                   throws com.extentech.formats.XLS.CellNotFoundException

Throws:

com.extentech.formats.XLS.CellNotFoundException

DataBoundCellRange

public DataBoundCellRange(String range,
                          String field,
                          WorkBook b,
                          boolean createblanks)
                   throws com.extentech.formats.XLS.CellNotFoundException

Throws:

com.extentech.formats.XLS.CellNotFoundException

Method Detail

setShiftRows

public void setShiftRows(boolean b)

setPageSize

public void setPageSize(int t)

updateCells

public void updateCells(Object dob,
                        int off)
                 throws Exception

update the databound cells with new data

Throws:

Exception

updateCells

public void updateCells(Object dob,
                        int off,
                        boolean overwriteFormulas)
                 throws Exception

update the databound cells with new data

Throws:

Exception

getHlink

public String getHlink(DataObject dobj,
                       int t)

Get the Hyperlink for the DataBoundCellRange

Returns:

the String value of the Hyperlinks

handleHlinkParams

public static String handleHlinkParams(String hl,
                                       String params,
                                       DataObject dobj,
                                       int t)

setHlink

public void setHlink(String string)

Parameters:

string -

getAddedRows

public List getAddedRows()

Returns:

setAddedRows

public void setAddedRows(List vector)

Parameters:

vector -

getQueryName

public String getQueryName()

Returns:

setQueryName

public void setQueryName(String string)

Parameters:

string -

setDebug

public void setDebug(boolean b)

Parameters:

b -

setCopyFormats

public void setCopyFormats(boolean b)

Parameters:

b -

setHlinkParameters

public void setHlinkParameters(String string)

Parameters:

string -

getChartSeriesAddition

public String getChartSeriesAddition()

setChartSeriesAddition

public void setChartSeriesAddition(String chartSeriesAddition)

getChartSeriesBase

public String getChartSeriesBase()

setChartSeriesBase

public void setChartSeriesBase(String chartSeriesBase)

getRESTEmit

public Map getRESTEmit()

Returns:

Returns the rESTEmit.