An Area object represents a rectangular set of cells.

[DefaultMember("Item")]
 public sealed class Area
<DefaultMember("Item")> _
	Public NotInheritable Class Area

To create an Area object, call Worksheet.CreateArea


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          Area a = ws.CreateArea(4, 4, 15, 6);
        

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb(0)
          Dim a As Area = ws.CreateArea(4, 4, 15, 6)
        

Name

Description

AllColumnWidths

AllColumnWidthsInChars

AllRowsHeight

ArrayFormula

BorderAround

ColumnCount

Dimensions

FirstColumn

FirstRow

PopulatedCells

RowCount

WorksheetIndex

Name

Description

Item(Int32, Int32)

Name

Description

ApplyStyle(Style)

AutoFitHeight()

AutoFitWidth()

ClearContent()

CreateHyperlink(String)

GetColumnWidth(Int32)

GetColumnWidthInChars(Int32)

GetRowHeight(Int32)

GroupColumns(Boolean)

GroupRows(Boolean)

ImportData(Object()())

ImportData(Object()(), String(), DataImportProperties)

ImportData(System.Data.DataTable)

ImportData(System.Data.DataTable, DataImportProperties)

ImportData(System.Data.DataView)

ImportData(System.Data.DataView, DataImportProperties)

ImportData(Object(,))

ImportData(Object(,), String(), DataImportProperties)

ImportData(System.Data.IDataReader)

ImportData(System.Data.IDataReader, DataImportProperties)

MergeCells()

RemoveConditionalFormat()

SetColumnWidth(Int32, Double)

SetColumnWidthInChars(Int32, Double)

SetConditionalFormat(ConditionalFormat)

SetDataValidation(DataValidation)

SetRowHeight(Int32, Double)

SetStyle(Style)

ToString()

UngroupColumns()

UngroupRows()

Overload

Description

ImportData(Microsoft.SharePoint.SPList, DataImportProperties)

ImportData(Microsoft.SharePoint.SPList)

ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)

ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)