?
Solved

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

Posted on 2016-11-28
2
Medium Priority
?
113 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

762 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