Copy few cells from PivotTable in new worksheet

[smooking89]

How do I copy a few cells from the pivot table in a new worksheet?
I introduce such a code but does not generate anything in Sheet2.
Please help me!

Code: Select all

sheet2.Copy(sheet_pivot.Range[2, 1, lastRow + 1, lastCol], sheet2.Range[1, 1, lastRow + 1, lastCol])

[amy.zhao]

Hello,

Thanks for your inquiry.
Please try the below solution.

Code: Select all

 
            CellRange range_pivot = sheet_pivot.Range[2, 1, lastRow + 1, lastCol];
            range_pivot.Copy(sheet2.Range[1, 1, lastRow + 1, lastCol]);

Have a nice day.

Best wishes,
Amy
E-iceblue support team

[smooking89]

Hello!

Thanks for Your answer, but does not display anything in Sheet2.
I tried to read by cells but nothing.

Code: Select all

CellRange range_pivot = compare.Range["A2:S13"];
range_pivot.Copy(fincomp.Range["A1:S12"]);

This is my example:

I wish you a good day!

[amy.zhao]

Hello,

Thanks for your quick response.
Would you please provide us with your excel file? It will help us to reproduce quickly and solve your issue.
You could also send your file to support@e-iceblue.com.
We promise to keep your document confidential and we will not use it for any other purpose. Besides, you could also remove the security data of your document and then send it to us.

Thanks.

Best wishes,
Amy
E-iceblue support team

[smooking89]

Hello!

The file has been sent by mail.

Thank you.

[amy.zhao]

Hello,

I have received your excel file in e-mail. Thank you.
I have reproduced the issue. Sorry for the inconvenience. I have posted it to our dev team. We will inform you when the issue is resolved.

Best wishes,
Amy
E-iceblue support team

[smooking89]

Hello!

I want to know if it solved my issue.
Thank you.

[amy.zhao]

Hello,

Thanks for your inquiry.
Sorry that the issue has not been fixed now. Our dev team is doing the research to find the cause which casued the issue.
We maybe need some time to solve it. We will inform you immediately as soon as it is solved.
Thanks for your understanding.

Best wishes,
Amy
E-iceblue support team

[smooking89]

Hello!

I'm sorry for the inconvenience. At what stage are the answer to my previous question.
Thank you.

[Gary.zhang]

Hello,

Sorry that our Dev team is still fixing. Once it is resolved, we will inform you immediately. So sorry for inconvenience.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team

[smooking89]

Hi,

Sorry, I want to ask that is because I have not received any response so far from you regarding my question exposed above.

Thanks

[Gary.zhang]

Hi,

Sorry for keeping you waiting.
Please download the Spire.Xls7.3.2(http://www.e-iceblue.com/Download/downl ... t-now.html) and try it again.
If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Have you tried the Spire.Xls7.3.2? Has the issue been resolved? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team