Question

3
Replies
767
Views
Arun Kishore K (ArunK524)
Accenture

Accenture
US
ArunK524 Member since 2016 15 posts
Accenture
Posted: December 6, 2016
Last activity: November 6, 2018
Posted: 6 Dec 2016 15:20 EST
Last activity: 6 Nov 2018 20:02 EST
Closed
Solved

Change Pivot table fields and copy data from excel to another

Hi,

Using openspan, how to automate the following scenarios in an Excel spreadsheet.

1. Open an excel attachment from Sharepoint, update a pivot table data source

2. Change the Pivot table fields(Column Headers)

3. Copy couple of rows within a pivot column, and update it in another excel spreadsheet after ungrouping the contents

Thanks,

Arun

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.