Solved

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

Posted on 2016-11-28
2
60 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 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Windows 10 came with  a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

733 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