Page tree

Versions Compared

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}{signature:
}
Signature
vb.net
vb.net
Public Function CreateRange(ByVal rangeFormula As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example "=Sheet1\
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.

{param} {returns}A {{Range}} object representing the range of cells created.{returns} {example}{code:csharp|title=C#}

Returns

A Range object representing the range of cells created.

Example
Code Block
csharp
csharp
titleC#

Range rng = wb.CreateRange("=Sheet1!A1:G10");
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim rng As Range = wb.CreateRange("=Sheet1!A1:G10")
{code} {example}