How to copy clipboard data to excel worksheet

[rosmie]

Hi,

I am working on a C++ excel automation project . I am finding it hard to get
good c++ documentation for excel automation. Can someone can help me on this?

Also it would be great if someone tells me how to copy clipboard data to
excel range?

I think I need to use ExcelWorksheet.Paste(VARIANT destination, VARIANT
link) method.

But can I get an explanation/code sample for this?

Thanks in advance!

 

[SvenC]

Hi,

I am working on a C++ excel automation project . I am finding it hard to
get good c++ documentation for excel automation. Can someone can help me
on this?

Also it would be great if someone tells me how to copy clipboard data to
excel range?

I think I need to use ExcelWorksheet.Paste(VARIANT destination, VARIANT
link) method.

But can I get an explanation/code sample for this?

You might find it helpful to use the macro recorder to record the steps you
want to automate (pasting some content in your case). Then look at the
recorded VBA code which should not be too difficult to "transform" to C++.