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
{obsolete}This method has been deprecated, as it is not the most efficient way to edit Column properties. Instead, use the [
Wiki Markup
Obsolete

This method has been deprecated, as it is not the most efficient way to edit Column properties. Instead, use the Worksheet.GetColumnProperties(Int32)

]

method

to

return

the

[

ColumnProperties

]

object

of

the

desired

column.

{obsolete} {description} {excerpt}Returns an [Area|Area] object representing all the cells in a specified group of columns. An area is a rectangular collection of cells.{excerpt} {signature:C#}

Description

Excerpt

Returns an Area object representing all the cells in a specified group of columns. An area is a rectangular collection of cells.

Signature
C#
C#
 public Area CreateAreaOfColumns(int firstCol, int numCols)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateAreaOfColumns(ByVal firstCol As Integer, ByVal numCols As Integer) As Area
{signature}
{parameters}
{param:firstCol}The 0\-based index of the first column.{param}
{param:numCols}The number of columns to include.{param}
{returns}An {{Area}} object representing the set of cells in the specified columns.{returns}
{example}{code:csharp|title=C#}
Parameters
Param
firstCol
firstCol

The 0-based index of the first column.

Param
numCols
numCols

The number of columns to include.

Returns

An Area object representing the set of cells in the specified columns.

Example
Code Block
csharp
csharp
titleC#

Area a = ws.CreateAreaOfColumns(0, 25);
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim a As Area = ws.CreateAreaOfColumns(0, 25)
{code} {example}