GrapeCity.Documents.Excel.RangeTemplateCellType

Class RangeTemplateCellType

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

RangeTemplate provide a template from a range of referenced worksheet, it can apply to a cell. It will render the cell same as the template and fill data differently.If the param row, col, rowCount, colCount not set , it will use the sheet's usedrange as the range scope.

public class RangeTemplateCellType : BaseCellType

Inheritance

object

BaseCellType

RangeTemplateCellType

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Constructors

RangeTemplateCellType(IRange)

Use the range to create a RangeTemplateCellType.

public RangeTemplateCellType(IRange range)

Parameters

range IRange

An IRange object that used to be referenced.

RangeTemplateCellType(IWorksheet, int, int, int, int)

Use a worksheet and it's range infos to create a RangeTemplateCellType.

public RangeTemplateCellType(IWorksheet worksheet, int row = 0, int column = 0, int rowCount = 0, int columnCount = 0)

Parameters

worksheet IWorksheet

An IWorksheet object that used to be referenced. The sheet could be an individual sheet outside the workbook.

row int

the template scope start row.

column int

the template scope start column.

rowCount int

the template scope row count.

columnCount int

the template scope column count.

Methods

UpdateTemplate(IRange)

Update the range that used to be referenced.

public void UpdateTemplate(IRange range)

Parameters

range IRange

An IRange object that used to be referenced.