Windows PowerShell™ Scripting Guide

Adding Multiple Users with Multiple Attributes

To create one user is not difficult: You can walk through the wizard in less than a minute. If you begin to specify additional attributes, however, the amount of time involved begins to escalate. If you need to create multiple users with multiple attributes, you are looking at a scenario that can literally consume days, weeks, and even months. One way to manage the creation of multiple users and attributes is to use an Excel spreadsheet.

To read an Excel spreadsheet, you first need to specify the path to the spreadsheet. Next, create an instance of the Excel.Application COM object. This allows you to work with the Excel automation model, which is sometimes easier than the alternative, using Active ...