Range Class

Range class

Encapsulates the object that represents a range of cells within a spreadsheet.

type Range struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
AutoFill_Range	Automaticall fill the target range.
AutoFill_Range_AutoFillType	Automaticall fill the target range.
GetCurrentRegion	Returns a Range object that represents the current region.The current region is a range bounded by any combination of blank rows and blank columns.
GetHyperlinks	Gets all hyperlink in the range.
AddHyperlink	Adds a hyperlink to a specified cell or a range of cells.
GetEnumerator	Gets the enumerator for cells in this Range.
IsIntersect	Indicates whether the range is intersect.
Intersect	Returns a Range object that represents the rectangular intersection of two ranges.
UnionRanges	Returns the union result of two ranges.
GetRowCount	Gets the count of rows in the range.
GetColumnCount	Gets the count of columns in the range.
GetName	Gets or sets the name of the range.
SetName	Gets or sets the name of the range.
GetRefersTo	Gets the range’s refers to.
GetAddress	Gets address of the range.
IsBlank	Indicates whether the range contains values.
GetLeft	Gets the distance, in points, from the left edge of column A to the left edge of the range.
GetTop	Gets the distance, in points, from the top edge of row 1 to the top edge of the range.
GetWidth	Gets the width of a range in points.
GetHeight	Gets the width of a range in points.
GetFirstRow	Gets the index of the first row of the range.
GetFirstColumn	Gets the index of the first column of the range.
Merge	Combines a range of cells into a single cell.
UnMerge	Unmerges merged cells of this range.
PutValue	Puts a value into the range, if appropriate the value will be converted to other data type and cell’s number format will be reset.
GetValue	Gets and sets the value of the range.
SetValue	Gets and sets the value of the range.
SetStyle_Style_Bool	Apply the cell style.
ApplyStyle	Applies formats for a whole range.
SetStyle_Style	Sets the style of the range.
SetOutlineBorders_CellBorderType_CellsColor	Sets the outline borders around a range of cells with same border style and color.
SetOutlineBorders_CellBorderType_Color	Sets the outline borders around a range of cells with same border style and color.
SetOutlineBorders_CellBorderTypeArray_ColorArray	Sets out line borders around a range of cells.
SetOutlineBorder_BorderType_CellBorderType_CellsColor	Sets outline border around a range of cells.
SetOutlineBorder_BorderType_CellBorderType_Color	Sets outline border around a range of cells.
SetInsideBorders	Set inside borders of the range.
GetColumnWidth	Sets or gets the column width of this range
SetColumnWidth	Sets or gets the column width of this range
GetRowHeight	Sets or gets the height of rows in this range
SetRowHeight	Sets or gets the height of rows in this range
MoveTo	Move the current range to the dest range.
CopyData	Copies cell data (including formulas) from a source range.
CopyValue	Copies cell value from a source range.
CopyStyle	Copies style settings from a source range.
Copy_Range_PasteOptions	Copying the range with paste special options.
Transpose	Transpose (rotate) data from rows to columns or vice versa.
Copy_Range	Copies data (including formulas), formatting, drawing objects etc. from a source range.
Get	Gets Cell object in this range.
GetCellOrNull	Gets Cell object or null in this range.
GetOffset	Gets Range range by offset.
GetEntireColumn	Gets a Range object that represents the entire column (or columns) that contains the specified range.
GetEntireRow	Gets a Range object that represents the entire row (or rows) that contains the specified range.
GetWorksheet	Gets the Worksheetobject which contains this range.
ToString	Returns a string represents the current Range object.
ToImage	Converts the range to image.
ToJson	Convert the range to JSON value.
ToHtml	Convert the range to html .
Clear	Clears this range.
ClearContents	Clears the contents of this range.
ClearFormats	Clears the formats of this range.
ClearComments	Clears the comments of this range.
ClearHyperlinks	Only removes hyperlinks.