PowerShell: How to read CSV files

Let’s say if we got a spreadsheet like the following

Column 1 Column 2 Column n

$filePath = “c:\path\file.csv”

$csv = Import-Csv $filePath

#we can loop through each row by using the foreach statment

foreach($row in $csv) {

#To access the column value, we could use the following

$row.”Column 1″

}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s