Table of Contents

TXls3DRange Record

A 3d Excel range.

Syntax

Unit: FlexCel.Core

TXls3DRange = record;

Fields

Name Description
HasValue False if the record doesn't have a defined value. When this field is false, the values of the other fields don't matter.
FileName Filename if the range is in a different file.
Top Top of the range.
Left Left of the range.
Bottom Bottom of the range.
Right Right of the range.
Sheet2 Second sheet of the range.

Methods

Name Description
Create Overloaded
Create
Create(TCoreExcelFile, string)
Create(Integer, Integer, Integer, Integer, Integer, Integer)
Create(string, Integer, Integer, Integer, Integer, Integer, Integer)
SetRange3DRef Sets the value of the 3d range based on the string that defines the range in A1 notation.
TrySetRange3DRef Tries to set the value of the 3d range based on the string that defines the range in A1 notation. If the name can't be set, no data is modified and this method returns false.
Null Creates a null range.
Equals Returns true if both objects are equal.
GetHashCode Returns the hashcode of the object.
IsNull Returns true if the record doesn't have a defined value. This is the inverse of HasValue

Operators

Name Description
Equality Adapts the = operator so it returns true when both instances have the same values.
Inequality Adapts the <> operator so it returns true when both instances have different values.

Properties

Name Description
IsOneCell Returns true if the range has only one cell.