Page History

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#

{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
csharp	csharp
title	C#
Code Block
vb.net	title

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key