Copy few cells from PivotTable in new worksheet

Wed Jan 22, 2014 12:14 pm

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])

Thu Jan 23, 2014 7:34 am

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

Thu Jan 23, 2014 7:57 am

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!

Thu Jan 23, 2014 8:09 am

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

Thu Jan 23, 2014 9:25 am

Hello!

The file has been sent by mail.

Thank you.

Thu Jan 23, 2014 9:29 am

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

Mon Jan 27, 2014 7:31 am

Hello!

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

Mon Jan 27, 2014 7:43 am

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

Wed Feb 05, 2014 2:54 pm

Hello!

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

Thu Feb 06, 2014 2:42 am

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

Tue Mar 04, 2014 9:42 am

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

Wed Mar 05, 2014 1:50 am

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

Mon Mar 10, 2014 9:23 am

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