Question

3
Replies
736
Views
ArunK524 Member since 2016 15 posts
Accenture
Posted: 3 years ago
Last activity: 3 years 9 months ago
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
Share this page LinkedIn