• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

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

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
SquigglyMonkey
Asked:
SquigglyMonkey
1 Solution
 
Ed DreddCommented:
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
 
SquigglyMonkeyAuthor Commented:
That works great. I would have preferred something native, but this works great and I can incorporate it into the script.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now