sample9excel8.c

用CVI实现的EXCEL自动化服务器演示i

                                               ERRORINFO *errorInfo,
                                               VBOOL *returnValue)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x490, CAVT_BOOL,
                              returnValue, 0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookForwardMailer (CAObjHandle objectHandle,
                                             ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3CD, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookLinkInfo (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo, char *name,
                                        enum ExcelEnum_XlLinkInfo linkInfo,
                                        VARIANT type, VARIANT editionRef,
                                        VARIANT *returnValue)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING, CAVT_LONG, CAVT_VARIANT,
                                 CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x327, CAVT_VARIANT,
                              returnValue, 4, paramTypes, name, linkInfo, type,
                              editionRef);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookLinkSources (CAObjHandle objectHandle,
                                           ERRORINFO *errorInfo, VARIANT type,
                                           VARIANT *returnValue)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x328, CAVT_VARIANT,
                              returnValue, 1, paramTypes, type);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookMergeWorkbook (CAObjHandle objectHandle,
                                             ERRORINFO *errorInfo,
                                             VARIANT filename)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5A6, CAVT_EMPTY, NULL,
                              1, paramTypes, filename);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookNewWindow (CAObjHandle objectHandle,
                                         ERRORINFO *errorInfo,
                                         ExcelObj_Window *returnValue)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x118, CAVT_OBJHANDLE,
                              returnValue, 0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookOpenLinks (CAObjHandle objectHandle,
                                         ERRORINFO *errorInfo, char *name,
                                         VARIANT readOnly, VARIANT type)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x323, CAVT_EMPTY, NULL,
                              3, paramTypes, name, readOnly, type);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPivotCaches (CAObjHandle objectHandle,
                                           ERRORINFO *errorInfo,
                                           ExcelObj_PivotCaches *returnValue)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5A9, CAVT_OBJHANDLE,
                              returnValue, 0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPost (CAObjHandle objectHandle,
                                    ERRORINFO *errorInfo, VARIANT destName)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x48E, CAVT_EMPTY, NULL,
                              1, paramTypes, destName);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPrintOut (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo, VARIANT from,
                                        VARIANT to, VARIANT copies,
                                        VARIANT preview, VARIANT activePrinter,
                                        VARIANT printToFile, VARIANT collate)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x389, CAVT_EMPTY, NULL,
                              7, paramTypes, from, to, copies, preview,
                              activePrinter, printToFile, collate);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPrintPreview (CAObjHandle objectHandle,
                                            ERRORINFO *errorInfo,
                                            VARIANT enableChanges)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x119, CAVT_EMPTY, NULL,
                              1, paramTypes, enableChanges);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookProtect (CAObjHandle objectHandle,
                                       ERRORINFO *errorInfo, VARIANT password,
                                       VARIANT structure, VARIANT windows)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x11A, CAVT_EMPTY, NULL,
                              3, paramTypes, password, structure, windows);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookProtectSharing (CAObjHandle objectHandle,
                                              ERRORINFO *errorInfo,
                                              VARIANT filename, VARIANT password,
                                              VARIANT writeResPassword,
                                              VARIANT readOnlyRecommended,
                                              VARIANT createBackup,
                                              VARIANT sharingPassword)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5AA, CAVT_EMPTY, NULL,
                              6, paramTypes, filename, password,
                              writeResPassword, readOnlyRecommended,
                              createBackup, sharingPassword);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookRefreshAll (CAObjHandle objectHandle,
                                          ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5AC, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookReply (CAObjHandle objectHandle,
                                     ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3D1, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookReplyAll (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3D2, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookRemoveUser (CAObjHandle objectHandle,
                                          ERRORINFO *errorInfo, long index)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5AD, CAVT_EMPTY, NULL,
                              1, paramTypes, index);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookRoute (CAObjHandle objectHandle,
                                     ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3B2, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookRunAutoMacros (CAObjHandle objectHandle,
                                             ERRORINFO *errorInfo,
                                             enum ExcelEnum_XlRunAutoMacro which)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x27A, CAVT_EMPTY, NULL,
                              1, paramTypes, which);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSave (CAObjHandle objectHandle,
                                    ERRORINFO *errorInfo)
{
    HRESULT result;

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x11B, CAVT_EMPTY, NULL,
                              0, NULL);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSaveAs (CAObjHandle objectHandle,
                                      ERRORINFO *errorInfo, VARIANT filename,
                                      VARIANT fileFormat, VARIANT password,
                                      VARIANT writeResPassword,
                                      VARIANT readOnlyRecommended,
                                      VARIANT createBackup,
                                      enum ExcelEnum_XlSaveAsAccessMode accessMode,
                                      VARIANT conflictResolution,
                                      VARIANT addToMru, VARIANT textCodepage,
                                      VARIANT textVisualLayout)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_LONG, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x11C, CAVT_EMPTY, NULL,
                              11, paramTypes, filename, fileFormat, password,
                              writeResPassword, readOnlyRecommended,
                              createBackup, accessMode, conflictResolution,
                              addToMru, textCodepage, textVisualLayout);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSaveCopyAs (CAObjHandle objectHandle,
                                          ERRORINFO *errorInfo, VARIANT filename)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0xAF, CAVT_EMPTY, NULL,
                              1, paramTypes, filename);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSendMail (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo, VARIANT recipients,
                                        VARIANT subject, VARIANT returnReceipt)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3B3, CAVT_EMPTY, NULL,
                              3, paramTypes, recipients, subject,
                              returnReceipt);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSendMailer (CAObjHandle objectHandle,
                                          ERRORINFO *errorInfo,
                                          VARIANT fileFormat,
                                          enum ExcelEnum_XlPriority priority)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_LONG};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x3D4, CAVT_EMPTY, NULL,
                              2, paramTypes, fileFormat, priority);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookSetLinkOnData (CAObjHandle objectHandle,
                                             ERRORINFO *errorInfo, char *name,
                                             VARIANT procedure)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x329, CAVT_EMPTY, NULL,
                              2, paramTypes, name, procedure);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookUnprotect (CAObjHandle objectHandle,
                                         ERRORINFO *errorInfo, VARIANT password)