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

Defines a rectangular Area of cells in the worksheet.

Signature
C#
C#
 public Area CreateArea(System.String areaFormula)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateArea(ByVal areaFormula As String) As Area
{signature}
{parameters}
{param:areaFormula}A formula representing the area, 
Parameters
Param
areaFormula
areaFormula

A formula representing the area, e.g.

"A3:B5".

The

formula

must

be

local

to

the

worksheet

and

should

not

contain

a

sheet

reference.

{param} {returns}An {{Area}} object.{returns} {example}{code:csharp|title=C#}

Returns

An Area object.

Example
Code Block
csharp
csharp
titleC#

Area a = ws.CreateArea("B7:H24");
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim a As Area = ws.CreateArea("B7:H24")
{code} {example}