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

Creates a Range of cells from a specified formula. A Range is a collection of Area s; an Area area is a rectangular collection of cells.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Creates a [Range|Range] of cells from a specified formula. A {{Range}} is a collection of [Area|Area] s; an {{Area}} area is a rectangular collection of cells.{excerpt}
{signature:C#}
 public Range CreateRange(System.String rangeFormula)
Signature
{signature}{signature:vb.net
vb.net
}
Public Function CreateRange(ByVal rangeFormula As String) As Range
Parameters
Param
rangeFormularangeFormulaFormula representing the range, for example "=Sheet1
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example "=Sheet1\!A1:G10". The formula must be three\-dimensional \(specify a sheet\), and can include only sheet and cell references, and operators joining those references \(range ':', intersection ' ', and union ','\). Functions that return ranges cannot be used.
Returns

A Range object representing the range of cells created.

{param}
{returns}A {{Range}} object representing the range of cells created.{returns}
{example}{code:csharp|title=C#}
Range rng = wb.CreateRange("=Sheet1!A1:G10");
{code}
{code:vb.net
|title=vb.net
}
Dim rng As Range = wb.CreateRange("=Sheet1!A1:G10"){code}

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