sample9excel8.c

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

{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x11D, CAVT_EMPTY, NULL,
                              1, paramTypes, password);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5AF, CAVT_EMPTY, NULL,
                              1, paramTypes, sharingPassword);

    return result;
}

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

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x324, CAVT_EMPTY, NULL,
                              2, paramTypes, name, type);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookHighlightChangesOptions (CAObjHandle objectHandle,
                                                       ERRORINFO *errorInfo,
                                                       VARIANT when, VARIANT who,
                                                       VARIANT where)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5B2, CAVT_EMPTY, NULL,
                              3, paramTypes, when, who, where);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPurgeChangeHistoryNow (CAObjHandle objectHandle,
                                                     ERRORINFO *errorInfo,
                                                     long days,
                                                     VARIANT sharingPassword)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5B8, CAVT_EMPTY, NULL,
                              2, paramTypes, days, sharingPassword);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookAcceptAllChanges (CAObjHandle objectHandle,
                                                ERRORINFO *errorInfo,
                                                VARIANT when, VARIANT who,
                                                VARIANT where)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5BA, CAVT_EMPTY, NULL,
                              3, paramTypes, when, who, where);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookRejectAllChanges (CAObjHandle objectHandle,
                                                ERRORINFO *errorInfo,
                                                VARIANT when, VARIANT who,
                                                VARIANT where)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5BB, CAVT_EMPTY, NULL,
                              3, paramTypes, when, who, where);

    return result;
}

HRESULT CVIFUNC Excel_WorkbookPivotTableWizard (CAObjHandle objectHandle,
                                                ERRORINFO *errorInfo,
                                                VARIANT sourceType,
                                                VARIANT sourceData,
                                                VARIANT tableDestination,
                                                VARIANT tableName,
                                                VARIANT rowGrand,
                                                VARIANT columnGrand,
                                                VARIANT saveData,
                                                VARIANT hasAutoFormat,
                                                VARIANT autoPage,
                                                VARIANT reserved,
                                                VARIANT backgroundQuery,
                                                VARIANT optimizeCache,
                                                VARIANT pageFieldOrder,
                                                VARIANT pageFieldWrapCount,
                                                VARIANT readData,
                                                VARIANT connection)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x2AC, CAVT_EMPTY, NULL,
                              16, paramTypes, sourceType, sourceData,
                              tableDestination, tableName, rowGrand,
                              columnGrand, saveData, hasAutoFormat, autoPage,
                              reserved, backgroundQuery, optimizeCache,
                              pageFieldOrder, pageFieldWrapCount, readData,
                              connection);

    return result;
}

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

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

    return result;
}

HRESULT CVIFUNC Excel_WorkbookFollowHyperlink (CAObjHandle objectHandle,
                                               ERRORINFO *errorInfo,
                                               char *address, VARIANT subAddress,
                                               VARIANT newWindow,
                                               VARIANT addHistory,
                                               VARIANT extraInfo, VARIANT method,
                                               VARIANT headerInfo)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x5BE, CAVT_EMPTY, NULL,
                              7, paramTypes, address, subAddress, newWindow,
                              addHistory, extraInfo, method, headerInfo);

    return result;
}

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

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

    return result;
}

HRESULT CVIFUNC Excel_NewGlobal (char *server, CAObjHandle *objectHandle)
{
    HRESULT result;
    GUID clsid = {0x20812, 0x0, 0x0, 0xC0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x46};

    result = CA_CreateObjectByClassId (&clsid, server, objectHandle);

    return result;
}

HRESULT CVIFUNC Excel_OpenGlobal (char *fileName, char *server,
                                  CAObjHandle *objectHandle)
{
    HRESULT result;
    GUID clsid = {0x20812, 0x0, 0x0, 0xC0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x46};

    result = CA_LoadObjectFromFileByClassId (fileName, &clsid, server,
                                             objectHandle);

    return result;
}

HRESULT CVIFUNC Excel_ActiveGlobal (char *server, CAObjHandle *objectHandle)
{
    HRESULT result;
    GUID clsid = {0x20812, 0x0, 0x0, 0xC0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x46};

    result = CA_GetActiveObjectByClassId (&clsid, server, objectHandle);

    return result;
}

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

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

    return result;
}

HRESULT CVIFUNC Excel_GlobalDDEExecute (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo, long channel,
                                        char *string)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG, CAVT_CSTRING};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x14D, CAVT_EMPTY, NULL,
                              2, paramTypes, channel, string);

    return result;
}

HRESULT CVIFUNC Excel_GlobalDDEInitiate (CAObjHandle objectHandle,
                                         ERRORINFO *errorInfo, char *app,
                                         char *topic, long *returnValue)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING, CAVT_CSTRING};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x14E, CAVT_LONG,
                              returnValue, 2, paramTypes, app, topic);

    return result;
}

HRESULT CVIFUNC Excel_GlobalDDEPoke (CAObjHandle objectHandle,
                                     ERRORINFO *errorInfo, long channel,
                                     VARIANT item, VARIANT data)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x14F, CAVT_EMPTY, NULL,
                              3, paramTypes, channel, item, data);

    return result;
}

HRESULT CVIFUNC Excel_GlobalDDERequest (CAObjHandle objectHandle,
                                        ERRORINFO *errorInfo, long channel,
                                        char *item, VARIANT *returnValue)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_LONG, CAVT_CSTRING};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x150, CAVT_VARIANT,
                              returnValue, 2, paramTypes, channel, item);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x151, CAVT_EMPTY, NULL,
                              1, paramTypes, channel);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x1, CAVT_VARIANT,
                              returnValue, 1, paramTypes, name);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0xFFFFFFFB,
                              CAVT_VARIANT, returnValue, 1, paramTypes, name);

    return result;
}

HRESULT CVIFUNC Excel_GlobalExecuteExcel4Macro (CAObjHandle objectHandle,
                                                ERRORINFO *errorInfo,
                                                char *string,
                                                VARIANT *returnValue)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x15E, CAVT_VARIANT,
                              returnValue, 1, paramTypes, string);

    return result;
}

HRESULT CVIFUNC Excel_GlobalIntersect (CAObjHandle objectHandle,
                                       ERRORINFO *errorInfo, ExcelObj_Range arg1,
                                       ExcelObj_Range arg2, VARIANT arg3,
                                       VARIANT arg4, VARIANT arg5, VARIANT arg6,
                                       VARIANT arg7, VARIANT arg8, VARIANT arg9,
                                       VARIANT arg10, VARIANT arg11,
                                       VARIANT arg12, VARIANT arg13,
                                       VARIANT arg14, VARIANT arg15,
                                       VARIANT arg16, VARIANT arg17,