OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 5

changes.mady.by.user Anonymous

Saved on

compared with

New Version Current

changes.mady.by.user Anonymous

Saved on

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
...
true
ImportData(Object()(), 
...
 String(), 
...
 DataImportProperties)
...
 Excerpt Include
Area.ImportData(Object()(), 
...
 String(), 
...
 DataImportProperties)
...
Area.ImportData(Object()(), 
...
 String(), 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(System.Data.DataTable)
...
 Excerpt Include
Area.ImportData(System.Data.DataTable)
...
Area.ImportData(System.Data.DataTable)
...
nopanel
...
true
ImportData(System.Data.DataTable, 
...
 DataImportProperties)
...
 Excerpt Include
Area.ImportData(System.Data.DataTable, 
...
 DataImportProperties)
...
Area.ImportData(System.Data.DataTable, 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(System.Data.DataView)
...
 Excerpt Include
Area.ImportData(System.Data.DataView)
...
Area.ImportData(System.Data.DataView)
...
nopanel
...
true
ImportData(System.Data.DataView, 
...
 DataImportProperties)
...
 Excerpt Include
Area.ImportData(System.Data.DataView, 
...
 DataImportProperties)
...
Area.ImportData(System.Data.DataView, 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(Object(,))
...
 Excerpt Include
Area.ImportData(Object(,))
...
Area.ImportData(Object(,))
...
nopanel
...
true
ImportData(Object(,), 
...
 String(), 
...
 DataImportProperties)
...
 Excerpt Include
Area.ImportData(Object(,), 
...
 String(), 
...
 DataImportProperties)
...
Area.ImportData(Object(,), 
...
 String(), 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(System.Data.IDataReader)
...
 Excerpt Include
Area.ImportData(System.Data.IDataReader)
...
Area.ImportData(System.Data.IDataReader)
...
nopanel
...
true
ImportData(System.Data.IDataReader, 
...
 DataImportProperties)
...
 Excerpt Include
Area.ImportData(System.Data.IDataReader, 
...
 DataImportProperties)
...
Area.ImportData(System.Data.IDataReader, 
...
 DataImportProperties)
...
nopanel
...
true
MergeCells()
...
 Excerpt Include
Area.MergeCells()
...
Area.MergeCells()
...
nopanel
...
true
RemoveConditionalFormat()
...
 Excerpt Include
Area.RemoveConditionalFormat()
...
Area.RemoveConditionalFormat()
...
nopanel
...
true
SetColumnWidth(Int32, 
...
 Double)
...
 Excerpt Include
Area.SetColumnWidth(Int32, 
...
 Double)
...
Area.SetColumnWidth(Int32, 
...
 Double)
...
nopanel
...
true
SetColumnWidthInChars(Int32, 
...
 Double)
...
 Excerpt Include
Area.SetColumnWidthInChars(Int32, 
...
 Double)
...
Area.SetColumnWidthInChars(Int32, 
...
 Double)
...
nopanel
...
true
SetConditionalFormat(ConditionalFormat)
...
 Excerpt Include
Area.SetConditionalFormat(ConditionalFormat)
...
Area.SetConditionalFormat(ConditionalFormat)
...
nopanel
...
true
SetDataValidation(DataValidation)
...
 Excerpt Include
Area.SetDataValidation(DataValidation)
...
Area.SetDataValidation(DataValidation)
...
nopanel
...
true
SetRowHeight(Int32, 
...
 Double)
...
 Excerpt Include
Area.SetRowHeight(Int32, 
...
 Double)
...
Area.SetRowHeight(Int32, 
...
 Double)
...
nopanel
...
true
SetStyle(Style)
...
 Excerpt Include
Area.SetStyle(Style)
...
Area.SetStyle(Style)
...
nopanel
...
true
ToString()
...
 Excerpt Include
Area.ToString()
...
Area.ToString()
...
nopanel
...
true
UngroupColumns()
...
 Excerpt Include
Area.UngroupColumns()
...
Area.UngroupColumns()
...
nopanel
...
true
UngroupRows()
...
 Excerpt Include
Area.UngroupRows()
...
Area.UngroupRows()
...
nopanel
...
true
 Extensionmethods
 Introducedin
7.5
7.5
Overload
Description
ImportData(Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
 Excerpt Include
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(Microsoft.SharePoint.SPList)
...
 Excerpt Include
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPList)
...
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPList)
...
nopanel
...
true
ImportData(Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
 Excerpt Include
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList, 
...
 DataImportProperties)
...
nopanel
...
true
ImportData(Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList)
...
 Excerpt Include
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList)
...
SharePointIntegration.ImportData(Area, 
...
 Microsoft.SharePoint.SPView, 
...
 Microsoft.SharePoint.SPList)
...
nopanel
...
true
 Scrollbar