The following forum(s) have migrated to Microsoft Q&A: All English Windows Server forums!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

How to pull variables from excel in powershell command

Question
0

Sign in to vote

I want to use below command I want XXXXXXXXXXXXX (object names) should be pulled from excel sheet or txt
Get-QADGroupMember xxxxxx-xxxxx | Select -Property Name,Department | Export-Csv C:\ABc.csv -NoTypeInformation
how to do ????

Saturday, May 23, 2020 4:12 PM

All replies

0

Sign in to vote
Please ask questions about Quest in a Quest forum. You can ask questions about Excel in an Excel forum. This is a Microsoft Server/PowerShell forum for questions about using PowerShell with Microsoft products associated with Windows Server and Active Directory. Quest is not a Microsoft product.

You can also find the Excel PowerShell module here:

https://devblogs.microsoft.com/scripting/introducing-the-powershell-excel-module-2/

CSV files are not Excel files. They are text files.

See:

help Import-Csv -online

\_(ツ)_/
- Edited by jrvModerator Saturday, May 23, 2020 6:00 PM
Saturday, May 23, 2020 5:59 PM

Moderator
0

Sign in to vote

https://adamtheautomator.com/powershell-import-csv-foreach/

Sunday, May 24, 2020 2:02 PM
0

Sign in to vote

ok thank you

Monday, May 25, 2020 7:05 AM