copy/move excel sheet with QT

[amleto]

It looks like you don't know how Copy works.

here is the help
http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx


Looks like this is no longer Qt programming question...

[gerardpuducul]

Hi,

Thanks a lot yours link. It help me to find the solution. I need to pass the object worksheet for before or after parameter;

so instead of

sheet->dynamicCall("Copy");

sheet->dynamicCall("Copy");

To copy to clipboard, switch view to plain text mode 

I do

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
 QVariant param1 = worksheet_copy_after->asVariant();
 worksheet_to_copy->dynamicCall("Copy (const QVariant&)",param1);

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
 QVariant param1 = worksheet_copy_after->asVariant();
 worksheet_to_copy->dynamicCall("Copy (const QVariant&)",param1);

To copy to clipboard, switch view to plain text mode 

and the copy occurs in the same worksheets!!!

Thanks

[gerardpuducul]

In fact I success to copy before but not After

according to : http://msdn.microsoft.com/en-US/libr...(v=vs.80).aspx

I try to pass en empty Qvaraint to the first parameter but nothing happen.

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1 = "missing";
QVariant param2 = worksheet_copy_after->asVariant();
 worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1 = "missing";
QVariant param2 = worksheet_copy_after->asVariant();
 worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

To copy to clipboard, switch view to plain text mode 

How can I do?

Thanks

[amleto]

use a null QVariant, not a QVariant with a string="missing"

[gerardpuducul]

I had already try with NULL variant (and a lot of stupid test that i prefer to not post here)

but nothing is working

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1 = NULL;
QVariant param2 = worksheet_copy_after->asVariant();
worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1 = NULL;
QVariant param2 = worksheet_copy_after->asVariant();
worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

To copy to clipboard, switch view to plain text mode 

any suggestion?

thanks

[amleto]

QVariant param1 = NULL;

does that even compile? I don't believe it is a null variant though - if it compiles it will be a QVariant of type string with string = "", or a QVariant of type int with value = 0, or something like that.

This is how you make a null variant:

QVariant param;

[gerardpuducul]

Of course it compiles. I will not post something which not compile.

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1;
QVariant param2 = worksheet_copy_after->asVariant();
worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

worksheet_copy_after = sheets->querySubObject("Item( int )", 5 );
QVariant param1;
QVariant param2 = worksheet_copy_after->asVariant();
worksheet_to_copy->dynamicCall("Copy (const QVariant&, const QVariant&)",param1,param2);

To copy to clipboard, switch view to plain text mode 

Doesn't work anymore!

[amleto]

only this idea, I don't know if it will work at all:

QString after = worksheet_copy_after->asVariant().toString(); // don't know if this works!
QString call("Copy(missing,%1)");
call = call.arg(after);
 
activeX->dynamicCall(call.toLatin1().constData());

QString after = worksheet_copy_after->asVariant().toString(); // don't know if this works!
QString call("Copy(missing,%1)");
call = call.arg(after);

activeX->dynamicCall(call.toLatin1().constData());

To copy to clipboard, switch view to plain text mode 

I thought of that after reading http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx and http://qt-project.org/doc/qt-4.8/qax...ml#dynamicCall. The problem is how to deal with 'missing' correctly. If you can think of some way to access System.Type.Missing then that will probably help.

[gerardpuducul]

QString after = worksheet_copy_after->asVariant().toString(); // don't know if this works!
QString call("Copy(missing,%1)");
call = call.arg(after);

QString after = worksheet_copy_after->asVariant().toString(); // don't know if this works!
QString call("Copy(missing,%1)");
call = call.arg(after);

To copy to clipboard, switch view to plain text mode 

seems working !

activeX->dynamicCall(call.toLatin1().constData());

activeX->dynamicCall(call.toLatin1().constData());

To copy to clipboard, switch view to plain text mode 

but what is your activeX?

[amleto]

worksheet_to_copy

[wysota]

QVariant param1 = NULL;

does that even compile? I don't believe it is a null variant though - if it compiles it will be a QVariant of type string with string = "", or a QVariant of type int with value = 0, or something like that.

This is how you make a null variant:

QVariant param;

NULL is:

#define NULL 0L

#define NULL 0L

To copy to clipboard, switch view to plain text mode 

therefore this:

QVariant param1 = NULL;

QVariant param1 = NULL;

To copy to clipboard, switch view to plain text mode 

stores an integer of value "0" in the variant.