How to copy rows in excel with activex
I am trying to do some excel sheet manipulations with qt's activex framework. I already figured out some basics like setting the value of one cell and saving excel files.
My problem is I want to copy a range of cells from one sheet to another or to a different location in the same sheet. I have tried different things like:
this only works for a single cell
QAxObject* range1 = sheet->querySubObject("Range(const QString&, const ]QString&)", QString("A1"), QString("E1")); QAxObject* range2 = sheet->querySubObject("Range(const QString&, const QString&)", QString("A6"), QString("E6"));
and then somehow assign the content of range 1 to range2.
Basically I want to copy for example the content of range1 to range2, preferably including the formating of the cells (border, font and size).
I hope someone can help me.