Copy rows in pivot Table

[nnmmss]

After I have created the Pivot Table in Excel , I want to copy a few records of the pivot Table to others row to do some changes on them. I have don't this like:

Code: Select all

sheet2.Copy(sheet2.Range["A34:G34"], sheet2.Range["A39:G39"], true);


as you can see I want to copy Row No: 34 to Row No:39. But nothing happens? how is that possible?

Thank you

[Betsy.jiang]

Dear nnmmss,

Thanks for your inquiry.
Please add following code before copying.

Code: Select all

PivotTable.CalculateData();

If your issue still happens, please share us your input document and the full code you were using.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear nnmmss,

Greetings from E-iceblue.
Has your issue been solved ? Could you please give us some feedback at your convenience ?

Sincerely,
Betsy
E-iceblue support team