Solved

Powershell with Excel Pivot Table

Posted on 2013-06-12
2
1,172 Views
Last Modified: 2013-06-13
Ok. Attaching what I have already. I would like powershell take the table in attachment 1, which is its own worksheet named "AllServers" , create a new sheet name with a pivot table from attachment 2. Is this even possible?

Attachment 1
Attachment1
Attachment 2
Attachment 2
0
Comment
Question by:Xytras1
2 Comments
 
LVL 79

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 39243631
powershell knows nothing about pivot tables and an excel vba solution would be a much better fit.
0
 

Author Closing Comment

by:Xytras1
ID: 39244586
Thanks for the Info.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr‚Ķ

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question