Planatech
XLL+
Contents
sync toc
XLL Plus 5.0
XLL Plus 5.0
What's New in 5.0
How Do I...
Frequently Asked Questions
A Mathematician's Introduction to XLL Add-ins
Samples and walkthroughs
Samples and walkthroughs
Sample Projects
List of Sample Projects
AvgOpt
AvgOptAsync
BinaryData
CalcEvt
CallExcel
ColorCell
ComEvents
CreateBook
Dialogs
FInspect
FindReplace
HandleAPI
HandleAPICached
Integration
Localized (Multiple DLLs)
Localized (Single DLL)
International
KeyedHandle
LabelledArgs
Simple Menus
MfcTutorial
PartialReg
SafeCode
Serialize
SetFormula
SimpOpt
Advanced Menus
TFold
Simple Toolbar
Simple Toolbar using resources
Dynamic Toolbar
Tutorial1
UseTimer
Walkthroughs
Walkthroughs
Arrays
Adding a vector argument
Returning a vector result
Adding a matrix argument
Returning a matrix result
Installing your own matrix class
Function Wizard Features
Grouping multiple arguments into a single Excel range
Using Excel features
Calling an Excel built-in function from your add-in
Creating and populating a worksheet from your add-in
Graphical User Interface
Adding your own menus
Displaying native Excel dialogs
Example code
List of Examples
COper::Cell() Example
COper::ColToVector() & RowToVector() Example
COper::GetCount() Example
COper::GetDims() Example
COper::GetHeight() Example
COper::GetWidth() Example
COper::IsArray() Example
COper::IsBool() Example
COper::IsDouble() Example
COper::IsEmpty() Example
COper::IsError() Example
COper::IsMissing() Example
COper::IsPresent() Example
COper::IsString() Example
COper::operator BOOL() Example
COper::operator CString() Example
COper::operator double() Example
COper::operator [] Example
COper::ReadOpt() Examples
COper::ToBool() Example
COper::ToDouble() Example
COper::ToDoubleArray() Examples
COper::ToMatrix() Example
COper::ToString() Example
COper::VectorCell() Example
CXllApp::GetNextFnAssoc() Example
CXllApp::PrefixFunctions() Example
CXllApp::SplitSheetName() Example
CXlOper::AllocArray() Example
CXlOper::Coerce() Example
CXlOper::Excel() Example
CXlOper::FromNumericVector() Example
CXlOper::FromVector() Example
CXlOper::GetCaller() Example
CXlOper::GetCallerDims() Example
CXlOper::SetLongFormula() Example
CXlOper::SetLongFormulaIntl() Example
CXlRef Example
matrix<T>::add_col() Example
matrix<T>::add_row() Example
mtx_ptrs<T> Example
MyAddress Example
MyCorrel Example
MyDaysInFeb Example
MyDaysInMonth Example
MyMonthsInYear Example
MySort Example
MySqrt Example
MySquare Example
MySum Example
MyUpper Example
XLL+ User Guide
XLL+ User Guide
Quick start
Quick start
Quick start for Visual Studio 6
Quick start for Visual Studio .NET & Visual Studio 2005
Installing XLL+
Registering the add-in in Visual Studio 6
Registering the add-in in Visual Studio .NET & Visual Studio 2005
Creating a project
Creating an add-in project in Visual Studio 6
Creating an add-in project in Visual Studio .NET or Visual Studio 2005
Writing an add-in function
Designing an add-in function
Define the function
Add an argument
Completing the code
Testing your add-in function
Building your add-in library in Visual Studio 6
Testing & Debugging in Visual Studio 6
Building your add-in library in Visual Studio .NET or Visual Studio 2005
Testing & Debugging in Visual Studio .NET or Visual Studio 2005
Variable return types
Functions with variable return types
Returning CXlOper
Inside CXlOper
Errors in Excel
Vector arguments
A Function with a vector argument
Creating a vector argument
Understanding the vector code
Input errors in Excel
Modifying an add-in function
Modifying an add-in function
Changes to the generated code
Optional arguments
Adding an optional argument
Using COper for optional arguments
Reading an optional argument
Matrix arguments
Matrix arguments
Two-dimensional linear interpolation function
Creating a matrix argument
Using data in a matrix object
Matrix layouts
Using the Edit Argument Dialog
Using a matrix with continuous values
Array results
Returning vectors to Excel
Array formulae in Excel
Returning matrices to Excel
Array results the hard way
Handling events
Application level data - CXllApp
Overriding OnXllOpenEx()
Volatile functions
COM events
Excel Formula Wizard
Using the Excel Formula Wizard
Avoiding the Excel Formula Wizard
Automating the code
Sized result arrays
Sized result arrays
Macro functions
Macro functions
Setting cell values
Find/Replace
CXlMacros class
Using references
Setting formulae
Menus and toolbars
Menus
Toolbars
MFC dialogs
Using the Microsoft Foundation Classes
Calling MFC methods
Writing safe code
Crashing Excel
C Structured Exception handling
Object handles
Object handles
Object handles using pointers
Object handles using references and cached data
Groups
Grouping arguments
Compressed groups
Column groups
International support
International support
Levels of support
Choice of languages
Ensuring stable behavior
String substitutions
Types of string
Deployment
Conversion of an existing project
Multi-threaded add-ins using RTD
Real-time data overview
Real-time data requirements
Flow
ThreadManager class
RTD mechanism
AvgOptData class
AvgOptDataCache class
Converting a project to RTD
Step 1 - Remove argument cache
Step 2 - Insert AvgOptDataCache
Step 3 - Add a worker thread
Step 4 - Modify add-in function
Step 5 - Modify "Clear cache" command
Using the function in a spreadsheet
Tuning RTD
Further enhancements
COM server module: XllRtdLink
Class Reference
Class Reference
List of Header Files
List of Classes
xllplus.h
xllplus.h
CExcelWnd
CExcelWnd Object
CExcelWnd Methods
CExcelWnd::CExcelWnd
COper
COper Object
COper Methods
COper::AllocArray
COper::Cell
COper::Clear
COper::ColToVector
COper::COper
COper::FreeArray
COper::FromBool
COper::FromDouble
COper::FromDoubleArray
COper::FromError
COper::FromString
COper::GetCount
COper::GetDims
COper::GetHeight
COper::GetVectorCount
COper::GetWidth
COper::Init
COper::IsArray
COper::IsBool
COper::IsDouble
COper::IsEmpty
COper::IsError
COper::IsMissing
COper::IsPresent
COper::IsString
COper::IsVector
COper::operator =
COper::operator BOOL
COper::operator bool
COper::operator CString
COper::operator double
COper::operator []
COper::ReadArrayIntoOrderedCollection1D
COper::ReadArrayIntoSet1D
COper::ReadColumn
COper::ReadGroupItem
COper::ReadMatrix
COper::ReadOpt
COper::ReadOptional
COper::ReadRow
COper::ReadValue
COper::ReadVector
COper::ReadVectorItem
COper::RowToVector
COper::ToBool
COper::ToDouble
COper::ToDoubleArray
COper::ToMatrix
COper::ToString
COper::VectorCell
CXlArray
CXlArray Object
CXlArray Methods
CXlArray::Alloc
CXlArray::AllocInit
CXlArray::Cell
CXlArray::Clear
CXlArray::Compare
CXlArray::Count
CXlArray::Create
CXlArray::CreateFromCols
CXlArray::CreateFromRows
CXlArray::CXlArray
CXlArray::GetArray
CXlArray::GetDims
CXlArray::GetHeight
CXlArray::GetWidth
CXlArray::InitZero
CXlArray::operator !=
CXlArray::operator <
CXlArray::operator <=
CXlArray::operator =
CXlArray::operator ==
CXlArray::operator >
CXlArray::operator >=
CXlArray::Owned
CXlArray::ReadMatrix
CXlArray::ReadVector
CXlArray::Ret
CXlArray::Row
CXlBinaryNameData
CXlBinaryNameData Object
CXlBinaryNameData Methods
CXlBinaryNameData::CXlBinaryNameData
CXlBinaryNameData::GetCount
CXlBinaryNameData::GetData
CXlBinaryNameData::~CXlBinaryNameData
CXllApp
CXllApp Object
CXllApp Methods
CXllApp::AddFn
CXllApp::AddStaticFns
CXllApp::CancelUserAbort
CXllApp::ClearBinaryName
CXllApp::CXllApp
CXllApp::DefineBinaryName
CXllApp::ErrorToString
CXllApp::Excel
CXllApp::FindFn
CXllApp::GetBinaryName
CXllApp::GetCalculationMode
CXllApp::GetCallerDims
CXllApp::GetComEventHandler
CXllApp::GetFnCount
CXllApp::GetInternational
CXllApp::GetNextFnAssoc
CXllApp::GetRegDllName
CXllApp::GetSheetId
CXllApp::GetSheetName
CXllApp::GetSinkEvents
CXllApp::GetStartFnPosition
CXllApp::GetUserAbort
CXllApp::GetVersionInfo
CXllApp::GetXllName
CXllApp::IsInFormulaWizard
CXllApp::MakeSheetName
CXllApp::OnNewWorkbook
CXllApp::OnSheetActivate
CXllApp::OnSheetBeforeDoubleClick
CXllApp::OnSheetBeforeRightClick
CXllApp::OnSheetCalculate
CXllApp::OnSheetChange
CXllApp::OnSheetDeactivate
CXllApp::OnSheetSelectionChange
CXllApp::OnWorkbookActivate
CXllApp::OnWorkbookBeforeClose
CXllApp::OnWorkbookBeforeSave
CXllApp::OnWorkbookDeactivate
CXllApp::OnWorkbookNewSheet
CXllApp::OnWorkbookOpen
CXllApp::OnXllClose
CXllApp::OnXllLoad
CXllApp::OnXllOpen
CXllApp::OnXllOpenEx
CXllApp::OnXllRegister
CXllApp::OnXllUnload
CXllApp::OnXllUnregister
CXllApp::PrefixFunctions
CXllApp::RemoveFn
CXllApp::RetString
CXllApp::SetCalculationMode
CXllApp::SetComEventHandler
CXllApp::SetErrorHandling
CXllApp::SetSinkEvents
CXllApp::SplitSheetName
CXllApp::WinMessageBox
CXllApp::XlGetStackSpace
CXllApp::XlHwnd
CXllApp::XlMessageBox
CXllApp::XlVersion
CXllFn
CXllFn Object
CXllFn Methods
CXllFn::IsRegistered
CXlOper
CXlOper Object
CXlOper Methods
CXlOper::AllocArray
CXlOper::CallAddin
CXlOper::Cell
CXlOper::ChangeType
CXlOper::Clear
CXlOper::Coerce
CXlOper::Compare
CXlOper::ConvertFormula
CXlOper::ConvertFormulaIntl
CXlOper::CXlOper
CXlOper::Excel
CXlOper::Format
CXlOper::FreeArray
CXlOper::FromBool
CXlOper::FromDouble
CXlOper::FromDoubleArray
CXlOper::FromError
CXlOper::FromInt
CXlOper::FromMatrix
CXlOper::FromMRef
CXlOper::FromNumericVector
CXlOper::FromSRef
CXlOper::FromString
CXlOper::FromVector
CXlOper::GetActiveCell
CXlOper::GetCaller
CXlOper::GetCount
CXlOper::GetDims
CXlOper::GetFormula
CXlOper::GetFormulaIntl
CXlOper::GetHeight
CXlOper::GetLongString
CXlOper::GetRef
CXlOper::GetRefCount
CXlOper::GetRefItem
CXlOper::GetSheetId
CXlOper::GetSheetName
CXlOper::GetVectorCount
CXlOper::GetWidth
CXlOper::GetXLREFItem
CXlOper::Init
CXlOper::IsArray
CXlOper::IsBool
CXlOper::IsDouble
CXlOper::IsEmpty
CXlOper::IsError
CXlOper::IsInt
CXlOper::IsMissing
CXlOper::IsMRef
CXlOper::IsRef
CXlOper::IsSRef
CXlOper::IsString
CXlOper::IsVector
CXlOper::MakeRef
CXlOper::MakeRefIntl
CXlOper::operator !=
CXlOper::operator <
CXlOper::operator <=
CXlOper::operator =
CXlOper::operator ==
CXlOper::operator >
CXlOper::operator >=
CXlOper::operator BOOL
CXlOper::operator CString
CXlOper::operator double
CXlOper::operator []
CXlOper::ReadMatrix
CXlOper::ReadVector
CXlOper::Ret
CXlOper::RetError
CXlOper::RetString
CXlOper::RetVal
CXlOper::SetActiveCell
CXlOper::SetFormula
CXlOper::SetFormulaIntl
CXlOper::SetLongFormula
CXlOper::SetLongFormulaIntl
CXlOper::SetValue
CXlOper::ToBool
CXlOper::ToDouble
CXlOper::ToInt
CXlOper::ToSRef
CXlOper::ToString
CXlOper::ToXLREF
CXlOper::VectorCell
CXlRef
CXlRef Object
CXlRef Methods
CXlRef::Bottom
CXlRef::BottomRightToString
CXlRef::ColToA
CXlRef::CXlRef
CXlRef::FromString
CXlRef::GetRowColumnLetters
CXlRef::Height
CXlRef::Init
CXlRef::IsSingle
CXlRef::Left
CXlRef::MaxCol
CXlRef::MaxRow
CXlRef::MoveBy
CXlRef::Normalize
CXlRef::operator =
CXlRef::Right
CXlRef::SetRef
CXlRef::Top
CXlRef::TopLeftToString
CXlRef::ToString
CXlRef::Width
Global functions & macros
Global functions & macros
::IMPLEMENT_XLLFN2
::IMPLEMENT_XLLFN_EX
::XllGetApp
::XllGetTypedApp
::XLL_FIX_STATE
xlldate.h
xlldate.h
Global date functions
Global date functions
::XlDateToLSerial
::XlDateToSerial
::XlLSerialToDate
::XlNow
::XlSerialToDate
::XlStringToDate
::XlStringToLSerial
::XlStringToSerial
::XlToday
::XlWeekday
xlfuncs.h
xlfuncs.h
CXlFuncs
CXlFuncs Object
CXlFuncs Methods
CXlFuncs::Address
CXlFuncs::Cell
CXlFuncs::CellAddress
CXlFuncs::CellCol
CXlFuncs::CellColor
CXlFuncs::CellContents
CXlFuncs::CellFileName
CXlFuncs::CellFormat
CXlFuncs::CellParentheses
CXlFuncs::CellPrefix
CXlFuncs::CellProtect
CXlFuncs::CellRow
CXlFuncs::CellType
CXlFuncs::CellWidth
CXlFuncs::Char
CXlFuncs::Clean
CXlFuncs::Code
CXlFuncs::Date
CXlFuncs::DateValue
CXlFuncs::Day
CXlFuncs::Days360
CXlFuncs::HLookup
CXlFuncs::Hour
CXlFuncs::Index
CXlFuncs::Indirect
CXlFuncs::Info
CXlFuncs::InfoDirectory
CXlFuncs::InfoMemAvail
CXlFuncs::InfoMemUsed
CXlFuncs::InfoNumFile
CXlFuncs::InfoOrigin
CXlFuncs::InfoOSVersion
CXlFuncs::InfoRecalc
CXlFuncs::InfoRecalcAutomatic
CXlFuncs::InfoRecalcManual
CXlFuncs::InfoRelease
CXlFuncs::InfoSystem
CXlFuncs::InfoSystemMac
CXlFuncs::InfoSystemWindows
CXlFuncs::InfoTotMem
CXlFuncs::Lookup
CXlFuncs::Match
CXlFuncs::MDeterm
CXlFuncs::Minute
CXlFuncs::MInverse
CXlFuncs::Month
CXlFuncs::N
CXlFuncs::Now
CXlFuncs::Offset
CXlFuncs::Roman
CXlFuncs::Second
CXlFuncs::Text
CXlFuncs::Time
CXlFuncs::TimeValue
CXlFuncs::Today
CXlFuncs::Transpose
CXlFuncs::Type
CXlFuncs::Value
CXlFuncs::VLookup
CXlFuncs::Weekday
CXlFuncs::Year
CXlMacros
CXlMacros Object
CXlMacros Methods
CXlMacros::AbsRef
CXlMacros::Activate
CXlMacros::ActivateNext
CXlMacros::ActivatePrev
CXlMacros::ActiveCell
CXlMacros::ActiveCellFont
CXlMacros::AddinManager
CXlMacros::Alert
CXlMacros::Alignment
CXlMacros::ApplyStyle
CXlMacros::AppMaximize
CXlMacros::AppMinimize
CXlMacros::AppMove
CXlMacros::AppRestore
CXlMacros::AppSize
CXlMacros::AppTitle
CXlMacros::Beep
CXlMacros::Border
CXlMacros::CalculateDocument
CXlMacros::CalculateNow
CXlMacros::Caller
CXlMacros::CellProtection
CXlMacros::Clear
CXlMacros::Close
CXlMacros::CloseAll
CXlMacros::ColumnWidth
CXlMacros::Copy
CXlMacros::Cut
CXlMacros::DataSeries
CXlMacros::DefineName
CXlMacros::DeleteName
CXlMacros::DeRef
CXlMacros::Directory
CXlMacros::DisableInput
CXlMacros::Documents
CXlMacros::Echo
CXlMacros::EditDelete
CXlMacros::Evaluate
CXlMacros::EvaluateIntl
CXlMacros::FileClose
CXlMacros::FileDelete
CXlMacros::Files
CXlMacros::FillAuto
CXlMacros::FillDown
CXlMacros::FillGroup
CXlMacros::FillLeft
CXlMacros::FillRight
CXlMacros::FillUp
CXlMacros::FontProperties
CXlMacros::FormatNumber
CXlMacros::Formula
CXlMacros::FormulaArray
CXlMacros::FormulaArrayIntl
CXlMacros::FormulaConvert
CXlMacros::FormulaFill
CXlMacros::FormulaIntl
CXlMacros::FormulaReplace
CXlMacros::FullScreen
CXlMacros::GetActiveWorkbookName
CXlMacros::GetActiveWorksheetName
CXlMacros::GetCell
CXlMacros::GetCellIsArray
CXlMacros::GetCellIsFormula
CXlMacros::GetCellIsHidden
CXlMacros::GetCellIsLocked
CXlMacros::GetDef
CXlMacros::GetDocument
CXlMacros::GetFormula
CXlMacros::GetFormulaIntl
CXlMacros::GetName
CXlMacros::GetNameIsLocal
CXlMacros::GetNote
CXlMacros::GetWorkbook
CXlMacros::GetWorkspace
CXlMacros::GoalSeek
CXlMacros::Hide
CXlMacros::HLine
CXlMacros::HPage
CXlMacros::HScroll
CXlMacros::Insert
CXlMacros::Justify
CXlMacros::Links
CXlMacros::Names
CXlMacros::NewDefaultWorkbook
CXlMacros::NewSingleSheetWorkbook
CXlMacros::NewWindow
CXlMacros::Note
CXlMacros::Open
CXlMacros::OptionsCalculation
CXlMacros::Paste
CXlMacros::PasteSpecial
CXlMacros::Quit
CXlMacros::RefText
CXlMacros::RelRef
CXlMacros::RowHeight
CXlMacros::Save
CXlMacros::SaveAs
CXlMacros::SaveCopyAs
CXlMacros::Select
CXlMacros::SelectAll
CXlMacros::Selection
CXlMacros::ShowActiveCell
CXlMacros::StandardWidth
CXlMacros::SummaryInfo
CXlMacros::TextRef
CXlMacros::Undo
CXlMacros::Unhide
CXlMacros::VLine
CXlMacros::VPage
CXlMacros::VScroll
CXlMacros::WindowMaximize
CXlMacros::WindowMinimize
CXlMacros::WindowMove
CXlMacros::WindowRestore
CXlMacros::Windows
CXlMacros::WindowSize
CXlMacros::WorkbookActivate
CXlMacros::WorkbookCopy
CXlMacros::WorkbookDelete
CXlMacros::WorkbookGetWorksheetNames
CXlMacros::WorkbookHide
CXlMacros::WorkbookInsert
CXlMacros::WorkbookMove
CXlMacros::WorkbookName
CXlMacros::WorkbookNext
CXlMacros::WorkbookPrev
CXlMacros::WorkbookProtect
CXlMacros::WorkbookUnhide
CXlMacros::Zoom
CXlMacros::ZoomMax
CXlMacros::ZoomNormal
xlserialize.h
xlserialize.h
CXlCacheBinding<C>
CXlCacheBinding<C> Object
CXlCacheBinding<C> Methods
CXlCacheBinding<C>::CXlCacheBinding
CXlCacheBinding<C>::Find
CXlCacheBinding<C>::Ret
CXlCacheBinding<C>::~CXlCacheBinding
CXlInputKey
CXlInputKey Object
CXlInputKey Methods
CXlInputKey::CXlInputKey
CXlInputKey::operator =
CXlIStream
CXlIStream Object
CXlIStream Methods
CXlIStream::CXlIStream
CXlIStream::operator >>
CXlIStrStream
CXlIStrStream Object
CXlIStrStream Methods
CXlIStrStream::CXlIStrStream
CXlOperCache
CXlOperCache Object
CXlOperCache Methods
CXlOperCache::Add
CXlOperCache::Clear
CXlOperCache::CXlOperCache
CXlOperCache::Find
CXlOperCache::GetMaxSize
CXlOperCache::ReduceSize
CXlOperCache::Restore
CXlOperCache::Save
CXlOperCache::Set
CXlOperCache::SetMaxSize
CXlOStream
CXlOStream Object
CXlOStream Methods
CXlOStream::CXlOStream
CXlOStream::operator <<
CXlOStream::read_args
CXlOStream::read_args_from_template
CXlOStrStream
CXlOStrStream Object
CXlOStrStream Methods
CXlOStrStream::CXlOStrStream
CXlOStrStream::pcount
CXlOStrStream::str
CXlSerialData
CXlSerialData Object
CXlSerialData Methods
CXlSerialData::Alloc
CXlSerialData::Attach
CXlSerialData::Clear
CXlSerialData::Compare
CXlSerialData::CopyXlOper
CXlSerialData::CXlSerialData
CXlSerialData::Destroy
CXlSerialData::Detach
CXlSerialData::GetCount
CXlSerialData::GetData
CXlSerialData::GetDataBuffer
CXlSerialData::GetXlOper
CXlSerialData::IsGood
CXlSerialData::MoveFrom
CXlSerialData::operator !=
CXlSerialData::operator <
CXlSerialData::operator <=
CXlSerialData::operator =
CXlSerialData::operator =
CXlSerialData::operator >
CXlSerialData::operator >=
CXlSerialData::ReadArgList
CXlSerialData::ReadArgs
CXlSerialData::Set
xlpcom.h
xlpcom.h
CXllCom
CXllCom Object
CXllCom Methods
CXllCom::CXllCom
CXllCom::Init
CXllCom::OleExecuteExcel4Macro
CXllCom::OleGetOnCalculate
CXllCom::OleGetOnSheetActivate
CXllCom::OleGetOnSheetDeactivate
CXllCom::OleGetRange
CXllCom::OleGetRangeAddress
CXllCom::OleGetRangeFormula
CXllCom::OleGetRangeValue
CXllCom::OleGetRangeWorksheet
CXllCom::OleGetWarnings
CXllCom::OleGetWorkbook
CXllCom::OleGetWorkbookName
CXllCom::OleGetWorkbooks
CXllCom::OleGetWorksheet
CXllCom::OleGetWorksheetName
CXllCom::OleGetWorksheets
CXllCom::OleGetWorksheetWorkbook
CXllCom::OleRangeIsCurrent
CXllCom::OleRangeIsFirst
CXllCom::OleSetOnCalculate
CXllCom::OleSetOnSheetActivate
CXllCom::OleSetOnSheetDeactivate
CXllCom::OleSetWarnings
CXllCom::OleTouchRange
CXllCom::OleWorksheetFindFormula
CXllCom::Term
plemtx.h
plemtx.h
imtx<T>
imtx<T> Object
imtx<T> Methods
imtx<T>::at
imtx<T>::get_flat
imtx<T>::get_ptrs
imtx<T>::resize
imtx<T>::size
imtx_impl<T>
imtx_impl<T> Object
imtx_impl<T> Methods
imtx_impl<T>::get_flat
imtx_impl<T>::get_ptrs
mtx_flat<T>
mtx_flat<T> Object
mtx_flat<T> Methods
mtx_flat<T>::at
mtx_flat<T>::begin
mtx_flat<T>::end
mtx_flat<T>::get_flat
mtx_flat<T>::get_ptrs
mtx_flat<T>::mtx_flat
mtx_flat<T>::operator =
mtx_flat<T>::operator []
mtx_flat<T>::operator [] const
mtx_flat<T>::resize
mtx_flat<T>::size
mtx_flatreader<M>
mtx_flatreader<M> Object
mtx_flatreader<M> Methods
mtx_flatreader<M>::get_flat
mtx_flatreader<M>::mtx_flatreader
mtx_flatreader<M>::operator const M::mtx_item_type*
mtx_flatreader<M>::operator M::mtx_item_type*
mtx_flatwriter<M>
mtx_flatwriter<M> Object
mtx_flatwriter<M> Methods
mtx_flatwriter<M>::get_flat
mtx_flatwriter<M>::mtx_flatwriter
mtx_flatwriter<M>::operator M::mtx_item_type*
mtx_ptrreader<M>
mtx_ptrreader<M> Object
mtx_ptrreader<M> Methods
mtx_ptrreader<M>::get_ptrs
mtx_ptrreader<M>::mtx_ptrreader
mtx_ptrreader<M>::operator const M::mtx_item_type**
mtx_ptrreader<M>::operator M::mtx_item_type**
mtx_ptrs<T>
mtx_ptrs<T> Object
mtx_ptrs<T> Methods
mtx_ptrs<T>::at
mtx_ptrs<T>::begin
mtx_ptrs<T>::end
mtx_ptrs<T>::erase
mtx_ptrs<T>::get_flat
mtx_ptrs<T>::get_ptrs
mtx_ptrs<T>::mtx_ptrs
mtx_ptrs<T>::operator =
mtx_ptrs<T>::operator []
mtx_ptrs<T>::operator [] const
mtx_ptrs<T>::resize
mtx_ptrs<T>::size
mtx_ptrwriter<M>
mtx_ptrwriter<M> Object
mtx_ptrwriter<M> Methods
mtx_ptrwriter<M>::get_ptrs
mtx_ptrwriter<M>::mtx_ptrwriter
mtx_ptrwriter<M>::operator M::mtx_item_type**
Matrix template functions
Matrix template functions
::copy_offset<M, N>
::flatreader<M>
::flatwriter<M>
::mtx_copy<M, N>
::mtx_copy_transpose<M, N>
::mtx_flatten<M, V>
::mtx_transpose<M>
::ptrreader<M>
::ptrwriter<M>
xllfinder.h
xllfinder.h
CXllFinder
CXllFinder Object
CXllFinder Methods
CXllFinder::CXllFinder
CXllFinder::FindNext
CXllFinder::GetCurrentValue
CXllFinder::SetCurrentValue
xldialog.h
xldialog.h
CXlControl
CXlControl Object
CXlControl Methods
CXlControl::CXlControl
CXlControl::GetEnabled
CXlControl::GetHeight
CXlControl::GetID
CXlControl::GetLeft
CXlControl::GetText
CXlControl::GetTop
CXlControl::GetTrigger
CXlControl::GetValue
CXlControl::GetVisible
CXlControl::GetWidth
CXlControl::SetEnabled
CXlControl::SetID
CXlControl::SetPos
CXlControl::SetSize
CXlControl::SetText
CXlControl::SetTrigger
CXlControl::SetValue
CXlControl::SetVisible
CXlControlCancel
CXlControlCancel Object
CXlControlCancel Methods
CXlControlCancel::CXlControlCancel
CXlControlCancel::GetDefault
CXlControlCancel::SetDefault
CXlControlCheckBox
CXlControlCheckBox Object
CXlControlCheckBox Methods
CXlControlCheckBox::CXlControlCheckBox
CXlControlCheckBox::GetChecked
CXlControlCheckBox::SetChecked
CXlControlFormulaEdit
CXlControlFormulaEdit Object
CXlControlFormulaEdit Methods
CXlControlFormulaEdit::CXlControlFormulaEdit
CXlControlFormulaEdit::GetFormula
CXlControlFormulaEdit::SetFormula
CXlControlGroupBox
CXlControlGroupBox Object
CXlControlGroupBox Methods
CXlControlGroupBox::CXlControlGroupBox
CXlControlIcon
CXlControlIcon Object
CXlControlIcon Methods
CXlControlIcon::CXlControlIcon
CXlControlIcon::GetIcon
CXlControlIcon::SetIcon
CXlControlIntegerEdit
CXlControlIntegerEdit Object
CXlControlIntegerEdit Methods
CXlControlIntegerEdit::CXlControlIntegerEdit
CXlControlIntegerEdit::GetIntValue
CXlControlIntegerEdit::SetIntValue
CXlControlListBox
CXlControlListBox Object
CXlControlListBox Methods
CXlControlListBox::AddString
CXlControlListBox::CXlControlListBox
CXlControlListBox::DeleteString
CXlControlListBox::FindString
CXlControlListBox::FindStringExact
CXlControlListBox::GetCount
CXlControlListBox::GetCurSel
CXlControlListBox::GetItemData
CXlControlListBox::GetItemDataPtr
CXlControlListBox::GetSel
CXlControlListBox::GetStyle
CXlControlListBox::GetText
CXlControlListBox::GetTextLen
CXlControlListBox::InsertString
CXlControlListBox::ResetContent
CXlControlListBox::SelectString
CXlControlListBox::SetCurSel
CXlControlListBox::SetItemData
CXlControlListBox::SetItemDataPtr
CXlControlListBox::SetStyle
CXlControlNumberEdit
CXlControlNumberEdit Object
CXlControlNumberEdit Methods
CXlControlNumberEdit::CXlControlNumberEdit
CXlControlNumberEdit::GetNumberValue
CXlControlNumberEdit::SetNumberValue
CXlControlOK
CXlControlOK Object
CXlControlOK Methods
CXlControlOK::CXlControlOK
CXlControlOK::GetDefault
CXlControlOK::SetDefault
CXlControlOption
CXlControlOption Object
CXlControlOption Methods
CXlControlOption::CXlControlOption
CXlControlOptionGroup
CXlControlOptionGroup Object
CXlControlOptionGroup Methods
CXlControlOptionGroup::CXlControlOptionGroup
CXlControlOptionGroup::GetSel
CXlControlOptionGroup::SetSel
CXlControlRefEdit
CXlControlRefEdit Object
CXlControlRefEdit Methods
CXlControlRefEdit::CXlControlRefEdit
CXlControlRefEdit::GetRef
CXlControlRefEdit::SetRef
CXlControlStatic
CXlControlStatic Object
CXlControlStatic Methods
CXlControlStatic::CXlControlStatic
CXlControlTextEdit
CXlControlTextEdit Object
CXlControlTextEdit Methods
CXlControlTextEdit::CXlControlTextEdit
CXlDialog
CXlDialog Object
CXlDialog Methods
CXlDialog::Add
CXlDialog::ControlFromID
CXlDialog::CXlDialog
CXlDialog::EndDialog
CXlDialog::GetFocus
CXlDialog::GetHeight
CXlDialog::GetLeft
CXlDialog::GetTitle
CXlDialog::GetTop
CXlDialog::GetWidth
CXlDialog::OnCheckBox
CXlDialog::OnListBox
CXlDialog::OnOK
CXlDialog::OnOption
CXlDialog::OnTrigger
CXlDialog::SetFocus
CXlDialog::SetPos
CXlDialog::SetSize
CXlDialog::SetTitle
CXlDialog::Show
xlmenu.h
xlmenu.h
CXlMenu
CXlMenu Object
CXlMenu Methods
CXlMenu::AddItem
CXlMenu::CheckItem
CXlMenu::Create
CXlMenu::CXlMenu
CXlMenu::DeleteItem
CXlMenu::Destroy
CXlMenu::EnableItem
CXlMenu::GetCallingMenu
CXlMenu::ReplaceItem
CXlMenu::SetTexts
xltoolbar.h
xltoolbar.h
CXlToolbar
CXlToolbar Object
CXlToolbar Methods
CXlToolbar::AddSeparator
CXlToolbar::AddTool
CXlToolbar::AddToolbar
CXlToolbar::AssignToTool
CXlToolbar::DeleteTool
CXlToolbar::DeleteToolbar
CXlToolbar::EnableTool
CXlToolbar::PressTool
CXlToolbar::SetToolBitmap
CXlToolbar::ShowToolbar
CXlToolbarState
CXlToolbarState Object
CXlToolbarState Methods
CXlToolbarState::Clear
CXlToolbarState::FromString
CXlToolbarState::ToString
xllres.h
xllres.h
Global resource functions
Global resource functions
::ResFindLanguageForResource
::ResGetCountryCodeFromLangID
::ResGetLangIDFromCountryCode
::ResGetStringFromStringTable
::ResListLanguages
::ResLoadBitmap
::ResLoadString
::XllGetExcelCountryCode
::XllGetExcelLanguageID
::XllGetStringLanguageID
::XllGetStringResourceHandle
::XllGetTranslatedString
::XllLoadBitmap
::XllLoadBitmapForExcelLanguage
::XllLoadBitmapForLanguage
::XllLoadBitmapForLocale
::XllLoadString
::XllLoadStringForExcelLanguage
::XllLoadStringForLanguage
::XllLoadStringForLocale
::XllSetStringLanguageID
::XllSetStringResourceHandle
::XllTranslateString
xlhandle.h
xlhandle.h
CXlFormulaRefresh
CXlFormulaRefresh Object
CXlFormulaRefresh Methods
CXlFormulaRefresh::CXlFormulaRefresh
CXlFormulaRefresh::RefreshAllWorkbooks
CXlFormulaRefresh::RefreshCell
CXlFormulaRefresh::RefreshWorkbook
CXlFormulaRefresh::RefreshWorksheet
CXlHandleStore<T, S>
CXlHandleStore<T, S> Object
CXlHandleStore<T, S> Methods
CXlHandleStore<T, S>::AddObjectHandle
CXlHandleStore<T, S>::Clear
CXlHandleStore<T, S>::CXlHandleStore
CXlHandleStore<T, S>::ObjectFromHandle
xlppush.h
xlppush.h
CXllMtMsg
CXllMtMsg Object
CXllMtMsg Methods
CXllMtMsg::CXllMtMsg
CXllMtMsg::~CXllMtMsg
CXllPushApp
CXllPushApp Object
CXllPushApp Methods
CXllPushApp::AddConnection
CXllPushApp::AddFunction
CXllPushApp::CXllPushApp
CXllPushApp::GetFormatChangedCells
CXllPushApp::GetRefreshPeriod
CXllPushApp::GetTickPeriod
CXllPushApp::OnCellUpdate
CXllPushApp::OnTopicAdd
CXllPushApp::OnTopicRemove
CXllPushApp::OnXllClose
CXllPushApp::OnXllOpenEx
CXllPushApp::PostMessage
CXllPushApp::ProcessAsyncMessage
CXllPushApp::SetFormatChangedCells
CXllPushApp::SetRefreshPeriod
CXllPushApp::SetTickPeriod
CXllPushApp::UpdateCells
matrix.h
matrix.h
matrix<T>
matrix<T> Object
matrix<T> Methods
vector<T> and matrix<T> Flags
matrix<T>::add_col
matrix<T>::add_row
matrix<T>::at
matrix<T>::clear
matrix<T>::col
matrix<T>::cols
matrix<T>::col_ptr
matrix<T>::find_in_col
matrix<T>::find_in_row
matrix<T>::get_col_ptrs
matrix<T>::matrix<T>
matrix<T>::operator=
matrix<T>::resize
matrix<T>::row
matrix<T>::rows
matrix<T>::transpose
Tools
XLL+ Tools
XLL+ Function Wizard
XLL+ Function Wizard
Setting up the Function Wizard under Developer Studio 6
Installing the Function Wizard under Developer Studio 6
Starting the Function Wizard in Developer Studio 6
Unhiding the XLL+ Toolbar
Setting up the Function Wizard under Visual Studio .NET
Installing the Function Wizard under Visual Studio .NET
Starting the Function Wizard in Visual Studio .NET
Unhiding the XLL+ Menu Items
Reference
Adding a new function
Editing an existing function
Function settings
Function names
Function category
Return type
Function availability
Calculation settings
Function description
Function attribute: nopreview
Function attribute: cacheresults
Function attribute: appscope
Arguments
Adding, removing and reordering arguments
Editing an argument
Argument name
Argument type
Array arguments
Optional arguments
Resource IDs
Function Wizard Windows
Function Wizard Dialog
New Function Dialog
Argument Dialog - General Tab
Argument Dialog - Array Tab
Argument Dialog - Members Tab
Select Group Arguments Dialog
Groups Dialog
Function Attributes Dialog
Options Dialog - General Tab
Options Dialog - AppWizard Tab
Options Dialog - About Tab
Select File Dialog
Export Dialog
Error Dialog
License Dialog
Repeated Function Warning
Resizing and Rearranging Windows
Commands
Summary of Commands
OK Command
Cancel Command
New Function Command
File Open Command
Save Command
Undo Command
Cut Command
Copy Command
Paste Command
Delete Command
View Preview Command
View Toolbar Command
View Argument Resource IDs Command
Groups Command
Function Attributes Command
Disabled in Excel Formula Wizard Command
Uses Application-level Data Command
Cache Results Command
Cut Argument Command
Copy Argument Command
Paste Argument Command
Add Argument Command
Edit Argument Command
Delete Argument Command
Move Argument Up Command
Move Argument Down Command
Scalar Command
Vector Command
Matrix Command
Optional Command
Hide Preview Command
Options Command
Export Command
Reload Template Command
XLL+ AppWizard
XLL+ AppWizard for Visual Studio 6
XLL+ AppWizard - Step 1
XLL+ AppWizard - Step 2
AppWizard Path Dialog
XLL+ AppWizard for Visual Studio .NET or Visual Studio 2005
Starting the XLL+ AppWizard in Visual Studio .NET or Visual Studio 2005
XLL+ AppWizard for .NET/2005
Help Generator
XLL+ Help Generator
COM Wrapper Generator
XLL+ COM wrapper generator overview
Using the wrapper generator
Generated code
Calling the COM methods
Deploying wrapper libraries
Using ComWrapperGen on the command-line
Licenses
XLL+ Licenses
XLL+ License Types
XLL+ License Files
XLL+ License Strings
XLL+ Floating Licenses
XLL+ Demo Licenses
Planatech License Wizard
Planatech License Administration Tool
XlpSetTemplate Tool
XlpSetTemplate Tool
XLL Host
XLL Host Overview
Deployment
Excel Emulators
Class Reference
IExcelEmulator
IExcelEmulator Interface
IExcelEmulator Methods
IExcelEmulator.HandleExcel4
XllDriver
XllDriver Object
XllDriver Methods
XllDriver.CallAddinFunction
XllDriver.CallAddinFunctionA
XllDriver.GetFunctionName
XllDriver.Initialize
XllDriver.InstallExcelEmulator
XllDriver.LoadXll
XllDriver.SaveAsXml
XllDriver.Terminate
XllDriver.UninstallExcelEmulator
Technical notes
XLL+ Change History
Registry Settings
Adapter classes for imtx<T>
Arguments that contain entire columns
Bounded input arrays
Comparison of COper, CXlOper and CXlArray
Compiler Error C1083
Data types
Error codes
Excel built-in function numbers (Alphabetical order)
Excel built-in function numbers (Numeric order)
Functions with no arguments have no description in the Excel Formula Wizard
Limits of argument descriptions
Linker Error LNK2005
Microsoft Excel 4 Function Reference
ResHelp.cpp
System limits
Visual Studio .NET and Visual Studio 2005
XLL+ User Guide - Old topics
XLL+ User Guide - Old Topics
Multi-threaded add-ins
Multi-threaded add-ins
XllPush library
XllPush design
Data flow
Steps to create an asynchronous add-in
Debugging asynchronous add-ins
Distributing asynchronous add-ins
Sample projects
MtBackground sample
MtBackground sample
MtBackground.h
MtBackgroundThread.cpp
MtBackground.cpp
MtBackgroundGui.xla
MtFeed sample
MtFeed sample
MtFeed server application
MtFeed communications module
MtFeedAddin.h
MtFeedAddin.cpp
MtFeedAddinGui.xla
MtCalc sample
MtCalc sample
MtCalc.h
MtCalc.cpp
MtCalcGui.xla