Wiki Markup |
---|
{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} |
Page History
Overview
Content Tools