Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

Excerpt

An Area object represents a rectangular set of cells.

Signature
C#
C#
[DefaultMember("Item")]
 public sealed class Area
Signature
vb.net
vb.net
<DefaultMember("Item")> _
	Public NotInheritable Class Area
Remarks

To create an Area object, call Worksheet.CreateArea

Example
Code Block
csharp
csharp
titleC#
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          Area a = ws.CreateArea(4, 4, 15, 6);
        
Code Block
vbnet
vbnet
titlevb.net
          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)
        

Properties

Name

Description

AllColumnWidths

Excerpt Include
Area.AllColumnWidths
Area.AllColumnWidths
nopaneltrue

AllColumnWidthsInChars

Excerpt Include
Area.AllColumnWidthsInChars
Area.AllColumnWidthsInChars
nopaneltrue

AllRowsHeight

Excerpt Include
Area.AllRowsHeight
Area.AllRowsHeight
nopaneltrue

ArrayFormula

Excerpt Include
Area.ArrayFormula
Area.ArrayFormula
nopaneltrue

BorderAround

Excerpt Include
Area.BorderAround
Area.BorderAround
nopaneltrue

ColumnCount

Excerpt Include
Area.ColumnCount
Area.ColumnCount
nopaneltrue

Dimensions

Excerpt Include
Area.Dimensions
Area.Dimensions
nopaneltrue

FirstColumn

Excerpt Include
Area.FirstColumn
Area.FirstColumn
nopaneltrue

FirstRow

Excerpt Include
Area.FirstRow
Area.FirstRow
nopaneltrue

PopulatedCells

Excerpt Include
Area.PopulatedCells
Area.PopulatedCells
nopaneltrue

RowCount

Excerpt Include
Area.RowCount
Area.RowCount
nopaneltrue

WorksheetIndex

Excerpt Include
Area.WorksheetIndex
Area.WorksheetIndex
nopaneltrue

Indexers

Name

Description

Item(Int32, Int32)

Excerpt Include
Area.Item(Int32, Int32)
Area.Item(Int32, Int32)
nopaneltrue

Methods

Name

Description

ApplyStyle(Style)

Excerpt Include
Area.ApplyStyle(Style)
Area.ApplyStyle(Style)
nopaneltrue

AutoFitHeight()

Excerpt Include
Area.AutoFitHeight()
Area.AutoFitHeight()
nopaneltrue

AutoFitWidth()

Excerpt Include
Area.AutoFitWidth()
Area.AutoFitWidth()
nopaneltrue
CalculateFormulas() 
Excerpt Include
Area.CalculateFormulas()
Area.CalculateFormulas()
nopaneltrue

ClearContent()

Excerpt Include
Area.ClearContent()
Area.ClearContent()
nopaneltrue

CreateHyperlink(String)

Excerpt Include
Area.CreateHyperlink(String)
Area.CreateHyperlink(String)
nopaneltrue

GetColumnWidth(Int32)

Excerpt Include
Area.GetColumnWidth(Int32)
Area.GetColumnWidth(Int32)
nopaneltrue

GetColumnWidthInChars(Int32)

Excerpt Include
Area.GetColumnWidthInChars(Int32)
Area.GetColumnWidthInChars(Int32)
nopaneltrue

GetRowHeight(Int32)

Excerpt Include
Area.GetRowHeight(Int32)
Area.GetRowHeight(Int32)
nopaneltrue

GroupColumns(Boolean)

Excerpt Include
Area.GroupColumns(Boolean)
Area.GroupColumns(Boolean)
nopaneltrue

GroupRows(Boolean)

Excerpt Include
Area.GroupRows(Boolean)
Area.GroupRows(Boolean)
nopaneltrue

ImportData(Object()())

Excerpt Include
Area.ImportData(Object()())
Area.ImportData(Object()())
nopaneltrue

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

Excerpt Include
Area.ImportData(Object()(), String(), DataImportProperties)
Area.ImportData(Object()(), String(), DataImportProperties)
nopaneltrue

ImportData(System.Data.DataTable)

Excerpt Include
Area.ImportData(System.Data.DataTable)
Area.ImportData(System.Data.DataTable)
nopaneltrue

ImportData(System.Data.DataTable, DataImportProperties)

Excerpt Include
Area.ImportData(System.Data.DataTable, DataImportProperties)
Area.ImportData(System.Data.DataTable, DataImportProperties)
nopaneltrue

ImportData(System.Data.DataView)

Excerpt Include
Area.ImportData(System.Data.DataView)
Area.ImportData(System.Data.DataView)
nopaneltrue

ImportData(System.Data.DataView, DataImportProperties)

Excerpt Include
Area.ImportData(System.Data.DataView, DataImportProperties)
Area.ImportData(System.Data.DataView, DataImportProperties)
nopaneltrue

ImportData(Object(,))

Excerpt Include
Area.ImportData(Object(,))
Area.ImportData(Object(,))
nopaneltrue

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

Excerpt Include
Area.ImportData(Object(,), String(), DataImportProperties)
Area.ImportData(Object(,), String(), DataImportProperties)
nopaneltrue

ImportData(System.Data.IDataReader)

Excerpt Include
Area.ImportData(System.Data.IDataReader)
Area.ImportData(System.Data.IDataReader)
nopaneltrue

ImportData(System.Data.IDataReader, DataImportProperties)

Excerpt Include
Area.ImportData(System.Data.IDataReader, DataImportProperties)
Area.ImportData(System.Data.IDataReader, DataImportProperties)
nopaneltrue

MergeCells()

Excerpt Include
Area.MergeCells()
Area.MergeCells()
nopaneltrue

RemoveConditionalFormat()

Excerpt Include
Area.RemoveConditionalFormat()
Area.RemoveConditionalFormat()
nopaneltrue

SetColumnWidth(Int32, Double)

Excerpt Include
Area.SetColumnWidth(Int32, Double)
Area.SetColumnWidth(Int32, Double)
nopaneltrue

SetColumnWidthInChars(Int32, Double)

Excerpt Include
Area.SetColumnWidthInChars(Int32, Double)
Area.SetColumnWidthInChars(Int32, Double)
nopaneltrue

SetConditionalFormat(ConditionalFormat)

Excerpt Include
Area.SetConditionalFormat(ConditionalFormat)
Area.SetConditionalFormat(ConditionalFormat)
nopaneltrue

SetDataValidation(DataValidation)

Excerpt Include
Area.SetDataValidation(DataValidation)
Area.SetDataValidation(DataValidation)
nopaneltrue

SetRowHeight(Int32, Double)

Excerpt Include
Area.SetRowHeight(Int32, Double)
Area.SetRowHeight(Int32, Double)
nopaneltrue

SetStyle(Style)

Excerpt Include
Area.SetStyle(Style)
Area.SetStyle(Style)
nopaneltrue

ToString()

Excerpt Include
Area.ToString()
Area.ToString()
nopaneltrue

UngroupColumns()

Excerpt Include
Area.UngroupColumns()
Area.UngroupColumns()
nopaneltrue

UngroupRows()

Excerpt Include
Area.UngroupRows()
Area.UngroupRows()
nopaneltrue

Extensionmethods
 

Overload

Description

ImportData(Microsoft.SharePoint.SPList, DataImportProperties)

Excerpt Include
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)
nopaneltrue

ImportData(Microsoft.SharePoint.SPList)

Excerpt Include
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)
nopaneltrue

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

Excerpt Include
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
nopaneltrue

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

Excerpt Include
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
nopaneltrue

Scrollbar