Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

powershell script example of appending data to a csv file (new tab)

Posted on 2016-11-28
2
Medium Priority
?
161 Views
Last Modified: 2016-11-29
I am not finding any results for this so maybe it can't be done. I want to script pulling some data from servers, 2 different lines that will give different results, and put each set of data into 2 tabs in Excel, naming them appropriately with the server name, and another piece of data that I will add. If I can't do it on the fly, maybe combining 2 separate csv files into one, with 2 tabs.
The end result is one csv file, with 2 tabs for each server, containing the data I pull with the script.

I hope that makes sense.
Thanks!
0
Comment
Question by:SquigglyMonkey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
Ed Dredd earned 2000 total points
ID: 41905069
you have to use custom made function as shown in this website http://stackoverflow.com/questions/31183106/can-powershell-generate-a-plain-excel-file-with-multiple-sheets . credit to the site and avshalom

note: i dont know if Expert exchange has any rule for referring other websites.
0
 
LVL 1

Author Closing Comment

by:SquigglyMonkey
ID: 41905976
That works great. I would have preferred something native, but this works great and I can incorporate it into the script.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

636 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