.
| 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} |