com.extentech.ExtenXLS.web
Class CellHandlingBean

java.lang.Object
  com.extentech.ExtenXLS.web.CellHandlingBean

public class CellHandlingBean
extends Object

CellHandlingBean is a class to ease some of the rote inputting and looking up of parameters in relation to functions within the WorkBookUpdateBean. It's primary purpose is to generate an array of CellHandles from parameters passed in, and to get all possible parameter/value changes out of the map (parsed URI string);

Author:

John :: [ Oct 20, 2007 ] :: Copyright ©2011Extentech Inc.

Method Summary

boolean	commitStyleChanges() Commits any non-null style changes to the workbook.
boolean	commitValueChanges() Commits any value changes to the cell.
String	getBackgroundColor()
String	getCellRange()
CellHandle[]	getCells() Get all the cellHandles referenced in this CellInfo.
String	getColor()
String	getFontFamily()
String	getFontSize()
String	getFontWeight()
String	getFormatPattern()
String	getLink()
String	getSheetName()
String	getTextAlign()
String	getTextDecoration()
void	setBackgroundColor(String backgroundColor)
void	setCellRange(String cellRange)
void	setColor(String color)
void	setFontFamily(String fontFamily)
void	setFontSize(String fontSize)
void	setFontWeight(String fontWeight)
void	setFormatPattern(String formatPattern)
void	setLink(String lnk)
void	setSheetName(String sheetName)
void	setTextAlign(String textAlign)
void	setTextDecoration(String textDecoration)
String	toString()

Methods inherited from class java.lang.Object

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

Method Detail

toString

public String toString()

Overrides:

toString in class Object

commitValueChanges

public boolean commitValueChanges()

Commits any value changes to the cell. This includes links that are set on the cell. Currently we are defaulting to add underlines to links.

commitStyleChanges

public boolean commitStyleChanges()

Commits any non-null style changes to the workbook. TODO: Currently the code that I pulled out of WBU.jsp just clones the first format in the bunch, updates the styles, and sets that to all the cells. Obviously we will want to revisit this and do a more specific job of only updating those sections of each style for each cell. This could get ugly in terms of xfs created and/or performance of checking all the existing ones for duplicates

getCells

public CellHandle[] getCells()

Get all the cellHandles referenced in this CellInfo. If any of the cells don't exist, pre-populate as BLANK cells so we can apply formatting.

Returns:

cellHandle[]

getCellRange

public String getCellRange()

setCellRange

public void setCellRange(String cellRange)

getFontSize

public String getFontSize()

setFontSize

public void setFontSize(String fontSize)

getFormatPattern

public String getFormatPattern()

setFormatPattern

public void setFormatPattern(String formatPattern)

getTextAlign

public String getTextAlign()

setTextAlign

public void setTextAlign(String textAlign)

getSheetName

public String getSheetName()

setSheetName

public void setSheetName(String sheetName)

getTextDecoration

public String getTextDecoration()

setTextDecoration

public void setTextDecoration(String textDecoration)

getFontWeight

public String getFontWeight()

setFontWeight

public void setFontWeight(String fontWeight)

getBackgroundColor

public String getBackgroundColor()

setBackgroundColor

public void setBackgroundColor(String backgroundColor)

getFontFamily

public String getFontFamily()

setFontFamily

public void setFontFamily(String fontFamily)

getColor

public String getColor()

setColor

public void setColor(String color)

getLink

public String getLink()

setLink

public void setLink(String lnk)