An Area object represents a rectangular set of cells.
Area
[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
Item(Int32, Int32)
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
ImportData(Microsoft.SharePoint.SPList, DataImportProperties)
ImportData(Microsoft.SharePoint.SPList)
ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)