CSV File:
Firstname,LastName,Address
Scott,Head,123 Street
Sam,Head,246 Street
Suzie,Head,189 Street
Function ExcelWork(){
[CmdletBinding()]
Param(
# \\ Parameters Defined Which Are Colum Headers in Excel CSV File \\
[Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
[string]$FirstName,
[Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
[string]$LastName,
[Parameter(Mandatory=$True,ValueFromPipelineByPropertyName=$true)]
[string]$Address
)
Process {
#\\ Remove White Space from data \\
$FirstName=$_.Firstname.Trim()
$LastName=$_.LastName.Trim()
$Address=$_.Address.Trim()
#---------Do You Magic Here-------
Foreach-Object{
Write-Output "This is : $FirstName"
Write-Output "This is : $LastName"
Write-Output "This is : $Address"
}
#---------------------------------
}
}
#\\ Import CSV and Call Function\\
Import-CSV C:\Temp\Book1.csv | ExcelWork
