Description |
---|
Excerpt |
---|
An Area object represents a rectangular set of cells. |
Signature | C# | C# |
---|---|---|
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}{signature:vb.net | vb.net | }
<DefaultMember("Item")> _
Public NotInheritable Class Area
|
Remarks |
---|
To create an |
Example | |||
---|---|---|---|
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vbnet | vbnet | title |
Properties |
---|
...
Name
...
Description
...
...
{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 |
...
Indexers |
---|
...
Name
...
Description
|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32, Int32) |
...
|Area.Item(Int32, Int32) |
...
]|{excerpt-include:Area.Item(Int32, Int32) |
...
|nopanel |
...
Methods |
---|
...
Name
...
Description
=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 |
...
Extensionmethods |
---|
...
Overload
...
Description
=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} |