com.intechcore.scomponents.scell.api.spreadsheet.fetch

Interface IWorksheetStorage

public interface IWorksheetStorage

Represents a container of services used to read or change the contents of the worksheet

Works with single cells or ranges of cells

Method Summary

Modifier and Type	Method and Description
IMapStorage<ICellBorders>	getBorderStorage()
IMapStorage<IColumn>	getColumnStorage()
IMapStorage<IComment>	getCommentStorage()
IFont	getCommonFont(IRangeAddress range) Gets the aggregated font styles for the given range
IStyle	getCommonStyle(IRangeAddress range) Aggregate styles to some structure
IMapStorage<IFont>	getFontStorage()
IMapStorage<IHyperlink>	getHyperlinkStorage()
IMapStorage<IDrawing>	getImageStorage()
IMapStorage<IRangeAddress>	getMergedCellsStorage()
IMapStorage<IRow>	getRowStorage()
IMapStorage<IStyle>	getStyleStorage()
IMapStorage<IValue>	getValueStorage()

Method Detail

getCommonFont

IFont getCommonFont(IRangeAddress range)

Gets the aggregated font styles for the given range

This method finds the differences between the cell fonts in the specified range.

This method sets the identical values of the compared font attributes to the returned IFont instance. When the differences between the compared font attributes are detected, the method sets the value of the detected difference in the returned IFont instance to null

Parameters:

range - the range in which the comparison takes place

Returns:

the aggregated IFont structure

getCommonStyle

IStyle getCommonStyle(IRangeAddress range)

Aggregate styles to some structure

This method finds the differences between the cell styles in the specified range

This method sets the identical values of the compared cell style attributes to the returned IStyle instance. When the differences between the compared cell styles attributes are detected, the method sets the value of the detected difference in the returned IStyle instance to null

Parameters:

range - the range in which the comparison takes place

Returns:

the aggregated IStyle structure

getValueStorage

IMapStorage<IValue> getValueStorage()

Returns:

the IMapStorage to get the values

See Also:

IValue

getStyleStorage

IMapStorage<IStyle> getStyleStorage()

Returns:

the IMapStorage to get the styles

See Also:

IStyle

getFontStorage

IMapStorage<IFont> getFontStorage()

Returns:

the IMapStorage to get the fonts

See Also:

IFont

getCommentStorage

IMapStorage<IComment> getCommentStorage()

Returns:

the IMapStorage to get the comments

See Also:

IComment

getHyperlinkStorage

IMapStorage<IHyperlink> getHyperlinkStorage()

Returns:

the IMapStorage to get the hyperlinks

See Also:

IHyperlink

getImageStorage

IMapStorage<IDrawing> getImageStorage()

Returns:

the IMapStorage to get the drawings

See Also:

IDrawing

getBorderStorage

IMapStorage<ICellBorders> getBorderStorage()

Returns:

the IMapStorage to get the border sides and styles

See Also:

IBorderStyle

getMergedCellsStorage

IMapStorage<IRangeAddress> getMergedCellsStorage()

Returns:

the IMapStorage to get info about merged areas on the spreadsheet

See Also:

IRangeAddress

getColumnStorage

IMapStorage<IColumn> getColumnStorage()

Returns:

the IMapStorage to get info about columns of the spreadsheet

See Also:

IColumn

getRowStorage

IMapStorage<IRow> getRowStorage()

Returns:

the IMapStorage to get info about rows of the spreadsheet

See Also:

IRow