Richard Boegli's CnC_Generals_Zero_Hour Fork WIP
This is documentation of Richard Boegil's Zero Hour Fork
 
Loading...
Searching...
No Matches
Public Member Functions | List of all members
_Worksheet Class Reference

#include <excel8.h>

Inherits COleDispatchDriver.

Public Member Functions

 _Worksheet ()
 
 _Worksheet (LPDISPATCH pDispatch)
 
 _Worksheet (const _Worksheet &dispatchSrc)
 
LPDISPATCH GetApplication ()
 
long GetCreator ()
 
LPDISPATCH GetParent ()
 
void Activate ()
 
void Copy (const VARIANT &Before, const VARIANT &After)
 
void Delete ()
 
CString GetCodeName ()
 
CString Get_CodeName ()
 
void Set_CodeName (LPCTSTR lpszNewValue)
 
long GetIndex ()
 
void Move (const VARIANT &Before, const VARIANT &After)
 
CString GetName ()
 
void SetName (LPCTSTR lpszNewValue)
 
LPDISPATCH GetNext ()
 
LPDISPATCH GetPageSetup ()
 
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)
 
void Protect (const VARIANT &Password, const VARIANT &DrawingObjects, const VARIANT &Contents, const VARIANT &Scenarios, const VARIANT &UserInterfaceOnly)
 
BOOL GetProtectContents ()
 
BOOL GetProtectDrawingObjects ()
 
BOOL GetProtectionMode ()
 
BOOL GetProtectScenarios ()
 
void SaveAs (LPCTSTR Filename, const VARIANT &FileFormat, const VARIANT &Password, const VARIANT &WriteResPassword, const VARIANT &ReadOnlyRecommended, const VARIANT &CreateBackup, const VARIANT &AddToMru, const VARIANT &TextCodepage, const VARIANT &TextVisualLayout)
 
void Select (const VARIANT &Replace)
 
void Unprotect (const VARIANT &Password)
 
long GetVisible ()
 
void SetVisible (long nNewValue)
 
LPDISPATCH GetShapes ()
 
BOOL GetTransitionExpEval ()
 
void SetTransitionExpEval (BOOL bNewValue)
 
BOOL GetAutoFilterMode ()
 
void SetAutoFilterMode (BOOL bNewValue)
 
void SetBackgroundPicture (LPCTSTR Filename)
 
void Calculate ()
 
BOOL GetEnableCalculation ()
 
void SetEnableCalculation (BOOL bNewValue)
 
LPDISPATCH GetCells ()
 
LPDISPATCH ChartObjects (const VARIANT &Index)
 
void CheckSpelling (const VARIANT &CustomDictionary, const VARIANT &IgnoreUppercase, const VARIANT &AlwaysSuggest, const VARIANT &IgnoreInitialAlefHamza, const VARIANT &IgnoreFinalYaa, const VARIANT &SpellScript)
 
LPDISPATCH GetCircularReference ()
 
void ClearArrows ()
 
LPDISPATCH GetColumns ()
 
long GetConsolidationFunction ()
 
VARIANT GetConsolidationOptions ()
 
VARIANT GetConsolidationSources ()
 
BOOL GetEnableAutoFilter ()
 
void SetEnableAutoFilter (BOOL bNewValue)
 
long GetEnableSelection ()
 
void SetEnableSelection (long nNewValue)
 
BOOL GetEnableOutlining ()
 
void SetEnableOutlining (BOOL bNewValue)
 
BOOL GetEnablePivotTable ()
 
void SetEnablePivotTable (BOOL bNewValue)
 
VARIANT Evaluate (const VARIANT &Name)
 
VARIANT _Evaluate (const VARIANT &Name)
 
BOOL GetFilterMode ()
 
void ResetAllPageBreaks ()
 
LPDISPATCH GetNames ()
 
LPDISPATCH OLEObjects (const VARIANT &Index)
 
LPDISPATCH GetOutline ()
 
void Paste (const VARIANT &Destination, const VARIANT &Link)
 
void PasteSpecial (const VARIANT &Format, const VARIANT &Link, const VARIANT &DisplayAsIcon, const VARIANT &IconFileName, const VARIANT &IconIndex, const VARIANT &IconLabel)
 
LPDISPATCH PivotTables (const VARIANT &Index)
 
LPDISPATCH PivotTableWizard (const VARIANT &SourceType, const VARIANT &SourceData, const VARIANT &TableDestination, const VARIANT &TableName, const VARIANT &RowGrand, const VARIANT &ColumnGrand, const VARIANT &SaveData, const VARIANT &HasAutoFormat, const VARIANT &AutoPage, const VARIANT &Reserved, const VARIANT &BackgroundQuery, const VARIANT &OptimizeCache, const VARIANT &PageFieldOrder, const VARIANT &PageFieldWrapCount, const VARIANT &ReadData, const VARIANT &Connection)
 
LPDISPATCH GetRange (const VARIANT &Cell1, const VARIANT &Cell2)
 
LPDISPATCH GetRows ()
 
LPDISPATCH Scenarios (const VARIANT &Index)
 
CString GetScrollArea ()
 
void SetScrollArea (LPCTSTR lpszNewValue)
 
void ShowAllData ()
 
void ShowDataForm ()
 
double GetStandardHeight ()
 
double GetStandardWidth ()
 
void SetStandardWidth (double newValue)
 
BOOL GetTransitionFormEntry ()
 
void SetTransitionFormEntry (BOOL bNewValue)
 
long GetType ()
 
LPDISPATCH GetUsedRange ()
 
LPDISPATCH GetHPageBreaks ()
 
LPDISPATCH GetVPageBreaks ()
 
LPDISPATCH GetQueryTables ()
 
BOOL GetDisplayPageBreaks ()
 
void SetDisplayPageBreaks (BOOL bNewValue)
 
LPDISPATCH GetComments ()
 
LPDISPATCH GetHyperlinks ()
 
void ClearCircles ()
 
void CircleInvalid ()
 
LPDISPATCH GetAutoFilter ()
 

Detailed Description

Definition at line 476 of file excel8.h.

Constructor & Destructor Documentation

◆ _Worksheet() [1/3]

_Worksheet::_Worksheet ( )
inline

Definition at line 479 of file excel8.h.

◆ _Worksheet() [2/3]

_Worksheet::_Worksheet ( LPDISPATCH pDispatch)
inline

Definition at line 480 of file excel8.h.

◆ _Worksheet() [3/3]

_Worksheet::_Worksheet ( const _Worksheet & dispatchSrc)
inline

Definition at line 481 of file excel8.h.

Member Function Documentation

◆ _Evaluate()

VARIANT _Worksheet::_Evaluate ( const VARIANT & Name)

Definition at line 3421 of file excel8.cpp.

◆ Activate()

void _Worksheet::Activate ( )

Definition at line 3038 of file excel8.cpp.

◆ Calculate()

void _Worksheet::Calculate ( )

Definition at line 3266 of file excel8.cpp.

◆ ChartObjects()

LPDISPATCH _Worksheet::ChartObjects ( const VARIANT & Index)

Definition at line 3293 of file excel8.cpp.

◆ CheckSpelling()

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

Definition at line 3303 of file excel8.cpp.

◆ CircleInvalid()

void _Worksheet::CircleInvalid ( )

Definition at line 3663 of file excel8.cpp.

◆ ClearArrows()

void _Worksheet::ClearArrows ( )

Definition at line 3318 of file excel8.cpp.

◆ ClearCircles()

void _Worksheet::ClearCircles ( )

Definition at line 3658 of file excel8.cpp.

◆ Copy()

void _Worksheet::Copy ( const VARIANT & Before,
const VARIANT & After )

Definition at line 3043 of file excel8.cpp.

◆ Delete()

void _Worksheet::Delete ( )

Definition at line 3051 of file excel8.cpp.

◆ Evaluate()

VARIANT _Worksheet::Evaluate ( const VARIANT & Name)

Definition at line 3411 of file excel8.cpp.

◆ Get_CodeName()

CString _Worksheet::Get_CodeName ( )

Definition at line 3063 of file excel8.cpp.

◆ GetApplication()

LPDISPATCH _Worksheet::GetApplication ( )

Definition at line 3017 of file excel8.cpp.

◆ GetAutoFilter()

LPDISPATCH _Worksheet::GetAutoFilter ( )

Definition at line 3668 of file excel8.cpp.

◆ GetAutoFilterMode()

BOOL _Worksheet::GetAutoFilterMode ( )

Definition at line 3243 of file excel8.cpp.

◆ GetCells()

LPDISPATCH _Worksheet::GetCells ( )

Definition at line 3286 of file excel8.cpp.

◆ GetCircularReference()

LPDISPATCH _Worksheet::GetCircularReference ( )

Definition at line 3311 of file excel8.cpp.

◆ GetCodeName()

CString _Worksheet::GetCodeName ( )

Definition at line 3056 of file excel8.cpp.

◆ GetColumns()

LPDISPATCH _Worksheet::GetColumns ( )

Definition at line 3323 of file excel8.cpp.

◆ GetComments()

LPDISPATCH _Worksheet::GetComments ( )

Definition at line 3644 of file excel8.cpp.

◆ GetConsolidationFunction()

long _Worksheet::GetConsolidationFunction ( )

Definition at line 3330 of file excel8.cpp.

◆ GetConsolidationOptions()

VARIANT _Worksheet::GetConsolidationOptions ( )

Definition at line 3337 of file excel8.cpp.

◆ GetConsolidationSources()

VARIANT _Worksheet::GetConsolidationSources ( )

Definition at line 3344 of file excel8.cpp.

◆ GetCreator()

long _Worksheet::GetCreator ( )

Definition at line 3024 of file excel8.cpp.

◆ GetDisplayPageBreaks()

BOOL _Worksheet::GetDisplayPageBreaks ( )

Definition at line 3629 of file excel8.cpp.

◆ GetEnableAutoFilter()

BOOL _Worksheet::GetEnableAutoFilter ( )

Definition at line 3351 of file excel8.cpp.

◆ GetEnableCalculation()

BOOL _Worksheet::GetEnableCalculation ( )

Definition at line 3271 of file excel8.cpp.

◆ GetEnableOutlining()

BOOL _Worksheet::GetEnableOutlining ( )

Definition at line 3381 of file excel8.cpp.

◆ GetEnablePivotTable()

BOOL _Worksheet::GetEnablePivotTable ( )

Definition at line 3396 of file excel8.cpp.

◆ GetEnableSelection()

long _Worksheet::GetEnableSelection ( )

Definition at line 3366 of file excel8.cpp.

◆ GetFilterMode()

BOOL _Worksheet::GetFilterMode ( )

Definition at line 3431 of file excel8.cpp.

◆ GetHPageBreaks()

LPDISPATCH _Worksheet::GetHPageBreaks ( )

Definition at line 3608 of file excel8.cpp.

◆ GetHyperlinks()

LPDISPATCH _Worksheet::GetHyperlinks ( )

Definition at line 3651 of file excel8.cpp.

◆ GetIndex()

long _Worksheet::GetIndex ( )

Definition at line 3078 of file excel8.cpp.

◆ GetName()

CString _Worksheet::GetName ( )

Definition at line 3093 of file excel8.cpp.

◆ GetNames()

LPDISPATCH _Worksheet::GetNames ( )

Definition at line 3443 of file excel8.cpp.

◆ GetNext()

LPDISPATCH _Worksheet::GetNext ( )

Definition at line 3108 of file excel8.cpp.

◆ GetOutline()

LPDISPATCH _Worksheet::GetOutline ( )

Definition at line 3460 of file excel8.cpp.

◆ GetPageSetup()

LPDISPATCH _Worksheet::GetPageSetup ( )

Definition at line 3115 of file excel8.cpp.

◆ GetParent()

LPDISPATCH _Worksheet::GetParent ( )

Definition at line 3031 of file excel8.cpp.

◆ GetPrevious()

LPDISPATCH _Worksheet::GetPrevious ( )

Definition at line 3122 of file excel8.cpp.

◆ GetProtectContents()

BOOL _Worksheet::GetProtectContents ( )

Definition at line 3153 of file excel8.cpp.

◆ GetProtectDrawingObjects()

BOOL _Worksheet::GetProtectDrawingObjects ( )

Definition at line 3160 of file excel8.cpp.

◆ GetProtectionMode()

BOOL _Worksheet::GetProtectionMode ( )

Definition at line 3167 of file excel8.cpp.

◆ GetProtectScenarios()

BOOL _Worksheet::GetProtectScenarios ( )

Definition at line 3174 of file excel8.cpp.

◆ GetQueryTables()

LPDISPATCH _Worksheet::GetQueryTables ( )

Definition at line 3622 of file excel8.cpp.

◆ GetRange()

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

Definition at line 3505 of file excel8.cpp.

◆ GetRows()

LPDISPATCH _Worksheet::GetRows ( )

Definition at line 3515 of file excel8.cpp.

◆ GetScrollArea()

CString _Worksheet::GetScrollArea ( )

Definition at line 3532 of file excel8.cpp.

◆ GetShapes()

LPDISPATCH _Worksheet::GetShapes ( )

Definition at line 3221 of file excel8.cpp.

◆ GetStandardHeight()

double _Worksheet::GetStandardHeight ( )

Definition at line 3557 of file excel8.cpp.

◆ GetStandardWidth()

double _Worksheet::GetStandardWidth ( )

Definition at line 3564 of file excel8.cpp.

◆ GetTransitionExpEval()

BOOL _Worksheet::GetTransitionExpEval ( )

Definition at line 3228 of file excel8.cpp.

◆ GetTransitionFormEntry()

BOOL _Worksheet::GetTransitionFormEntry ( )

Definition at line 3579 of file excel8.cpp.

◆ GetType()

long _Worksheet::GetType ( )

Definition at line 3594 of file excel8.cpp.

◆ GetUsedRange()

LPDISPATCH _Worksheet::GetUsedRange ( )

Definition at line 3601 of file excel8.cpp.

◆ GetVisible()

long _Worksheet::GetVisible ( )

Definition at line 3206 of file excel8.cpp.

◆ GetVPageBreaks()

LPDISPATCH _Worksheet::GetVPageBreaks ( )

Definition at line 3615 of file excel8.cpp.

◆ Move()

void _Worksheet::Move ( const VARIANT & Before,
const VARIANT & After )

Definition at line 3085 of file excel8.cpp.

◆ OLEObjects()

LPDISPATCH _Worksheet::OLEObjects ( const VARIANT & Index)

Definition at line 3450 of file excel8.cpp.

◆ Paste()

void _Worksheet::Paste ( const VARIANT & Destination,
const VARIANT & Link )

Definition at line 3467 of file excel8.cpp.

◆ PasteSpecial()

void _Worksheet::PasteSpecial ( const VARIANT & Format,
const VARIANT & Link,
const VARIANT & DisplayAsIcon,
const VARIANT & IconFileName,
const VARIANT & IconIndex,
const VARIANT & IconLabel )

Definition at line 3475 of file excel8.cpp.

◆ PivotTables()

LPDISPATCH _Worksheet::PivotTables ( const VARIANT & Index)

Definition at line 3483 of file excel8.cpp.

◆ PivotTableWizard()

LPDISPATCH _Worksheet::PivotTableWizard ( const VARIANT & SourceType,
const VARIANT & SourceData,
const VARIANT & TableDestination,
const VARIANT & TableName,
const VARIANT & RowGrand,
const VARIANT & ColumnGrand,
const VARIANT & SaveData,
const VARIANT & HasAutoFormat,
const VARIANT & AutoPage,
const VARIANT & Reserved,
const VARIANT & BackgroundQuery,
const VARIANT & OptimizeCache,
const VARIANT & PageFieldOrder,
const VARIANT & PageFieldWrapCount,
const VARIANT & ReadData,
const VARIANT & Connection )

Definition at line 3493 of file excel8.cpp.

◆ PrintOut()

void _Worksheet::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 3129 of file excel8.cpp.

◆ PrintPreview()

void _Worksheet::PrintPreview ( const VARIANT & EnableChanges)

Definition at line 3137 of file excel8.cpp.

◆ Protect()

void _Worksheet::Protect ( const VARIANT & Password,
const VARIANT & DrawingObjects,
const VARIANT & Contents,
const VARIANT & Scenarios,
const VARIANT & UserInterfaceOnly )

Definition at line 3145 of file excel8.cpp.

◆ ResetAllPageBreaks()

void _Worksheet::ResetAllPageBreaks ( )

Definition at line 3438 of file excel8.cpp.

◆ SaveAs()

void _Worksheet::SaveAs ( LPCTSTR Filename,
const VARIANT & FileFormat,
const VARIANT & Password,
const VARIANT & WriteResPassword,
const VARIANT & ReadOnlyRecommended,
const VARIANT & CreateBackup,
const VARIANT & AddToMru,
const VARIANT & TextCodepage,
const VARIANT & TextVisualLayout )

Definition at line 3181 of file excel8.cpp.

◆ Scenarios()

LPDISPATCH _Worksheet::Scenarios ( const VARIANT & Index)

Definition at line 3522 of file excel8.cpp.

◆ Select()

void _Worksheet::Select ( const VARIANT & Replace)

Definition at line 3190 of file excel8.cpp.

◆ Set_CodeName()

void _Worksheet::Set_CodeName ( LPCTSTR lpszNewValue)

Definition at line 3070 of file excel8.cpp.

◆ SetAutoFilterMode()

void _Worksheet::SetAutoFilterMode ( BOOL bNewValue)

Definition at line 3250 of file excel8.cpp.

◆ SetBackgroundPicture()

void _Worksheet::SetBackgroundPicture ( LPCTSTR Filename)

Definition at line 3258 of file excel8.cpp.

◆ SetDisplayPageBreaks()

void _Worksheet::SetDisplayPageBreaks ( BOOL bNewValue)

Definition at line 3636 of file excel8.cpp.

◆ SetEnableAutoFilter()

void _Worksheet::SetEnableAutoFilter ( BOOL bNewValue)

Definition at line 3358 of file excel8.cpp.

◆ SetEnableCalculation()

void _Worksheet::SetEnableCalculation ( BOOL bNewValue)

Definition at line 3278 of file excel8.cpp.

◆ SetEnableOutlining()

void _Worksheet::SetEnableOutlining ( BOOL bNewValue)

Definition at line 3388 of file excel8.cpp.

◆ SetEnablePivotTable()

void _Worksheet::SetEnablePivotTable ( BOOL bNewValue)

Definition at line 3403 of file excel8.cpp.

◆ SetEnableSelection()

void _Worksheet::SetEnableSelection ( long nNewValue)

Definition at line 3373 of file excel8.cpp.

◆ SetName()

void _Worksheet::SetName ( LPCTSTR lpszNewValue)

Definition at line 3100 of file excel8.cpp.

◆ SetScrollArea()

void _Worksheet::SetScrollArea ( LPCTSTR lpszNewValue)

Definition at line 3539 of file excel8.cpp.

◆ SetStandardWidth()

void _Worksheet::SetStandardWidth ( double newValue)

Definition at line 3571 of file excel8.cpp.

◆ SetTransitionExpEval()

void _Worksheet::SetTransitionExpEval ( BOOL bNewValue)

Definition at line 3235 of file excel8.cpp.

◆ SetTransitionFormEntry()

void _Worksheet::SetTransitionFormEntry ( BOOL bNewValue)

Definition at line 3586 of file excel8.cpp.

◆ SetVisible()

void _Worksheet::SetVisible ( long nNewValue)

Definition at line 3213 of file excel8.cpp.

◆ ShowAllData()

void _Worksheet::ShowAllData ( )

Definition at line 3547 of file excel8.cpp.

◆ ShowDataForm()

void _Worksheet::ShowDataForm ( )

Definition at line 3552 of file excel8.cpp.

◆ Unprotect()

void _Worksheet::Unprotect ( const VARIANT & Password)

Definition at line 3198 of file excel8.cpp.

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