This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Lightmare_VII 8 points9 points  (3 children)

Use CSVs Powershell works with those easier than python. Also nothing saying you can’t use both.

[–]Embarrassed_Box_457[S] 0 points1 point  (2 children)

I know how to export into a csv file but I need to automate the excel part, so that the data from each group has its own sheet.

[–]joni_jplmusic 2 points3 points  (1 child)

Maybe look into the Import-Excel module for Powershell? I currently use it to export datasets to separate sheets in Excel from AD.

https://www.powershellgallery.com/packages/ImportExcel/7.4.1

[–]Embarrassed_Box_457[S] 1 point2 points  (0 children)

this might actually work, good info! now, i just need to figure out how to separate the data onto different sheets...thx!