Browsed by
Month: April 2016

Export to Excel

Export to Excel

If you handle any sort of data in your job you’ve likely run into the common PowerShell cmdlets for dealing with data; Import-CSV, Export-CSV, Import-CliXML, and Export-Clixml. Sometimes, automation requires the processing of data. CSV and XML are both great ways to store and send data. The only thing is, no human chooses to manipulate data in CSV or XML. That is, for better or for worse, in the realm of Excel. Opening in Excel Excel has the ability to…

Read More Read More

Installing Modules

Installing Modules

Whether you’re writing scripts, functions to automate a repetitive task, or building a whole toolkit you should be familiar with installing modules. Modules let you group functions in a logical way. Creating a bunch of functions that automate part of your Active Directory environment? Group them all into a module. Modules help by letting you keep track of the version you have installed on your machine as well as allowing for automatic loading into the current session. Module Contents What…

Read More Read More