com.dpslink.base.util

Class HtmlToExcel.XmlCell

java.lang.Object

com.dpslink.base.util.HtmlToExcel.XmlCell

All Implemented Interfaces:

java.io.Serializable

Enclosing class:

HtmlToExcel

protected class HtmlToExcel.XmlCell
extends java.lang.Object
implements java.io.Serializable

Inner class that defines a table cell node in the XML document and handles translation of the XML table cell to an Excel spreadsheet cell.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private int	__index The cell's spreadsheet column index.
private org.w3c.dom.Node	__node An XML document table cell node.
private HtmlToExcel.XmlTable	__parent The cell's parent XML table object.
private static long	serialVersionUID The class' serialization version id.

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	XmlCell(HtmlToExcel.XmlTable parent, org.w3c.dom.Node node, int index) Constructs a new XML table cell node.

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	getAttr(java.lang.String name) Returns an attribute value from the XML cell node.
protected int	getColSpan() Returns the column span value for the cell.
protected java.lang.String	getValue() Returns the text value for the cell.
protected boolean	isText(java.lang.String s) Answers if the given string is a text value.
protected java.util.Date	parseDate(java.lang.String s) Parses the given string as a date and returns the result.
protected java.lang.Number	parseNumber(java.lang.String s) Parses the given string as a number and returns the result.
protected void	toExcel() Performs translation of the XML table cell to an Excel spreadsheet cell.

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

__parent

private HtmlToExcel.XmlTable __parent

The cell's parent XML table object.

__node

private org.w3c.dom.Node __node

An XML document table cell node.

__index

private int __index

The cell's spreadsheet column index.

Constructor Detail

XmlCell

protected XmlCell(HtmlToExcel.XmlTable parent,
                  org.w3c.dom.Node node,
                  int index)

Constructs a new XML table cell node.

Parameters:

parent - (XmlTable) The cell's parent XML table object.

node - (Node) A table cell node from the XML document object.

index - (int) The column index of the cell (zero based).

Method Detail

getAttr

protected java.lang.String getAttr(java.lang.String name)

Returns an attribute value from the XML cell node.

Parameters:

name - (String) The name of the attribute to retrieve.

Returns:

String - The attribute's value.

getColSpan

protected int getColSpan()

Returns the column span value for the cell.

Returns:

int - The cell's defined column span value. Returns 1 (one) if no column span value is defined.

getValue

protected java.lang.String getValue()

Returns the text value for the cell.

Returns:

String - The cell's text value.

isText

protected boolean isText(java.lang.String s)

Answers if the given string is a text value. The string is considered a text value if it contains at least one occurrence of the alphabet letters 'A' through 'Z' or 'a' through 'z'.

Parameters:

s - (String) The string to check.

Returns:

boolean - true if the string is a text value, otherwise false.

parseDate

protected java.util.Date parseDate(java.lang.String s)

Parses the given string as a date and returns the result.

Parameters:

s - (string) The string to parse.

Returns:

Date - The parsed date or null if the string could could not be parsed into a date.

parseNumber

protected java.lang.Number parseNumber(java.lang.String s)

Parses the given string as a number and returns the result.

Parameters:

s - (string) The string to parse.

Returns:

Number - The parsed number or null if the string could not be parsed into a number.

toExcel

protected void toExcel()
                throws java.lang.Exception

Performs translation of the XML table cell to an Excel spreadsheet cell.

Throws:

java.lang.Exception - - if an error occurs during processing.