📄 wksheet.cpp

📁 VC++技术内幕(第四版)的实例
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
}

VARIANT Worksheet::Cells(const VARIANT& RowIndex, const VARIANT& ColumnIndex)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0xee, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &RowIndex, &ColumnIndex);
    return result;
}

VARIANT Worksheet::ChartObjects(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x424, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::CheckBoxes(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x338, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x1f9, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &CustomDictionary, &IgnoreUppercase, &AlwaysSuggest);
    return result;
}

VARIANT Worksheet::ClearArrows()
{
    VARIANT result;
    InvokeHelper(0x3ca, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
    return result;
}

VARIANT Worksheet::Columns(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0xf1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Copy(const VARIANT& Before, const VARIANT& After)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x227, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Before, &After);
    return result;
}

VARIANT Worksheet::Delete()
{
    VARIANT result;
    InvokeHelper(0x75, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
    return result;
}

VARIANT Worksheet::DrawingObjects(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x58, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Drawings(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x304, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::DropDowns(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x344, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::_Evaluate(const VARIANT& Name)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Name);
    return result;
}

VARIANT Worksheet::Evaluate(const VARIANT& Name)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0xfffffffb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Name);
    return result;
}

VARIANT Worksheet::GroupBoxes(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x342, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::GroupObjects(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x459, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Labels(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x349, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Lines(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x2ff, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::ListBoxes(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x340, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Move(const VARIANT& Before, const VARIANT& After)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x27d, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Before, &After);
    return result;
}

VARIANT Worksheet::OLEObjects(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x31f, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::OptionButtons(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0x33a, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Ovals(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0x321, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Paste(const VARIANT& Destination, const VARIANT& Link)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0xd3, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Destination, &Link);
    return result;
}

VARIANT Worksheet::PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x403, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Format, &Link, &DisplayAsIcon, &IconFileName, &IconIndex, &IconLabel);
    return result;
}

VARIANT Worksheet::Pictures(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0x303, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::PivotTables(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0x2b2, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT 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)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x2ac, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &SourceType, &SourceData, &TableDestination, &TableName, &RowGrand, &ColumnGrand, &SaveData, &HasAutoFormat, &AutoPage);
    return result;
}

VARIANT Worksheet::PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x389, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &From, &To, &Copies, &Preview);
    return result;
}

VARIANT Worksheet::PrintPreview()
{
    VARIANT result;
    InvokeHelper(0x119, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
    return result;
}

VARIANT Worksheet::Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x11a, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Password, &DrawingObjects, &Contents, &Scenarios);
    return result;
}

// return changed to LPDISPATCH r.t.
LPDISPATCH Worksheet::Range(const VARIANT& Cell1, const VARIANT& Cell2)
{
    TRACE("Entering Worksheet::Range(Cell1, Cell2)\n");
    LPDISPATCH result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0xc5, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
        &Cell1, &Cell2);
    return result;
}
// new one for one argument
LPDISPATCH Worksheet::Range(const VARIANT& Cell1)
{
    TRACE("Entering Worksheet::Range(Cell1)\n");
    LPDISPATCH result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0xc5, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
        &Cell1);
    return result;
}

VARIANT Worksheet::Rectangles(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x306, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Rows(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] = VTS_VARIANT;
    InvokeHelper(0x102, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::SaveAs(const VARIANT& Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
    InvokeHelper(0x11c, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup);
    return result;
}

VARIANT Worksheet::Scenarios(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x38c, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::ScrollBars(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x33e, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Select(const VARIANT& Replace)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0xeb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Replace);
    return result;
}

//************************************
void Worksheet::Select()
{
    TRACE("Entering Worksheet::Select\n");
    InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
//************************************

VARIANT Worksheet::ShowAllData()
{
    VARIANT result;
    InvokeHelper(0x31a, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
    return result;
}

VARIANT Worksheet::ShowDataForm()
{
    VARIANT result;
    InvokeHelper(0x199, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
    return result;
}

VARIANT Worksheet::Spinners(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x346, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::TextBoxes(const VARIANT& Index)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x309, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Index);
    return result;
}

VARIANT Worksheet::Unprotect(const VARIANT& Password)
{
    VARIANT result;
    static BYTE BASED_CODE parms[] =
        VTS_VARIANT;
    InvokeHelper(0x11d, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
        &Password);
    return result;
}
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -