Worksheet::CrossTab

CrossTab

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Do cross tabulation

Syntax

int CrossTab( int nvRow, int nvCol, int nData, matrix & m, vector<string> * pvsRowVals, vector<string> * pvsColVals, int nStatsType = CT_COUNT, DWORD dwCntrl = 0, LPWksCrossTabMore pMore = NULL )

Parameters

nvRow: [input] the column index of the current worksheet, which is used for the Row variable on the crosstab
nvCol: [input] the column index of the current worksheet, which is used for the column variable on the crosstab
nData: [input] the column index of the current worksheet, which is used for the Data variable on the crosstab
m: [output] the matrix with resulting values, based on nStatsType
pvsRowVals: [output] the name of the Row items get from row variable
pvsColVals: [output] the name of the column items get from column variable
nStatsType: [input] = CT_COUNT, count the records from current worksheet, according to pvsRowVals and pvsColVals.; = CT_SUM, get the sum of the data, which specified by nData, according to pvsRowVals and pvsColVals.; = CT_MIN, get the min of the data, which specified by nData, according to pvsRowVals and pvsColVals.; = CT_MAX, get the max of the data, which specified by nData, according to pvsRowVals and pvsColVals.; = CT_MEAN, get the mean of the data, which specified by nData, according pvsRowVals and pvsColVals.
dwCntrl: [input]options
pMore: [input]Structure of most options

typedef struct tagWksCrossTabMore
{
        const char*              lpcszExtraColumnSource;
        const char*              lpcszExtraRowSource;
}WksCrossTabMore, *LPWksCrossTabMore;

Return

return 0 if successful, <0 if failure

Examples

EX1

//assuming that there is a worksheet, which you want to do the cross tabulation 
void cross_tab_ex1()
{
        Worksheet wks = Project.ActiveLayer();
        MatrixPage mpg;
        mpg.Create("Origin.otm");
        
        MatrixLayer ml = mpg.Layers(0);
        Matrix matResult(ml, 0);
        vector<string>  vsRowVals, vsColVals;
        // do cross tabulation according to column 1 and 2 of current worksheet
        // column 1 as Row variable, and column 2 as Col variable.
        int nRet = wks.CrossTab(1, 2, 0, matResult, &vsRowVals, &vsColVals);
        
        int ii;
        for ( ii = 0; ii < vsRowVals.GetSize(); ii++ )
        {
                out_str(vsRowVals[ii]);
        }
        
        for ( ii = 0; ii < vsColVals.GetSize(); ii++ )
        {
                out_str(vsColVals[ii]);
        }
}