ActiveXLS
Class ExcelFooter

System.Object
  ActiveXLS.ExcelFooter

public class ExcelFooter

extends System.Object

This class stores the footer information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.

Constructor Summary

ExcelFooter()
Defines an instance of the footer.

ExcelFooter(System.String text, System.String position)
Defines an instance of the footer having the specified text and position.

ExcelFooter(System.String text, System.String position, System.String fontName, int fontSize, bool isBold, bool isItalic)
Defines an instance of the footer having the specified text, position and font settings.

Method Summary

ExcelFooter	Clone() Creates and returns a copy of this object.
System.String	getFooterString() Returns the footer expression.
System.String	getPosition() Returns the position of the footer.
void	InsertBold() Sets the bold style for the values that will follow the insertion.
void	InsertDate() Appends the date to footer expression.
void	InsertDoubleUnderline() Sets the double underline style for the values that will follow the insertion.
void	InsertEnter() Appends the enter character to footer expression.
void	InsertFile() Appends the file name to footer expression.
void	InsertFont(System.String fontType) Sets the font type for the values that will follow the font insertion.
void	InsertFontSize(int fontSize) Sets the font size for the values that will follow the font size insertion.
void	InsertItalic() Sets the italic style for the values that will follow the insertion.
void	InsertPage() Appends the page number to footer expression.
void	InsertPages() Appends the total number of pages to footer expression.
void	InsertSingleUnderline() Sets the single underline style for the values that will follow the insertion.
void	InsertStrikethrough() Sets the strikethrough style for the values that will follow the insertion.
void	InsertSubscript() Sets the subscript style for the values that will follow the insertion.
void	InsertSuperscript() Sets the superscript style for the values that will follow the insertion.
void	InsertTab() Appends the tab character to footer expression.
void	InsertTime() Appends the date time to footer expression.
void	InsertValue(System.String value) Appends a string to footer expression.
void	RemoveBold() Removes the bold style for the values that will follow the insertion.
void	RemoveDoubleUnderline() Removes the double underline style for the values that will follow the insertion.
void	RemoveItalic() Removes the italic style for the values that will follow the insertion.
void	RemoveSingleUnderline() Removes the single underline style for the values that will follow the insertion.
void	RemoveStrikethrough() Removes the strikethrough style for the values that will follow the insertion.
void	RemoveSubscript() Removes the subscript style for the values that will follow the insertion.
void	RemoveSuperscript() Removes the superscript style for the values that will follow the insertion.
void	Reset() Clears the footer expression.
void	setFooterString(System.String text) Sets the footer expression.
void	setPosition(System.String position) Sets the position of the footer.

Constructor Detail

ExcelFooter

public ExcelFooter()

Defines an instance of the footer.

ExcelFooter

public ExcelFooter(System.String text,
                   System.String position)

Defines an instance of the footer having the specified text and position.

Parameters:

text - the text from the footer

position - the position of the footer. Possible values are available in Footer class.

ExcelFooter

public ExcelFooter(System.String text,
                   System.String position,
                   System.String fontName,
                   int fontSize,
                   bool isBold,
                   bool isItalic)

Defines an instance of the footer having the specified text, position and font settings.

Parameters:

text - the text from the footer

position - the position of the footer. Possible values are available in Footer class.

fontName - the font name of the footer

fontSize - the font size of the footer

isBold - the bold option of the footer

isItalic - the italic option of footer

Method Detail

getFooterString

public System.String getFooterString()

Returns the footer expression.

Returns:

the footer expression

See Also:

setFooterString(System.String)

setFooterString

public void setFooterString(System.String text)

Sets the footer expression.

Parameters:

text - the footer expression

See Also:

getFooterString()

getPosition

public System.String getPosition()

Returns the position of the footer. Possible values are available in Footer class.

Returns:

the position of the footer

See Also:

setPosition(System.String)

setPosition

public void setPosition(System.String position)

Sets the position of the footer. Possible values are available in Footer class.

Parameters:

position - the footer expression

See Also:

getPosition()

InsertValue

public void InsertValue(System.String value)

Appends a string to footer expression.

Parameters:

value - the value to be inserted

InsertFont

public void InsertFont(System.String fontType)

Sets the font type for the values that will follow the font insertion.

Parameters:

fontType - the font type

InsertFontSize

public void InsertFontSize(int fontSize)

Sets the font size for the values that will follow the font size insertion.

Parameters:

fontSize - the font size

InsertSingleUnderline

public void InsertSingleUnderline()

Sets the single underline style for the values that will follow the insertion.

See Also:

RemoveSingleUnderline()

RemoveSingleUnderline

public void RemoveSingleUnderline()

Removes the single underline style for the values that will follow the insertion.

See Also:

InsertSingleUnderline()

InsertDoubleUnderline

public void InsertDoubleUnderline()

Sets the double underline style for the values that will follow the insertion.

See Also:

RemoveDoubleUnderline()

RemoveDoubleUnderline

public void RemoveDoubleUnderline()

Removes the double underline style for the values that will follow the insertion.

See Also:

InsertDoubleUnderline()

InsertStrikethrough

public void InsertStrikethrough()

Sets the strikethrough style for the values that will follow the insertion.

See Also:

RemoveStrikethrough()

RemoveStrikethrough

public void RemoveStrikethrough()

Removes the strikethrough style for the values that will follow the insertion.

See Also:

InsertStrikethrough()

InsertSuperscript

public void InsertSuperscript()

Sets the superscript style for the values that will follow the insertion.

See Also:

RemoveSuperscript()

RemoveSuperscript

public void RemoveSuperscript()

Removes the superscript style for the values that will follow the insertion.

See Also:

InsertSuperscript()

InsertSubscript

public void InsertSubscript()

Sets the subscript style for the values that will follow the insertion.

See Also:

RemoveSubscript()

RemoveSubscript

public void RemoveSubscript()

Removes the subscript style for the values that will follow the insertion.

See Also:

InsertSubscript()

InsertBold

public void InsertBold()

Sets the bold style for the values that will follow the insertion.

See Also:

RemoveBold()

RemoveBold

public void RemoveBold()

Removes the bold style for the values that will follow the insertion.

See Also:

InsertBold()

InsertItalic

public void InsertItalic()

Sets the italic style for the values that will follow the insertion.

See Also:

RemoveItalic()

RemoveItalic

public void RemoveItalic()

Removes the italic style for the values that will follow the insertion.

See Also:

InsertItalic()

InsertPage

public void InsertPage()

Appends the page number to footer expression.

InsertPages

public void InsertPages()

Appends the total number of pages to footer expression.

InsertDate

public void InsertDate()

Appends the date to footer expression.

InsertTime

public void InsertTime()

Appends the date time to footer expression.

InsertFile

public void InsertFile()

Appends the file name to footer expression.

InsertTab

public void InsertTab()

Appends the tab character to footer expression.

InsertEnter

public void InsertEnter()

Appends the enter character to footer expression.

Reset

public void Reset()

Clears the footer expression.

Clone

public ExcelFooter Clone()

Creates and returns a copy of this object.

Returns:

a clone of this instance.