XLL+ Class Library

TFold Sample

Overview

This sample add-in demonstrates the use of the COper and CXlOper classes.

The TFOLD function in the add-in is a very useful utility for creating arrays of cells from individual cells and ranges in worksheets. If you want to use an add-in function that expects arguments to be in a certain shape, you can use TFOLD to create a correctly shaped array on the fly, instead of changing your worksheet to suit the demands of the function.

Using TFOLD and TFOLDT

The TFOLD.XLS demo workbook shows TFOLD and TFOLDT is use.

A very powerful use of TFOLDT is also shown in LabelledArgs.xls, which is part of the LabelledArgs sample.

Functions used

COper::GetDims
COper::IsMissing
COper::VectorCell
CXlOper::AllocArray
CXlOper::Cell
CXlOper::RetError
CXlOper::Ret

Project files

If you are using MS Developer Studio 6, then you should open the project file TFold.dsp.

If you are using MS Visual Studio .NET 2002, then you should open the solution file TFold.sln or the project file TFold.vcproj.

If you are using MS Visual Studio .NET 2003, then you should open the solution file TFold71.sln or the project file TFold71.vcproj.

If you are using MS Visual Studio 2005, then you should open the solution file TFold8.sln or the project file TFold8.vcproj.

See Also

List of Sample Projects | Samples and Walkthroughs | LabelledArgs sample