Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
This method has been deprecated, as it is not the most efficient way to edit Column properties. Instead, use the
Obsolete
Wiki Markup
Signature
C#C#
{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.
Description

Excerpt

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

{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#}
 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
Parameters

...

The 0-based index of the first column.

...

The number of columns to include.

Returns

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

{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#}
Area a = ws.CreateAreaOfColumns(0, 25);
{code}
{code:vb.net
|title=vb.net
}
Dim a As Area = ws.CreateAreaOfColumns(0, 25){code}

{example}
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle