Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

An Area object represents a rectangular set of cells.

Signature
C#
C#
[DefaultMember("Item")]
 public sealed class Area
{signature}{signature:
}
Signature
vb.net
vb.net
<DefaultMember("Item")> _
	Public NotInheritable Class Area
{signature}
{remarks}To create an {{Area}} object, call [Worksheet.CreateArea|Worksheet.CreateArea]

{remarks}
{example}{code:csharp|title=C#}
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} {code:vbnet|title=
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)
        
{code} {example} {properties} ||Name||Description|| |[AllColumnWidths|Area.AllColumnWidths]|{excerpt-include:Area.AllColumnWidths|nopanel=true}| |[AllColumnWidthsInChars|Area.AllColumnWidthsInChars]|{excerpt-include:Area.AllColumnWidthsInChars|nopanel=true}| |[AllRowsHeight|Area.AllRowsHeight]|{excerpt-include:Area.AllRowsHeight|nopanel=true}| |[ArrayFormula|Area.ArrayFormula]|{excerpt-include:Area.ArrayFormula|nopanel=true}| |[BorderAround|Area.BorderAround]|{excerpt-include:Area.BorderAround|nopanel=true}| |[ColumnCount|Area.ColumnCount]|{excerpt-include:Area.ColumnCount|nopanel=true}| |[Dimensions|Area.Dimensions]|{excerpt-include:Area.Dimensions|nopanel=true}| |[FirstColumn|Area.FirstColumn]|{excerpt-include:Area.FirstColumn|nopanel=true}| |[FirstRow|Area.FirstRow]|{excerpt-include:Area.FirstRow|nopanel=true}| |[PopulatedCells|Area.PopulatedCells]|{excerpt-include:Area.PopulatedCells|nopanel=true}| |[RowCount|Area.RowCount]|{excerpt-include:Area.RowCount|nopanel=true}| |[WorksheetIndex|Area.WorksheetIndex]|{excerpt-include:Area.WorksheetIndex|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32, Int32)|Area.Item(Int32, Int32)]|{excerpt-include:Area.Item(Int32, Int32)|nopanel=true}| {methods} ||Name||Description|| |[ApplyStyle(Style)|Area.ApplyStyle(Style)]|{excerpt-include:Area.ApplyStyle(Style)|nopanel=true}| |[AutoFitHeight()|Area.AutoFitHeight()]|{excerpt-include:Area.AutoFitHeight()|nopanel=true}| |[AutoFitWidth()|Area.AutoFitWidth()]|{excerpt-include:Area.AutoFitWidth()|nopanel=true}| |[ClearContent()|Area.ClearContent()]|{excerpt-include:Area.ClearContent()|nopanel=true}| |[CreateHyperlink(String)|Area.CreateHyperlink(String)]|{excerpt-include:Area.CreateHyperlink(String)|nopanel=true}| |[GetColumnWidth(Int32)|Area.GetColumnWidth(Int32)]|{excerpt-include:Area.GetColumnWidth(Int32)|nopanel=true}| |[GetColumnWidthInChars(Int32)|Area.GetColumnWidthInChars(Int32)]|{excerpt-include:Area.GetColumnWidthInChars(Int32)|nopanel=true}| |[GetRowHeight(Int32)|Area.GetRowHeight(Int32)]|{excerpt-include:Area.GetRowHeight(Int32)|nopanel=true}| |[GroupColumns(Boolean)|Area.GroupColumns(Boolean)]|{excerpt-include:Area.GroupColumns(Boolean)|nopanel=true}| |[GroupRows(Boolean)|Area.GroupRows(Boolean)]|{excerpt-include:Area.GroupRows(Boolean)|nopanel=true}| |[ImportData(Object()())|
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

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()())

...

nopanel

...

...

...

...

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

...

String(),

...

DataImportProperties)

...

Area.ImportData(Object()(),

...

String(),

...

DataImportProperties)

...

nopanel

...

...

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

...

Area.ImportData(System.Data.DataTable)

...

nopanel

...

...

...

Excerpt Include
Area.ImportData(System.Data.DataTable,

...

DataImportProperties)

...

Area.ImportData(System.Data.DataTable,

...

DataImportProperties)

...

nopanel

...

...

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

...

Area.ImportData(System.Data.DataView)

...

nopanel

...

...

...

Excerpt Include
Area.ImportData(System.Data.DataView,

...

DataImportProperties)

...

Area.ImportData(System.Data.DataView,

...

DataImportProperties)

...

nopanel

...

...

Excerpt Include
Area.ImportData(Object(,))

...

Area.ImportData(Object(,))

...

nopanel

...

...

...

...

Excerpt Include
Area.ImportData(Object(,),

...

String(),

...

DataImportProperties)

...

Area.ImportData(Object(,),

...

String(),

...

DataImportProperties)

...

nopanel

...

...

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

...

Area.ImportData(System.Data.IDataReader)

...

nopanel

...

...

...

Excerpt Include
Area.ImportData(System.Data.IDataReader,

...

DataImportProperties)

...

Area.ImportData(System.Data.IDataReader,

...

DataImportProperties)

...

nopanel

...

...

Excerpt Include
Area.MergeCells()

...

Area.MergeCells()

...

nopanel

...

...

Excerpt Include
Area.RemoveConditionalFormat()

...

Area.RemoveConditionalFormat()

...

nopanel

...

...

...

Excerpt Include
Area.SetColumnWidth(Int32,

...

Double)

...

Area.SetColumnWidth(Int32,

...

Double)

...

nopanel

...

...

...

Excerpt Include
Area.SetColumnWidthInChars(Int32,

...

Double)

...

Area.SetColumnWidthInChars(Int32,

...

Double)

...

nopanel

...

...

Excerpt Include
Area.SetConditionalFormat(ConditionalFormat)

...

Area.SetConditionalFormat(ConditionalFormat)

...

nopanel

...

...

Excerpt Include
Area.SetDataValidation(DataValidation)

...

Area.SetDataValidation(DataValidation)

...

nopanel

...

...

...

Excerpt Include
Area.SetRowHeight(Int32,

...

Double)

...

Area.SetRowHeight(Int32,

...

Double)

...

nopanel

...

...

Excerpt Include
Area.SetStyle(Style)

...

Area.SetStyle(Style)

...

nopanel

...

...

Excerpt Include
Area.ToString()

...

Area.ToString()

...

nopanel

...

...

Excerpt Include
Area.UngroupColumns()

...

Area.UngroupColumns()

...

nopanel

...

...

Excerpt Include
Area.UngroupRows()

...

Area.UngroupRows()

...

nopanel

...

true
Extensionmethods
Introducedin
7.5
7.5

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

true
Scrollbar