Working with EXCEL

Importing Data from Excel

Install-Module -Name ImportExcel -Scope CurrentUser
$excelData = Import-Excel -Path "C:\Path\To\Your\File.xlsx"
$excelData | Format-Table -AutoSize

Importing specific Worksheet Data from Excel

$excelData = Import-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1"
$filteredData = $excelData | Where-Object { $_.ColumnName -eq "SomeValue" }

Write Data to a New Excel File

$data = @(
    [PSCustomObject]@{ Name="Alice"; Age=25; City="Mumbai" }
    [PSCustomObject]@{ Name="Bob"; Age=30; City="Delhi" }
)
$data | Export-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1" -AutoSize

Append Data to an Existing Excel File

$newData = [PSCustomObject]@{ Name="Charlie"; Age=28; City="Kolkata" }

$newData | Export-Excel -Path "C:\Path\To\Your\File.xlsx" -WorksheetName "Sheet1" -Append

Write Data to Specific Columns

$excelParams = @{

    Path = "C:\Path\To\Your\File.xlsx"

    WorksheetName = "Sheet1"

    StartRow = 5

    StartColumn = 2

}

$data | Export-Excel @excelParams

-------------------------------------------------------- End -----------------------------------------------------