Share via

Powershell script to update excel sheets and refresh the pivots

mishan1134 1 Reputation point
2021-02-05T12:05:52.713+00:00

Hi,

The use case that I have is as follows -
I have a master excel file with data in 3 sheets. And for each sheet I have created a pivot.
I get updated data for these 3 sheets everyday. So I have to manually delete that data in each sheet and then add the new data.
Also, there is a date formula that is applied to one of the sheets.
And then I need to refresh all the 3 pivots.

Need help with a powershell script which can help me automate this manual process.

Thanks in advance !!

Windows for business Windows Server User experience PowerShell

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. vTech 6 Reputation points
    2021-02-07T22:24:11.907+00:00

    I'd rather see it done in Excel VBA Macro, but some searching turns up PSExcel

    http://ramblingcookiemonster.github.io/PSExcel-Intro/

    0 comments
  2. Anonymous
    2021-02-08T07:31:05.81+00:00

    Hi,

    You can give the ImportExcel module a try
    https://www.powershellgallery.com/packages/ImportExcel/

    Best Regards，
    Ian Xue

    ============================================

    If the Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.