C ++中的COM自动化 [英] COM Automation in C++

问题描述

大家好，

我正在用C ++执行com自动化程序，我需要将公式的前一行粘贴到excel(.xls)文件中的当前行.以下是相同的VBA代码.

Hi Everyone,

I am doing com automation program in c++, i need to paste formula form previous row to current row in excel(.xls) file. following is the VBA code for same.

Range("C71").Select
    Selection.Copy
    Range("C72").Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False

我需要在c ++中实现以上代码.

I need implementation of above code in c++. can you please help me.

推荐答案

您应该看看:
Excel 2010 SDK:Excel 2010 XLL软件开发工具包 [ XLW-Excel API的包装器 [ ^ ].

最好的问候
Espen Harlinn

You should take a look at:
Excel 2010 SDK: Excel 2010 XLL Software Development Kit[^]

There is also XLW - A Wrapper for the Excel API[^].

Best regards
Espen Harlinn

这篇关于C ++中的COM自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！