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

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version 2

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Defines a rectangular Area of cells in the worksheet.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Defines a rectangular [Area|Area] of cells in the worksheet.{excerpt}
{signature:C#}
 public Area CreateArea(System.String areaFormula)
Signature
{signature}{signature:vb.net
vb.net
}
Public Function CreateArea(ByVal areaFormula As String) As Area
Parameters
Param
areaFormulaareaFormulaA formula representing the area, 
{signature}
{parameters}
{param:areaFormula}A formula representing the area, e.g. "A3:B5". The formula must be local to the worksheet and should not contain a sheet reference.
Returns

An Area object.

{param}
{returns}An {{Area}} object.{returns}
{example}{code:csharp|title=C#}
Area a = ws.CreateArea("B7:H24");
{code}
{code:vb.net
|title=vb.net
}
Dim a As Area = ws.CreateArea("B7:H24"){code}

{example}
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle