?
Solved

Powershell with Excel Pivot Table

Posted on 2013-06-12
2
Medium Priority
?
1,426 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 85

Accepted Solution

by:
David Johnson, CD, MVP earned 2000 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

Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A walk-through example of how to obtain and apply new DID phone numbers to your cloud PBX enabled users that are configured in Office 365. Whether you have 1, 10 or 100+ users in your tenant, it's quite easy to get them phone-enabled and making/rece…
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

589 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