ActiveXLS.Charts
Class ExcelDataTable

System.Object
  ActiveXLS.Charts.ExcelDataTable

public class ExcelDataTable

extends System.Object

This class stores the data table information like line style, line color, line weight, legend key visibility, horizontal lines visibility, vertical lines visibility, outlines visibility, font name, font size, font bold, font italic, font underline style, font subscript, font superscript, font strikethrough, foreground color, visibility .

Constructor Summary

ExcelDataTable()
Defines an instance of the excel data table.

Method Summary

ExcelDataTable	Clone() Creates and returns a copy of this object.
System.String	getFont() Returns the font name used in the chart data table.
int	getFontSize() Returns the size of the font used in the chart data table.
System.Drawing.Color	getForeground() Returns the text color of the chart data table.
System.Drawing.Color	getLineColor() Returns the line color of the chart data table.
int	getLineStyle() Returns the line style of the chart data table.
int	getLineWeight() Returns the line weight of the chart data table.
int	getUnderlineStyle() Returns the underline style of the chart data table text.
bool	HasHorizontalLines() Returns a value showing if the data table has horizontal lines between entries.
bool	HasLegendKey() Returns a bool value representing the visibility of the data table legend key.
bool	HasOutlineLines() Returns a bool value representing the visibility of the data table outline lines.
bool	HasVerticalLines() Returns a bool value representing the visibility of the vertical lines between values.
bool	IsBold() Returns the bold setting of the chart data table font.
bool	IsItalic() Returns the italic setting of the chart data table font.
bool	IsStrikethrough() Returns the strikethrough setting of the chart data table font.
bool	IsSubscript() Returns the subscript setting of the chart data table font.
bool	IsSuperscript() Returns the superscript setting of the chart data table font.
bool	IsVisible() Returns the visible setting of the chart data table.
void	setBold(bool isBold) Sets the bold setting of the chart axis data table.
void	setFont(System.String fontName) Sets the chart data table font name.
void	setFontSettings(System.String fontName, int fontSize, bool isBold, bool isItalic, System.Drawing.Color foreground) Sets the font settings.
void	setFontSize(int fontSize) Sets the size of the chart data table font.
void	setForeground(System.Drawing.Color foreground) Sets the font color of the chart data table.
void	setHorizontalLines(bool value) Sets the visible value of the horizontal data table grid lines.
void	setItalic(bool isItalic) Sets the italic setting of the chart data table font.
void	setLegendKey(bool value) Sets the visibility of the data table legend key.
void	setLineColor(System.Drawing.Color lineColor) Sets the color of the chart data table line.
void	setLineStyle(int lineStyle) Sets the style of the chart data table line.
void	setLineWeight(int lineWeight) Sets the line weight of the chart data table.
void	setOutlineLines(bool value) Sets the visibility of the data table outline lines.
void	setStrikethrough(bool isStrikethrough) Sets the strikethrough setting of the chart data table font.
void	setSubscript(bool isSubscript) Sets the subscript setting of the chart data table font.
void	setSuperscript(bool isSuperscript) Sets the superscript setting of the chart data table font.
void	setUnderlineStyle(int underlineStyle) Sets the underline style of the chart data table text.
void	setVerticalLines(bool value) Sets the visible value of the vertical data table grid lines.
void	setVisible(bool value) Sets the visible setting of the chart data table.

Constructor Detail

ExcelDataTable

public ExcelDataTable()

Defines an instance of the excel data table.

Method Detail

IsVisible

public bool IsVisible()

Returns the visible setting of the chart data table.

Returns:

the visible setting of the chart data table

See Also:

setVisible(bool)

setVisible

public void setVisible(bool value)

Sets the visible setting of the chart data table.

Parameters:

value - the new value of the data table visible setting

See Also:

IsVisible()

getLineStyle

public int getLineStyle()

Returns the line style of the chart data table. Possible values are available in Chart class.

Returns:

the line style of the chart data table

See Also:

setLineStyle(int)

setLineStyle

public void setLineStyle(int lineStyle)

Sets the style of the chart data table line. Possible values are available in Chart class.

Parameters:

lineStyle - the new style of the chart data table line

See Also:

getLineStyle()

getLineColor

public System.Drawing.Color getLineColor()

Returns the line color of the chart data table.

Returns:

the line color of the chart data table

See Also:

setLineColor(System.Drawing.Color)

setLineColor

public void setLineColor(System.Drawing.Color lineColor)

Sets the color of the chart data table line.

Parameters:

lineColor - the new color of the chart data table line

See Also:

getLineColor()

getLineWeight

public int getLineWeight()

Returns the line weight of the chart data table. Possible values are available in Chart class.

Returns:

the line weight of the chart data table

See Also:

setLineWeight(int)

setLineWeight

public void setLineWeight(int lineWeight)

Sets the line weight of the chart data table. Possible values are available in Chart class.

Parameters:

lineWeight - the new value of the chart data table line weight

See Also:

getLineWeight()

HasLegendKey

public bool HasLegendKey()

Returns a bool value representing the visibility of the data table legend key.

Returns:

a bool value representing the visibility of the data table legend key

See Also:

setLegendKey(bool)

setLegendKey

public void setLegendKey(bool value)

Sets the visibility of the data table legend key.

Parameters:

value - the new value of the data table legend key visibility

See Also:

HasLegendKey()

HasHorizontalLines

public bool HasHorizontalLines()

Returns a value showing if the data table has horizontal lines between entries.

Returns:

a value showing if the data table has horizontal lines between entries

See Also:

setHorizontalLines(bool)

setHorizontalLines

public void setHorizontalLines(bool value)

Sets the visible value of the horizontal data table grid lines.

Parameters:

value - the new value of the horizontal data table grid lines visibility

See Also:

HasHorizontalLines()

HasVerticalLines

public bool HasVerticalLines()

Returns a bool value representing the visibility of the vertical lines between values.

Returns:

a bool value representing the visibility of the vertical lines between values.

See Also:

setVerticalLines(bool)

setVerticalLines

public void setVerticalLines(bool value)

Sets the visible value of the vertical data table grid lines.

Parameters:

value - the new value of the data table grid lines visibility

See Also:

HasVerticalLines()

HasOutlineLines

public bool HasOutlineLines()

Returns a bool value representing the visibility of the data table outline lines.

Returns:

a bool value representing the visibility of the data table outline lines.

See Also:

setOutlineLines(bool)

setOutlineLines

public void setOutlineLines(bool value)

Sets the visibility of the data table outline lines.

Parameters:

value - the new value of the data table outline lines visibility

See Also:

HasOutlineLines()

IsStrikethrough

public bool IsStrikethrough()

Returns the strikethrough setting of the chart data table font.

Returns:

the strikethrough setting of the chart data table font

See Also:

setStrikethrough(bool)

setStrikethrough

public void setStrikethrough(bool isStrikethrough)

Sets the strikethrough setting of the chart data table font.

Parameters:

isStrikethrough - the new value of the data table font strikethrough setting

See Also:

IsStrikethrough()

IsSuperscript

public bool IsSuperscript()

Returns the superscript setting of the chart data table font.

Returns:

the superscript setting of the chart data table font

See Also:

setSuperscript(bool)

setSuperscript

public void setSuperscript(bool isSuperscript)

Sets the superscript setting of the chart data table font.

Parameters:

isSuperscript - the new value of the chart data table font superscript setting

See Also:

IsSuperscript()

IsSubscript

public bool IsSubscript()

Returns the subscript setting of the chart data table font.

Returns:

the subscript setting of the chart data table font

See Also:

setSubscript(bool)

setSubscript

public void setSubscript(bool isSubscript)

Sets the subscript setting of the chart data table font.

Parameters:

isSubscript - the new value of the chart data table font subscript setting

See Also:

IsSubscript()

getUnderlineStyle

public int getUnderlineStyle()

Returns the underline style of the chart data table text. Possible values are available in FontSettings class.

Returns:

the underline style of the chart data table text

See Also:

setUnderlineStyle(int)

setUnderlineStyle

public void setUnderlineStyle(int underlineStyle)

Sets the underline style of the chart data table text. Possible values are available in FontSettings class.

Parameters:

underlineStyle - the new value of the data table text underline style

See Also:

getUnderlineStyle()

getFont

public System.String getFont()

Returns the font name used in the chart data table.

Returns:

the font name used in the chart data table

See Also:

setFont(System.String)

setFont

public void setFont(System.String fontName)

Sets the chart data table font name.

Parameters:

fontName - the new name of the chart data table font

See Also:

getFont()

getFontSize

public int getFontSize()

Returns the size of the font used in the chart data table.

Returns:

the size of the font used in the chart data table

See Also:

setFontSize(int)

setFontSize

public void setFontSize(int fontSize)

Sets the size of the chart data table font.

Parameters:

fontSize - the new size of the chart data table font

See Also:

getFontSize()

IsBold

public bool IsBold()

Returns the bold setting of the chart data table font.

Returns:

the bold setting of the chart data table font

See Also:

setBold(bool)

setBold

public void setBold(bool isBold)

Sets the bold setting of the chart axis data table.

Parameters:

isBold - - the new bold setting of the chart axis data table

See Also:

IsBold()

IsItalic

public bool IsItalic()

Returns the italic setting of the chart data table font.

Returns:

the italic setting of the chart data table font

See Also:

setItalic(bool)

setItalic

public void setItalic(bool isItalic)

Sets the italic setting of the chart data table font.

Parameters:

isItalic - the new italic setting of the chart data table font

See Also:

IsItalic()

setFontSettings

public void setFontSettings(System.String fontName,
                            int fontSize,
                            bool isBold,
                            bool isItalic,
                            System.Drawing.Color foreground)

Sets the font settings.

Parameters:

fontName - the name of the font

fontSize - the size of the font

isBold - the bold option of the font

isItalic - the italic option of the font

foreground - the foreground color

getForeground

public System.Drawing.Color getForeground()

Returns the text color of the chart data table.

Returns:

the text color of the chart data table

See Also:

setForeground(System.Drawing.Color)

setForeground

public void setForeground(System.Drawing.Color foreground)

Sets the font color of the chart data table.

Parameters:

foreground - the new font color of the chart data table

See Also:

getForeground()

Clone

public ExcelDataTable Clone()

Creates and returns a copy of this object.

Returns:

a clone of this instance.