sample9excel8.c

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

                              1, paramTypes, replace);

    return result;
}

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

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x2F8, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

HRESULT CVIFUNC Excel_WorksheetSetBackgroundPicture (CAObjHandle objectHandle,
                                                     ERRORINFO *errorInfo,
                                                     char *filename)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_CSTRING};

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x22D, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x424, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x338, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

HRESULT CVIFUNC Excel_WorksheetCheckSpelling (CAObjHandle objectHandle,
                                              ERRORINFO *errorInfo,
                                              VARIANT customDictionary,
                                              VARIANT ignoreUppercase,
                                              VARIANT alwaysSuggest,
                                              VARIANT ignoreInitialAlefHamza,
                                              VARIANT ignoreFinalYaa,
                                              VARIANT spellScript)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x1F9, CAVT_EMPTY, NULL,
                              6, paramTypes, customDictionary, ignoreUppercase,
                              alwaysSuggest, ignoreInitialAlefHamza,
                              ignoreFinalYaa, spellScript);

    return result;
}

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

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x304, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x58, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x344, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

HRESULT CVIFUNC Excel_WorksheetEvaluate (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_Worksheet_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_WorksheetResetAllPageBreaks (CAObjHandle objectHandle,
                                                   ERRORINFO *errorInfo)
{
    HRESULT result;

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

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x342, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x459, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x349, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x2FF, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x340, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x31F, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x33A, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x321, CAVT_OBJHANDLE,
                              returnValue, 1, paramTypes, index);

    return result;
}

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

    result = CA_MethodInvoke (objectHandle, errorInfo, 0xD3, CAVT_EMPTY, NULL,
                              2, paramTypes, destination, link);

    return result;
}

HRESULT CVIFUNC Excel_WorksheetPasteSpecial (CAObjHandle objectHandle,
                                             ERRORINFO *errorInfo,
                                             VARIANT format, VARIANT link,
                                             VARIANT displayAsIcon,
                                             VARIANT iconFileName,
                                             VARIANT iconIndex,
                                             VARIANT iconLabel)
{
    HRESULT result;
    unsigned int paramTypes[] = {CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT,
                                 CAVT_VARIANT, CAVT_VARIANT, CAVT_VARIANT};

    result = CA_MethodInvoke (objectHandle, errorInfo, 0x403, CAVT_EMPTY, NULL,
                              6, paramTypes, format, link, displayAsIcon,
                              iconFileName, iconIn