Page History

{description}
{excerpt}An [Area|Area] object represents a rectangular set of cells.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class Area
{signature}{signature: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#}

          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=vb.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()())|Area.ImportData(Object()())]|{excerpt-include:Area.ImportData(Object()())|nopanel=true}|
|[ImportData(Object()(), String(), DataImportProperties)|Area.ImportData(Object()(), String(), DataImportProperties)]|{excerpt-include:Area.ImportData(Object()(), String(), DataImportProperties)|nopanel=true}|
|[ImportData(System.Data.DataTable)|Area.ImportData(System.Data.DataTable)]|{excerpt-include:Area.ImportData(System.Data.DataTable)|nopanel=true}|
|[ImportData(System.Data.DataTable, DataImportProperties)|Area.ImportData(System.Data.DataTable, DataImportProperties)]|{excerpt-include:Area.ImportData(System.Data.DataTable, DataImportProperties)|nopanel=true}|
|[ImportData(System.Data.DataView)|Area.ImportData(System.Data.DataView)]|{excerpt-include:Area.ImportData(System.Data.DataView)|nopanel=true}|
|[ImportData(System.Data.DataView, DataImportProperties)|Area.ImportData(System.Data.DataView, DataImportProperties)]|{excerpt-include:Area.ImportData(System.Data.DataView, DataImportProperties)|nopanel=true}|
|[ImportData(Object(,))|Area.ImportData(Object(,))]|{excerpt-include:Area.ImportData(Object(,))|nopanel=true}|
|[ImportData(Object(,), String(), DataImportProperties)|Area.ImportData(Object(,), String(), DataImportProperties)]|{excerpt-include:Area.ImportData(Object(,), String(), DataImportProperties)|nopanel=true}|
|[ImportData(System.Data.IDataReader)|Area.ImportData(System.Data.IDataReader)]|{excerpt-include:Area.ImportData(System.Data.IDataReader)|nopanel=true}|
|[ImportData(System.Data.IDataReader, DataImportProperties)|Area.ImportData(System.Data.IDataReader, DataImportProperties)]|{excerpt-include:Area.ImportData(System.Data.IDataReader, DataImportProperties)|nopanel=true}|
|[MergeCells()|Area.MergeCells()]|{excerpt-include:Area.MergeCells()|nopanel=true}|
|[RemoveConditionalFormat()|Area.RemoveConditionalFormat()]|{excerpt-include:Area.RemoveConditionalFormat()|nopanel=true}|
|[SetColumnWidth(Int32, Double)|Area.SetColumnWidth(Int32, Double)]|{excerpt-include:Area.SetColumnWidth(Int32, Double)|nopanel=true}|
|[SetColumnWidthInChars(Int32, Double)|Area.SetColumnWidthInChars(Int32, Double)]|{excerpt-include:Area.SetColumnWidthInChars(Int32, Double)|nopanel=true}|
|[SetConditionalFormat(ConditionalFormat)|Area.SetConditionalFormat(ConditionalFormat)]|{excerpt-include:Area.SetConditionalFormat(ConditionalFormat)|nopanel=true}|
|[SetDataValidation(DataValidation)|Area.SetDataValidation(DataValidation)]|{excerpt-include:Area.SetDataValidation(DataValidation)|nopanel=true}|
|[SetRowHeight(Int32, Double)|Area.SetRowHeight(Int32, Double)]|{excerpt-include:Area.SetRowHeight(Int32, Double)|nopanel=true}|
|[SetStyle(Style)|Area.SetStyle(Style)]|{excerpt-include:Area.SetStyle(Style)|nopanel=true}|
|[ToString()|Area.ToString()]|{excerpt-include:Area.ToString()|nopanel=true}|
|[UngroupColumns()|Area.UngroupColumns()]|{excerpt-include:Area.UngroupColumns()|nopanel=true}|
|[UngroupRows()|Area.UngroupRows()]|{excerpt-include:Area.UngroupRows()|nopanel=true}|
{extensionMethods}
{introducedin:7.5}
||Overload||Description||
|[ImportData(Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)]|{excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true}|
|[ImportData(Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)]|{excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)|nopanel=true}|
|[ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)]|{excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)|nopanel=true}|
|[ImportData(Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)]|{excerpt-include:SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)|nopanel=true}|

{scrollbar}