Range Class Reference

#include <excel8.h>

Inherits COleDispatchDriver.

Public Member Functions
	Range ()
	Range (LPDISPATCH pDispatch)
	Range (const Range &dispatchSrc)
LPDISPATCH	GetApplication ()
long	GetCreator ()
LPDISPATCH	GetParent ()
void	Activate ()
VARIANT	GetAddIndent ()
void	SetAddIndent (const VARIANT &newValue)
CString	GetAddress (const VARIANT &RowAbsolute, const VARIANT &ColumnAbsolute, long ReferenceStyle, const VARIANT &External, const VARIANT &RelativeTo)
CString	GetAddressLocal (const VARIANT &RowAbsolute, const VARIANT &ColumnAbsolute, long ReferenceStyle, const VARIANT &External, const VARIANT &RelativeTo)
void	AdvancedFilter (long Action, const VARIANT &CriteriaRange, const VARIANT &CopyToRange, const VARIANT &Unique)
void	ApplyNames (const VARIANT &Names, const VARIANT &IgnoreRelativeAbsolute, const VARIANT &UseRowColumnNames, const VARIANT &OmitColumn, const VARIANT &OmitRow, long Order, const VARIANT &AppendLast)
void	ApplyOutlineStyles ()
LPDISPATCH	GetAreas ()
CString	AutoComplete (LPCTSTR String)
void	AutoFill (LPDISPATCH Destination, long Type)
void	AutoFilter (const VARIANT &Field, const VARIANT &Criteria1, long Operator, const VARIANT &Criteria2, const VARIANT &VisibleDropDown)
void	AutoFit ()
void	AutoFormat (long Format, const VARIANT &Number, const VARIANT &Font, const VARIANT &Alignment, const VARIANT &Border, const VARIANT &Pattern, const VARIANT &Width)
void	AutoOutline ()
void	BorderAround (const VARIANT &LineStyle, long Weight, long ColorIndex, const VARIANT &Color)
LPDISPATCH	GetBorders ()
void	Calculate ()
LPDISPATCH	GetCells ()
LPDISPATCH	GetCharacters (const VARIANT &Start, const VARIANT &Length)
void	CheckSpelling (const VARIANT &CustomDictionary, const VARIANT &IgnoreUppercase, const VARIANT &AlwaysSuggest, const VARIANT &IgnoreInitialAlefHamza, const VARIANT &IgnoreFinalYaa, const VARIANT &SpellScript)
void	Clear ()
void	ClearContents ()
void	ClearFormats ()
void	ClearNotes ()
void	ClearOutline ()
long	GetColumn ()
LPDISPATCH	ColumnDifferences (const VARIANT &Comparison)
LPDISPATCH	GetColumns ()
VARIANT	GetColumnWidth ()
void	SetColumnWidth (const VARIANT &newValue)
void	Consolidate (const VARIANT &Sources, const VARIANT &Function, const VARIANT &TopRow, const VARIANT &LeftColumn, const VARIANT &CreateLinks)
void	Copy (const VARIANT &Destination)
long	CopyFromRecordset (LPUNKNOWN Data, const VARIANT &MaxRows, const VARIANT &MaxColumns)
void	CopyPicture (long Appearance, long Format)
long	GetCount ()
void	CreateNames (const VARIANT &Top, const VARIANT &Left, const VARIANT &Bottom, const VARIANT &Right)
void	CreatePublisher (const VARIANT &Edition, long Appearance, const VARIANT &ContainsPICT, const VARIANT &ContainsBIFF, const VARIANT &ContainsRTF, const VARIANT &ContainsVALU)
LPDISPATCH	GetCurrentArray ()
LPDISPATCH	GetCurrentRegion ()
void	Cut (const VARIANT &Destination)
void	DataSeries (const VARIANT &Rowcol, long Type, long Date, const VARIANT &Step, const VARIANT &Stop, const VARIANT &Trend)
VARIANT	Get_Default (const VARIANT &RowIndex, const VARIANT &ColumnIndex)
void	Set_Default (const VARIANT &RowIndex, const VARIANT &ColumnIndex, const VARIANT &newValue)
void	Delete (const VARIANT &Shift)
LPDISPATCH	GetDependents ()
VARIANT	DialogBox_ ()
LPDISPATCH	GetDirectDependents ()
LPDISPATCH	GetDirectPrecedents ()
VARIANT	EditionOptions (long Type, long Option, const VARIANT &Name, const VARIANT &Reference, long Appearance, long ChartSize, const VARIANT &Format)
LPDISPATCH	GetEnd (long Direction)
LPDISPATCH	GetEntireColumn ()
LPDISPATCH	GetEntireRow ()
void	FillDown ()
void	FillLeft ()
void	FillRight ()
void	FillUp ()
LPDISPATCH	Find (const VARIANT &What, const VARIANT &After, const VARIANT &LookIn, const VARIANT &LookAt, const VARIANT &SearchOrder, long SearchDirection, const VARIANT &MatchCase, const VARIANT &MatchByte, const VARIANT &MatchControlCharacters, const VARIANT &MatchDiacritics, const VARIANT &MatchKashida, const VARIANT &MatchAlefHamza)
LPDISPATCH	FindNext (const VARIANT &After)
LPDISPATCH	FindPrevious (const VARIANT &After)
LPDISPATCH	GetFont ()
VARIANT	GetFormula ()
void	SetFormula (const VARIANT &newValue)
VARIANT	GetFormulaArray ()
void	SetFormulaArray (const VARIANT &newValue)
long	GetFormulaLabel ()
void	SetFormulaLabel (long nNewValue)
VARIANT	GetFormulaHidden ()
void	SetFormulaHidden (const VARIANT &newValue)
VARIANT	GetFormulaLocal ()
void	SetFormulaLocal (const VARIANT &newValue)
VARIANT	GetFormulaR1C1 ()
void	SetFormulaR1C1 (const VARIANT &newValue)
VARIANT	GetFormulaR1C1Local ()
void	SetFormulaR1C1Local (const VARIANT &newValue)
void	FunctionWizard ()
BOOL	GoalSeek (const VARIANT &Goal, LPDISPATCH ChangingCell)
VARIANT	Group (const VARIANT &Start, const VARIANT &End, const VARIANT &By, const VARIANT &Periods)
VARIANT	GetHasArray ()
VARIANT	GetHasFormula ()
VARIANT	GetHeight ()
VARIANT	GetHidden ()
void	SetHidden (const VARIANT &newValue)
VARIANT	GetHorizontalAlignment ()
void	SetHorizontalAlignment (const VARIANT &newValue)
VARIANT	GetIndentLevel ()
void	SetIndentLevel (const VARIANT &newValue)
void	InsertIndent (long InsertAmount)
void	Insert (const VARIANT &Shift)
LPDISPATCH	GetInterior ()
VARIANT	GetItem (const VARIANT &RowIndex, const VARIANT &ColumnIndex)
void	SetItem (const VARIANT &RowIndex, const VARIANT &ColumnIndex, const VARIANT &newValue)
void	Justify ()
VARIANT	GetLeft ()
long	GetListHeaderRows ()
void	ListNames ()
long	GetLocationInTable ()
VARIANT	GetLocked ()
void	SetLocked (const VARIANT &newValue)
void	Merge (const VARIANT &Across)
void	UnMerge ()
LPDISPATCH	GetMergeArea ()
VARIANT	GetMergeCells ()
void	SetMergeCells (const VARIANT &newValue)
VARIANT	GetName ()
void	SetName (const VARIANT &newValue)
void	NavigateArrow (const VARIANT &TowardPrecedent, const VARIANT &ArrowNumber, const VARIANT &LinkNumber)
LPUNKNOWN	Get_NewEnum ()
LPDISPATCH	GetNext ()
CString	NoteText (const VARIANT &Text, const VARIANT &Start, const VARIANT &Length)
VARIANT	GetNumberFormat ()
void	SetNumberFormat (const VARIANT &newValue)
VARIANT	GetNumberFormatLocal ()
void	SetNumberFormatLocal (const VARIANT &newValue)
LPDISPATCH	GetOffset (const VARIANT &RowOffset, const VARIANT &ColumnOffset)
VARIANT	GetOrientation ()
void	SetOrientation (const VARIANT &newValue)
VARIANT	GetOutlineLevel ()
void	SetOutlineLevel (const VARIANT &newValue)
long	GetPageBreak ()
void	SetPageBreak (long nNewValue)
void	Parse (const VARIANT &ParseLine, const VARIANT &Destination)
void	PasteSpecial (long Paste, long Operation, const VARIANT &SkipBlanks, const VARIANT &Transpose)
LPDISPATCH	GetPivotField ()
LPDISPATCH	GetPivotItem ()
LPDISPATCH	GetPivotTable ()
LPDISPATCH	GetPrecedents ()
VARIANT	GetPrefixCharacter ()
LPDISPATCH	GetPrevious ()
void	PrintOut (const VARIANT &From, const VARIANT &To, const VARIANT &Copies, const VARIANT &Preview, const VARIANT &ActivePrinter, const VARIANT &PrintToFile, const VARIANT &Collate)
void	PrintPreview (const VARIANT &EnableChanges)
LPDISPATCH	GetQueryTable ()
LPDISPATCH	GetRange (const VARIANT &Cell1, const VARIANT &Cell2)
void	RemoveSubtotal ()
BOOL	Replace (const VARIANT &What, const VARIANT &Replacement, const VARIANT &LookAt, const VARIANT &SearchOrder, const VARIANT &MatchCase, const VARIANT &MatchByte, const VARIANT &MatchControlCharacters, const VARIANT &MatchDiacritics, const VARIANT &MatchKashida, const VARIANT &MatchAlefHamza)
LPDISPATCH	GetResize (const VARIANT &RowSize, const VARIANT &ColumnSize)
long	GetRow ()
LPDISPATCH	RowDifferences (const VARIANT &Comparison)
VARIANT	GetRowHeight ()
void	SetRowHeight (const VARIANT &newValue)
LPDISPATCH	GetRows ()
VARIANT	Run (const VARIANT &Arg1, const VARIANT &Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
void	Select ()
void	Show ()
void	ShowDependents (const VARIANT &Remove)
VARIANT	GetShowDetail ()
void	SetShowDetail (const VARIANT &newValue)
void	ShowErrors ()
void	ShowPrecedents (const VARIANT &Remove)
VARIANT	GetShrinkToFit ()
void	SetShrinkToFit (const VARIANT &newValue)
void	Sort (const VARIANT &Key1, long Order1, const VARIANT &Key2, const VARIANT &Type, long Order2, const VARIANT &Key3, long Order3, long Header, const VARIANT &OrderCustom, const VARIANT &MatchCase, long Orientation, long SortMethod, const VARIANT &IgnoreControlCharacters, const VARIANT &IgnoreDiacritics, const VARIANT &IgnoreKashida)
void	SortSpecial (long SortMethod, const VARIANT &Key1, long Order1, const VARIANT &Type, const VARIANT &Key2, long Order2, const VARIANT &Key3, long Order3, long Header, const VARIANT &OrderCustom, const VARIANT &MatchCase, long Orientation)
LPDISPATCH	GetSoundNote ()
LPDISPATCH	SpecialCells (long Type, const VARIANT &Value)
VARIANT	GetStyle ()
void	SetStyle (const VARIANT &newValue)
void	SubscribeTo (LPCTSTR Edition, long Format)
void	Subtotal (long GroupBy, long Function, const VARIANT &TotalList, const VARIANT &Replace, const VARIANT &PageBreaks, long SummaryBelowData)
VARIANT	GetSummary ()
void	Table (const VARIANT &RowInput, const VARIANT &ColumnInput)
VARIANT	GetText ()
void	TextToColumns (const VARIANT &Destination, long DataType, long TextQualifier, const VARIANT &ConsecutiveDelimiter, const VARIANT &Tab, const VARIANT &Semicolon, const VARIANT &Comma, const VARIANT &Space, const VARIANT &Other, const VARIANT &OtherChar, const VARIANT &FieldInfo)
VARIANT	GetTop ()
void	Ungroup ()
VARIANT	GetUseStandardHeight ()
void	SetUseStandardHeight (const VARIANT &newValue)
VARIANT	GetUseStandardWidth ()
void	SetUseStandardWidth (const VARIANT &newValue)
LPDISPATCH	GetValidation ()
VARIANT	GetValue ()
void	SetValue (const VARIANT &newValue)
VARIANT	GetValue2 ()
void	SetValue2 (const VARIANT &newValue)
VARIANT	GetVerticalAlignment ()
void	SetVerticalAlignment (const VARIANT &newValue)
VARIANT	GetWidth ()
LPDISPATCH	GetWorksheet ()
VARIANT	GetWrapText ()
void	SetWrapText (const VARIANT &newValue)
LPDISPATCH	AddComment (const VARIANT &Text)
LPDISPATCH	GetComment ()
void	ClearComments ()
LPDISPATCH	GetPhonetic ()
LPDISPATCH	GetFormatConditions ()
long	GetReadingOrder ()
void	SetReadingOrder (long nNewValue)
LPDISPATCH	GetHyperlinks ()

Detailed Description

Definition at line 584 of file excel8.h.

Constructor & Destructor Documentation

Range() [1/3]

Range::Range ( )

inline

Definition at line 587 of file excel8.h.

Range() [2/3]

Range::Range ( LPDISPATCH pDispatch )

inline

Definition at line 588 of file excel8.h.

Range() [3/3]

Range::Range ( const Range & dispatchSrc )

inline

Definition at line 589 of file excel8.h.

Member Function Documentation

Activate()

void Range::Activate

(

)

Definition at line 3703 of file excel8.cpp.

AddComment()

LPDISPATCH Range::AddComment

(

const VARIANT &

Text

)

Definition at line 5056 of file excel8.cpp.

AdvancedFilter()

void Range::AdvancedFilter	(	long	Action,
		const VARIANT &	CriteriaRange,
		const VARIANT &	CopyToRange,
		const VARIANT &	Unique )

Definition at line 3743 of file excel8.cpp.

ApplyNames()

void Range::ApplyNames	(	const VARIANT &	Names,
		const VARIANT &	IgnoreRelativeAbsolute,
		const VARIANT &	UseRowColumnNames,
		const VARIANT &	OmitColumn,
		const VARIANT &	OmitRow,
		long	Order,
		const VARIANT &	AppendLast )

Definition at line 3751 of file excel8.cpp.

ApplyOutlineStyles()

void Range::ApplyOutlineStyles

(

)

Definition at line 3759 of file excel8.cpp.

AutoComplete()

CString Range::AutoComplete

(

LPCTSTR

String

)

Definition at line 3771 of file excel8.cpp.

AutoFill()

void Range::AutoFill	(	LPDISPATCH	Destination,
		long	Type )

Definition at line 3781 of file excel8.cpp.

AutoFilter()

void Range::AutoFilter	(	const VARIANT &	Field,
		const VARIANT &	Criteria1,
		long	Operator,
		const VARIANT &	Criteria2,
		const VARIANT &	VisibleDropDown )

Definition at line 3789 of file excel8.cpp.

AutoFit()

void Range::AutoFit

(

)

Definition at line 3797 of file excel8.cpp.

AutoFormat()

void Range::AutoFormat	(	long	Format,
		const VARIANT &	Number,
		const VARIANT &	Font,
		const VARIANT &	Alignment,
		const VARIANT &	Border,
		const VARIANT &	Pattern,
		const VARIANT &	Width )

Definition at line 3802 of file excel8.cpp.

AutoOutline()

void Range::AutoOutline

(

)

Definition at line 3810 of file excel8.cpp.

BorderAround()

void Range::BorderAround	(	const VARIANT &	LineStyle,
		long	Weight,
		long	ColorIndex,
		const VARIANT &	Color )

Definition at line 3815 of file excel8.cpp.

Calculate()

void Range::Calculate

(

)

Definition at line 3830 of file excel8.cpp.

CheckSpelling()

void Range::CheckSpelling	(	const VARIANT &	CustomDictionary,
		const VARIANT &	IgnoreUppercase,
		const VARIANT &	AlwaysSuggest,
		const VARIANT &	IgnoreInitialAlefHamza,
		const VARIANT &	IgnoreFinalYaa,
		const VARIANT &	SpellScript )

Definition at line 3852 of file excel8.cpp.

Clear()

void Range::Clear

(

)

Definition at line 3860 of file excel8.cpp.

ClearComments()

void Range::ClearComments

(

)

Definition at line 5073 of file excel8.cpp.

ClearContents()

void Range::ClearContents

(

)

Definition at line 3865 of file excel8.cpp.

ClearFormats()

void Range::ClearFormats

(

)

Definition at line 3870 of file excel8.cpp.

ClearNotes()

void Range::ClearNotes

(

)

Definition at line 3875 of file excel8.cpp.

ClearOutline()

void Range::ClearOutline

(

)

Definition at line 3880 of file excel8.cpp.

ColumnDifferences()

LPDISPATCH Range::ColumnDifferences

(

const VARIANT &

Comparison

)

Definition at line 3892 of file excel8.cpp.

Consolidate()

void Range::Consolidate	(	const VARIANT &	Sources,
		const VARIANT &	Function,
		const VARIANT &	TopRow,
		const VARIANT &	LeftColumn,
		const VARIANT &	CreateLinks )

Definition at line 3924 of file excel8.cpp.

Copy()

void Range::Copy

(

const VARIANT &

Destination

)

Definition at line 3932 of file excel8.cpp.

CopyFromRecordset()

long Range::CopyFromRecordset	(	LPUNKNOWN	Data,
		const VARIANT &	MaxRows,
		const VARIANT &	MaxColumns )

Definition at line 3940 of file excel8.cpp.

CopyPicture()

void Range::CopyPicture	(	long	Appearance,
		long	Format )

Definition at line 3950 of file excel8.cpp.

CreateNames()

void Range::CreateNames	(	const VARIANT &	Top,
		const VARIANT &	Left,
		const VARIANT &	Bottom,
		const VARIANT &	Right )

Definition at line 3965 of file excel8.cpp.

CreatePublisher()

void Range::CreatePublisher	(	const VARIANT &	Edition,
		long	Appearance,
		const VARIANT &	ContainsPICT,
		const VARIANT &	ContainsBIFF,
		const VARIANT &	ContainsRTF,
		const VARIANT &	ContainsVALU )

Definition at line 3973 of file excel8.cpp.

Cut()

void Range::Cut

(

const VARIANT &

Destination

)

Definition at line 3995 of file excel8.cpp.

DataSeries()

void Range::DataSeries	(	const VARIANT &	Rowcol,
		long	Type,
		long	Date,
		const VARIANT &	Step,
		const VARIANT &	Stop,
		const VARIANT &	Trend )

Definition at line 4003 of file excel8.cpp.

Delete()

void Range::Delete

(

const VARIANT &

Shift

)

Definition at line 4029 of file excel8.cpp.

DialogBox_()

VARIANT Range::DialogBox_

(

)

Definition at line 4044 of file excel8.cpp.

EditionOptions()

VARIANT Range::EditionOptions	(	long	Type,
		long	Option,
		const VARIANT &	Name,
		const VARIANT &	Reference,
		long	Appearance,
		long	ChartSize,
		const VARIANT &	Format )

Definition at line 4065 of file excel8.cpp.

FillDown()

void Range::FillDown

(

)

Definition at line 4099 of file excel8.cpp.

FillLeft()

void Range::FillLeft

(

)

Definition at line 4104 of file excel8.cpp.

FillRight()

void Range::FillRight

(

)

Definition at line 4109 of file excel8.cpp.

FillUp()

void Range::FillUp

(

)

Definition at line 4114 of file excel8.cpp.

Find()

LPDISPATCH Range::Find	(	const VARIANT &	What,
		const VARIANT &	After,
		const VARIANT &	LookIn,
		const VARIANT &	LookAt,
		const VARIANT &	SearchOrder,
		long	SearchDirection,
		const VARIANT &	MatchCase,
		const VARIANT &	MatchByte,
		const VARIANT &	MatchControlCharacters,
		const VARIANT &	MatchDiacritics,
		const VARIANT &	MatchKashida,
		const VARIANT &	MatchAlefHamza )

Definition at line 4119 of file excel8.cpp.

FindNext()

LPDISPATCH Range::FindNext

(

const VARIANT &

After

)

Definition at line 4130 of file excel8.cpp.

FindPrevious()

LPDISPATCH Range::FindPrevious

(

const VARIANT &

After

)

Definition at line 4140 of file excel8.cpp.

FunctionWizard()

void Range::FunctionWizard

(

)

Definition at line 4262 of file excel8.cpp.

Get_Default()

VARIANT Range::Get_Default	(	const VARIANT &	RowIndex,
		const VARIANT &	ColumnIndex )

Definition at line 4011 of file excel8.cpp.

Get_NewEnum()

LPUNKNOWN Range::Get_NewEnum

(

)

Definition at line 4498 of file excel8.cpp.

GetAddIndent()

VARIANT Range::GetAddIndent

(

)

Definition at line 3708 of file excel8.cpp.

GetAddress()

CString Range::GetAddress	(	const VARIANT &	RowAbsolute,
		const VARIANT &	ColumnAbsolute,
		long	ReferenceStyle,
		const VARIANT &	External,
		const VARIANT &	RelativeTo )

Definition at line 3723 of file excel8.cpp.

GetAddressLocal()

CString Range::GetAddressLocal	(	const VARIANT &	RowAbsolute,
		const VARIANT &	ColumnAbsolute,
		long	ReferenceStyle,
		const VARIANT &	External,
		const VARIANT &	RelativeTo )

Definition at line 3733 of file excel8.cpp.

GetApplication()

LPDISPATCH Range::GetApplication

(

)

Definition at line 3682 of file excel8.cpp.

GetAreas()

LPDISPATCH Range::GetAreas

(

)

Definition at line 3764 of file excel8.cpp.

GetBorders()

LPDISPATCH Range::GetBorders

(

)

Definition at line 3823 of file excel8.cpp.

GetCells()

LPDISPATCH Range::GetCells

(

)

Definition at line 3835 of file excel8.cpp.

GetCharacters()

LPDISPATCH Range::GetCharacters	(	const VARIANT &	Start,
		const VARIANT &	Length )

Definition at line 3842 of file excel8.cpp.

GetColumn()

long Range::GetColumn

(

)

Definition at line 3885 of file excel8.cpp.

GetColumns()

LPDISPATCH Range::GetColumns

(

)

Definition at line 3902 of file excel8.cpp.

GetColumnWidth()

VARIANT Range::GetColumnWidth

(

)

Definition at line 3909 of file excel8.cpp.

GetComment()

LPDISPATCH Range::GetComment

(

)

Definition at line 5066 of file excel8.cpp.

GetCount()

long Range::GetCount

(

)

Definition at line 3958 of file excel8.cpp.

GetCreator()

long Range::GetCreator

(

)

Definition at line 3689 of file excel8.cpp.

GetCurrentArray()

LPDISPATCH Range::GetCurrentArray

(

)

Definition at line 3981 of file excel8.cpp.

GetCurrentRegion()

LPDISPATCH Range::GetCurrentRegion

(

)

Definition at line 3988 of file excel8.cpp.

GetDependents()

LPDISPATCH Range::GetDependents

(

)

Definition at line 4037 of file excel8.cpp.

GetDirectDependents()

LPDISPATCH Range::GetDirectDependents

(

)

Definition at line 4051 of file excel8.cpp.

GetDirectPrecedents()

LPDISPATCH Range::GetDirectPrecedents

(

)

Definition at line 4058 of file excel8.cpp.

GetEnd()

LPDISPATCH Range::GetEnd

(

long

Direction

)

Definition at line 4075 of file excel8.cpp.

GetEntireColumn()

LPDISPATCH Range::GetEntireColumn

(

)

Definition at line 4085 of file excel8.cpp.

GetEntireRow()

LPDISPATCH Range::GetEntireRow

(

)

Definition at line 4092 of file excel8.cpp.

GetFont()

LPDISPATCH Range::GetFont

(

)

Definition at line 4150 of file excel8.cpp.

GetFormatConditions()

LPDISPATCH Range::GetFormatConditions

(

)

Definition at line 5085 of file excel8.cpp.

GetFormula()

VARIANT Range::GetFormula

(

)

Definition at line 4157 of file excel8.cpp.

GetFormulaArray()

VARIANT Range::GetFormulaArray

(

)

Definition at line 4172 of file excel8.cpp.

GetFormulaHidden()

VARIANT Range::GetFormulaHidden

(

)

Definition at line 4202 of file excel8.cpp.

GetFormulaLabel()

long Range::GetFormulaLabel

(

)

Definition at line 4187 of file excel8.cpp.

GetFormulaLocal()

VARIANT Range::GetFormulaLocal

(

)

Definition at line 4217 of file excel8.cpp.

GetFormulaR1C1()

VARIANT Range::GetFormulaR1C1

(

)

Definition at line 4232 of file excel8.cpp.

GetFormulaR1C1Local()

VARIANT Range::GetFormulaR1C1Local

(

)

Definition at line 4247 of file excel8.cpp.

GetHasArray()

VARIANT Range::GetHasArray

(

)

Definition at line 4287 of file excel8.cpp.

GetHasFormula()

VARIANT Range::GetHasFormula

(

)

Definition at line 4294 of file excel8.cpp.

GetHeight()

VARIANT Range::GetHeight

(

)

Definition at line 4301 of file excel8.cpp.

GetHidden()

VARIANT Range::GetHidden

(

)

Definition at line 4308 of file excel8.cpp.

GetHorizontalAlignment()

VARIANT Range::GetHorizontalAlignment

(

)

Definition at line 4323 of file excel8.cpp.

GetHyperlinks()

LPDISPATCH Range::GetHyperlinks

(

)

Definition at line 5107 of file excel8.cpp.

GetIndentLevel()

VARIANT Range::GetIndentLevel

(

)

Definition at line 4338 of file excel8.cpp.

GetInterior()

LPDISPATCH Range::GetInterior

(

)

Definition at line 4369 of file excel8.cpp.

GetItem()

VARIANT Range::GetItem	(	const VARIANT &	RowIndex,
		const VARIANT &	ColumnIndex )

Definition at line 4376 of file excel8.cpp.

GetLeft()

VARIANT Range::GetLeft

(

)

Definition at line 4399 of file excel8.cpp.

GetListHeaderRows()

long Range::GetListHeaderRows

(

)

Definition at line 4406 of file excel8.cpp.

GetLocationInTable()

long Range::GetLocationInTable

(

)

Definition at line 4418 of file excel8.cpp.

GetLocked()

VARIANT Range::GetLocked

(

)

Definition at line 4425 of file excel8.cpp.

GetMergeArea()

LPDISPATCH Range::GetMergeArea

(

)

Definition at line 4453 of file excel8.cpp.

GetMergeCells()

VARIANT Range::GetMergeCells

(

)

Definition at line 4460 of file excel8.cpp.

GetName()

VARIANT Range::GetName

(

)

Definition at line 4475 of file excel8.cpp.

GetNext()

LPDISPATCH Range::GetNext

(

)

Definition at line 4505 of file excel8.cpp.

GetNumberFormat()

VARIANT Range::GetNumberFormat

(

)

Definition at line 4522 of file excel8.cpp.

GetNumberFormatLocal()

VARIANT Range::GetNumberFormatLocal

(

)

Definition at line 4537 of file excel8.cpp.

GetOffset()

LPDISPATCH Range::GetOffset	(	const VARIANT &	RowOffset,
		const VARIANT &	ColumnOffset )

Definition at line 4552 of file excel8.cpp.

GetOrientation()

VARIANT Range::GetOrientation

(

)

Definition at line 4562 of file excel8.cpp.

GetOutlineLevel()

VARIANT Range::GetOutlineLevel

(

)

Definition at line 4577 of file excel8.cpp.

GetPageBreak()

long Range::GetPageBreak

(

)

Definition at line 4592 of file excel8.cpp.

GetParent()

LPDISPATCH Range::GetParent

(

)

Definition at line 3696 of file excel8.cpp.

GetPhonetic()

LPDISPATCH Range::GetPhonetic

(

)

Definition at line 5078 of file excel8.cpp.

GetPivotField()

LPDISPATCH Range::GetPivotField

(

)

Definition at line 4623 of file excel8.cpp.

GetPivotItem()

LPDISPATCH Range::GetPivotItem

(

)

Definition at line 4630 of file excel8.cpp.

GetPivotTable()

LPDISPATCH Range::GetPivotTable

(

)

Definition at line 4637 of file excel8.cpp.

GetPrecedents()

LPDISPATCH Range::GetPrecedents

(

)

Definition at line 4644 of file excel8.cpp.

GetPrefixCharacter()

VARIANT Range::GetPrefixCharacter

(

)

Definition at line 4651 of file excel8.cpp.

GetPrevious()

LPDISPATCH Range::GetPrevious

(

)

Definition at line 4658 of file excel8.cpp.

GetQueryTable()

LPDISPATCH Range::GetQueryTable

(

)

Definition at line 4681 of file excel8.cpp.

GetRange()

LPDISPATCH Range::GetRange	(	const VARIANT &	Cell1,
		const VARIANT &	Cell2 )

Definition at line 4688 of file excel8.cpp.

GetReadingOrder()

long Range::GetReadingOrder

(

)

Definition at line 5092 of file excel8.cpp.

GetResize()

LPDISPATCH Range::GetResize	(	const VARIANT &	RowSize,
		const VARIANT &	ColumnSize )

Definition at line 4714 of file excel8.cpp.

GetRow()

long Range::GetRow

(

)

Definition at line 4724 of file excel8.cpp.

GetRowHeight()

VARIANT Range::GetRowHeight

(

)

Definition at line 4741 of file excel8.cpp.

GetRows()

LPDISPATCH Range::GetRows

(

)

Definition at line 4756 of file excel8.cpp.

GetShowDetail()

VARIANT Range::GetShowDetail

(

)

Definition at line 4794 of file excel8.cpp.

GetShrinkToFit()

VARIANT Range::GetShrinkToFit

(

)

Definition at line 4822 of file excel8.cpp.

GetSoundNote()

LPDISPATCH Range::GetSoundNote

(

)

Definition at line 4854 of file excel8.cpp.

GetStyle()

VARIANT Range::GetStyle

(

)

Definition at line 4871 of file excel8.cpp.

GetSummary()

VARIANT Range::GetSummary

(

)

Definition at line 4902 of file excel8.cpp.

GetText()

VARIANT Range::GetText

(

)

Definition at line 4917 of file excel8.cpp.

GetTop()

VARIANT Range::GetTop

(

)

Definition at line 4933 of file excel8.cpp.

GetUseStandardHeight()

VARIANT Range::GetUseStandardHeight

(

)

Definition at line 4945 of file excel8.cpp.

GetUseStandardWidth()

VARIANT Range::GetUseStandardWidth

(

)

Definition at line 4960 of file excel8.cpp.

GetValidation()

LPDISPATCH Range::GetValidation

(

)

Definition at line 4975 of file excel8.cpp.

GetValue()

VARIANT Range::GetValue

(

)

Definition at line 4982 of file excel8.cpp.

GetValue2()

VARIANT Range::GetValue2

(

)

Definition at line 4997 of file excel8.cpp.

GetVerticalAlignment()

VARIANT Range::GetVerticalAlignment

(

)

Definition at line 5012 of file excel8.cpp.

GetWidth()

VARIANT Range::GetWidth

(

)

Definition at line 5027 of file excel8.cpp.

GetWorksheet()

LPDISPATCH Range::GetWorksheet

(

)

Definition at line 5034 of file excel8.cpp.

GetWrapText()

VARIANT Range::GetWrapText

(

)

Definition at line 5041 of file excel8.cpp.

GoalSeek()

BOOL Range::GoalSeek	(	const VARIANT &	Goal,
		LPDISPATCH	ChangingCell )

Definition at line 4267 of file excel8.cpp.

Group()

VARIANT Range::Group	(	const VARIANT &	Start,
		const VARIANT &	End,
		const VARIANT &	By,
		const VARIANT &	Periods )

Definition at line 4277 of file excel8.cpp.

Insert()

void Range::Insert

(

const VARIANT &

Shift

)

Definition at line 4361 of file excel8.cpp.

InsertIndent()

void Range::InsertIndent

(

long

InsertAmount

)

Definition at line 4353 of file excel8.cpp.

Justify()

void Range::Justify

(

)

Definition at line 4394 of file excel8.cpp.

ListNames()

void Range::ListNames

(

)

Definition at line 4413 of file excel8.cpp.

Merge()

void Range::Merge

(

const VARIANT &

Across

)

Definition at line 4440 of file excel8.cpp.

NavigateArrow()

void Range::NavigateArrow	(	const VARIANT &	TowardPrecedent,
		const VARIANT &	ArrowNumber,
		const VARIANT &	LinkNumber )

Definition at line 4490 of file excel8.cpp.

NoteText()

CString Range::NoteText	(	const VARIANT &	Text,
		const VARIANT &	Start,
		const VARIANT &	Length )

Definition at line 4512 of file excel8.cpp.

Parse()

void Range::Parse	(	const VARIANT &	ParseLine,
		const VARIANT &	Destination )

Definition at line 4607 of file excel8.cpp.

PasteSpecial()

void Range::PasteSpecial	(	long	Paste,
		long	Operation,
		const VARIANT &	SkipBlanks,
		const VARIANT &	Transpose )

Definition at line 4615 of file excel8.cpp.

PrintOut()

void Range::PrintOut	(	const VARIANT &	From,
		const VARIANT &	To,
		const VARIANT &	Copies,
		const VARIANT &	Preview,
		const VARIANT &	ActivePrinter,
		const VARIANT &	PrintToFile,
		const VARIANT &	Collate )

Definition at line 4665 of file excel8.cpp.

PrintPreview()

void Range::PrintPreview

(

const VARIANT &

EnableChanges

)

Definition at line 4673 of file excel8.cpp.

RemoveSubtotal()

void Range::RemoveSubtotal

(

)

Definition at line 4698 of file excel8.cpp.

Replace()

BOOL Range::Replace	(	const VARIANT &	What,
		const VARIANT &	Replacement,
		const VARIANT &	LookAt,
		const VARIANT &	SearchOrder,
		const VARIANT &	MatchCase,
		const VARIANT &	MatchByte,
		const VARIANT &	MatchControlCharacters,
		const VARIANT &	MatchDiacritics,
		const VARIANT &	MatchKashida,
		const VARIANT &	MatchAlefHamza )

Definition at line 4703 of file excel8.cpp.

RowDifferences()

LPDISPATCH Range::RowDifferences

(

const VARIANT &

Comparison

)

Definition at line 4731 of file excel8.cpp.

Run()

VARIANT Range::Run	(	const VARIANT &	Arg1,
		const VARIANT &	Arg2,
		const VARIANT &	Arg3,
		const VARIANT &	Arg4,
		const VARIANT &	Arg5,
		const VARIANT &	Arg6,
		const VARIANT &	Arg7,
		const VARIANT &	Arg8,
		const VARIANT &	Arg9,
		const VARIANT &	Arg10,
		const VARIANT &	Arg11,
		const VARIANT &	Arg12,
		const VARIANT &	Arg13,
		const VARIANT &	Arg14,
		const VARIANT &	Arg15,
		const VARIANT &	Arg16,
		const VARIANT &	Arg17,
		const VARIANT &	Arg18,
		const VARIANT &	Arg19,
		const VARIANT &	Arg20,
		const VARIANT &	Arg21,
		const VARIANT &	Arg22,
		const VARIANT &	Arg23,
		const VARIANT &	Arg24,
		const VARIANT &	Arg25,
		const VARIANT &	Arg26,
		const VARIANT &	Arg27,
		const VARIANT &	Arg28,
		const VARIANT &	Arg29,
		const VARIANT &	Arg30 )

Definition at line 4763 of file excel8.cpp.

Select()

void Range::Select

(

)

Definition at line 4776 of file excel8.cpp.

Set_Default()

void Range::Set_Default	(	const VARIANT &	RowIndex,
		const VARIANT &	ColumnIndex,
		const VARIANT &	newValue )

Definition at line 4021 of file excel8.cpp.

SetAddIndent()

void Range::SetAddIndent

(

const VARIANT &

newValue

)

Definition at line 3715 of file excel8.cpp.

SetColumnWidth()

void Range::SetColumnWidth

(

const VARIANT &

newValue

)

Definition at line 3916 of file excel8.cpp.

SetFormula()

void Range::SetFormula

(

const VARIANT &

newValue

)

Definition at line 4164 of file excel8.cpp.

SetFormulaArray()

void Range::SetFormulaArray

(

const VARIANT &

newValue

)

Definition at line 4179 of file excel8.cpp.

SetFormulaHidden()

void Range::SetFormulaHidden

(

const VARIANT &

newValue

)

Definition at line 4209 of file excel8.cpp.

SetFormulaLabel()

void Range::SetFormulaLabel

(

long

nNewValue

)

Definition at line 4194 of file excel8.cpp.

SetFormulaLocal()

void Range::SetFormulaLocal

(

const VARIANT &

newValue

)

Definition at line 4224 of file excel8.cpp.

SetFormulaR1C1()

void Range::SetFormulaR1C1

(

const VARIANT &

newValue

)

Definition at line 4239 of file excel8.cpp.

SetFormulaR1C1Local()

void Range::SetFormulaR1C1Local

(

const VARIANT &

newValue

)

Definition at line 4254 of file excel8.cpp.

SetHidden()

void Range::SetHidden

(

const VARIANT &

newValue

)

Definition at line 4315 of file excel8.cpp.

SetHorizontalAlignment()

void Range::SetHorizontalAlignment

(

const VARIANT &

newValue

)

Definition at line 4330 of file excel8.cpp.

SetIndentLevel()

void Range::SetIndentLevel

(

const VARIANT &

newValue

)

Definition at line 4345 of file excel8.cpp.

SetItem()

void Range::SetItem	(	const VARIANT &	RowIndex,
		const VARIANT &	ColumnIndex,
		const VARIANT &	newValue )

Definition at line 4386 of file excel8.cpp.

SetLocked()

void Range::SetLocked

(

const VARIANT &

newValue

)

Definition at line 4432 of file excel8.cpp.

SetMergeCells()

void Range::SetMergeCells

(

const VARIANT &

newValue

)

Definition at line 4467 of file excel8.cpp.

SetName()

void Range::SetName

(

const VARIANT &

newValue

)

Definition at line 4482 of file excel8.cpp.

SetNumberFormat()

void Range::SetNumberFormat

(

const VARIANT &

newValue

)

Definition at line 4529 of file excel8.cpp.

SetNumberFormatLocal()

void Range::SetNumberFormatLocal

(

const VARIANT &

newValue

)

Definition at line 4544 of file excel8.cpp.

SetOrientation()

void Range::SetOrientation

(

const VARIANT &

newValue

)

Definition at line 4569 of file excel8.cpp.

SetOutlineLevel()

void Range::SetOutlineLevel

(

const VARIANT &

newValue

)

Definition at line 4584 of file excel8.cpp.

SetPageBreak()

void Range::SetPageBreak

(

long

nNewValue

)

Definition at line 4599 of file excel8.cpp.

SetReadingOrder()

void Range::SetReadingOrder

(

long

nNewValue

)

Definition at line 5099 of file excel8.cpp.

SetRowHeight()

void Range::SetRowHeight

(

const VARIANT &

newValue

)

Definition at line 4748 of file excel8.cpp.

SetShowDetail()

void Range::SetShowDetail

(

const VARIANT &

newValue

)

Definition at line 4801 of file excel8.cpp.

SetShrinkToFit()

void Range::SetShrinkToFit

(

const VARIANT &

newValue

)

Definition at line 4829 of file excel8.cpp.

SetStyle()

void Range::SetStyle

(

const VARIANT &

newValue

)

Definition at line 4878 of file excel8.cpp.

SetUseStandardHeight()

void Range::SetUseStandardHeight

(

const VARIANT &

newValue

)

Definition at line 4952 of file excel8.cpp.

SetUseStandardWidth()

void Range::SetUseStandardWidth

(

const VARIANT &

newValue

)

Definition at line 4967 of file excel8.cpp.

SetValue()

void Range::SetValue

(

const VARIANT &

newValue

)

Definition at line 4989 of file excel8.cpp.

SetValue2()

void Range::SetValue2

(

const VARIANT &

newValue

)

Definition at line 5004 of file excel8.cpp.

SetVerticalAlignment()

void Range::SetVerticalAlignment

(

const VARIANT &

newValue

)

Definition at line 5019 of file excel8.cpp.

SetWrapText()

void Range::SetWrapText

(

const VARIANT &

newValue

)

Definition at line 5048 of file excel8.cpp.

Show()

void Range::Show

(

)

Definition at line 4781 of file excel8.cpp.

ShowDependents()

void Range::ShowDependents

(

const VARIANT &

Remove

)

Definition at line 4786 of file excel8.cpp.

ShowErrors()

void Range::ShowErrors

(

)

Definition at line 4809 of file excel8.cpp.

ShowPrecedents()

void Range::ShowPrecedents

(

const VARIANT &

Remove

)

Definition at line 4814 of file excel8.cpp.

Sort()

void Range::Sort	(	const VARIANT &	Key1,
		long	Order1,
		const VARIANT &	Key2,
		const VARIANT &	Type,
		long	Order2,
		const VARIANT &	Key3,
		long	Order3,
		long	Header,
		const VARIANT &	OrderCustom,
		const VARIANT &	MatchCase,
		long	Orientation,
		long	SortMethod,
		const VARIANT &	IgnoreControlCharacters,
		const VARIANT &	IgnoreDiacritics,
		const VARIANT &	IgnoreKashida )

Definition at line 4837 of file excel8.cpp.

SortSpecial()

void Range::SortSpecial	(	long	SortMethod,
		const VARIANT &	Key1,
		long	Order1,
		const VARIANT &	Type,
		const VARIANT &	Key2,
		long	Order2,
		const VARIANT &	Key3,
		long	Order3,
		long	Header,
		const VARIANT &	OrderCustom,
		const VARIANT &	MatchCase,
		long	Orientation )

Definition at line 4846 of file excel8.cpp.

SpecialCells()

LPDISPATCH Range::SpecialCells	(	long	Type,
		const VARIANT &	Value )

Definition at line 4861 of file excel8.cpp.

SubscribeTo()

void Range::SubscribeTo	(	LPCTSTR	Edition,
		long	Format )

Definition at line 4886 of file excel8.cpp.

Subtotal()

void Range::Subtotal	(	long	GroupBy,
		long	Function,
		const VARIANT &	TotalList,
		const VARIANT &	Replace,
		const VARIANT &	PageBreaks,
		long	SummaryBelowData )

Definition at line 4894 of file excel8.cpp.

Table()

void Range::Table	(	const VARIANT &	RowInput,
		const VARIANT &	ColumnInput )

Definition at line 4909 of file excel8.cpp.

TextToColumns()

void Range::TextToColumns	(	const VARIANT &	Destination,
		long	DataType,
		long	TextQualifier,
		const VARIANT &	ConsecutiveDelimiter,
		const VARIANT &	Tab,
		const VARIANT &	Semicolon,
		const VARIANT &	Comma,
		const VARIANT &	Space,
		const VARIANT &	Other,
		const VARIANT &	OtherChar,
		const VARIANT &	FieldInfo )

Definition at line 4924 of file excel8.cpp.

Ungroup()

void Range::Ungroup

(

)

Definition at line 4940 of file excel8.cpp.

UnMerge()

void Range::UnMerge

(

)

Definition at line 4448 of file excel8.cpp.

---

The documentation for this class was generated from the following files:

• Code/Tools/Babylon/excel8.h
• Code/Tools/Babylon/excel8.cpp