OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 7

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

Creates a Range of cells from a specified formula. A Range is a collection of Area s; an Area area is a rectangular collection of cells.

Signature
C#
C#
 public Range CreateRange(System.String rangeFormula)
Signature
vb.net
vb.net
Public Function CreateRange(ByVal rangeFormula As String) As Range
Parameters
Param
rangeFormula
rangeFormula

Formula representing the range, for example "=Sheet1!A1:G10". The formula must be three-dimensional (specify a sheet), and can include only sheet and cell references, and operators joining those references (range ':', intersection ' ', and union ','). Functions that return ranges cannot be used.

Returns

A Range object representing the range of cells created.

Example
Code Block
csharp
csharp
titleC#
Range rng = wb.CreateRange("=Sheet1!A1:G10");
Code Block
vb.net
vb.net
titlevb.net
Dim rng As Range = wb.CreateRange("=Sheet1!A1:G10")