Скрипт редактирования Excel и гиперссылки

Get-ChildItem -path 'C:\Users\dni38816\Desktop\test\testsprnew\*.png' -Recurse |  Select-Object -Property @{Label="Folder name"; Expression=({$_.FullName.Substring(0,$_.FullName.LastIndexOf('\')).Substring($_.FullName.Substring(0,$_.FullName.LastIndexOf('\')).LastIndexOf('\')+1)})}, @{Label="PNG Name"; Expression=({$_.Name})}, @{Label="Current Date Created";Expression=({$_.LastWriteTime})} | Export-csv C:\Users\dni38816\Desktop\test\testnew.csv
Get-ChildItem -path 'C:\Users\dni38816\Desktop\test\TESTSPRNEW\*.png' -Recurse |  Select-Object -Property @{Label="Folder name"; Expression=({$_.FullName.Substring(0,$_.FullName.LastIndexOf('\')).Substring($_.FullName.Substring(0,$_.FullName.LastIndexOf('\')).LastIndexOf('\')+1)})}, @{Label="PNG"; Expression=({$_.Name})}, @{Label="Previous Date Created";Expression=({$_.LastWriteTime})} | Export-csv C:\Users\dni38816\Desktop\test\testold.csv
$import = get-content C:\Users\dni38816\Desktop\test\testnew.csv
$import | Select-Object -Skip 1 | Set-Content C:\Users\dni38816\Desktop\test\testnew.csv
$import2 = get-content C:\Users\dni38816\Desktop\test\testold.csv
$import2 | Select-Object -Skip 1 | Set-Content C:\Users\dni38816\Desktop\test\testold.csv
 
$SourcePath1 = "C:\Users\dni38816\Desktop\test\testnew.csv"
$SourcePath2 = "C:\Users\dni38816\Desktop\test\testold.csv"
$DestinationPath = "C:\Users\dni38816\Desktop\TEST\1.xlsx"
$deleimter= ","
$SourceTxt = Get-Content $SourcePath1
$xlsxFile = $DestinationPath + "1.xlsx"
if (Test-Path ($xlsxFile))
{
  Remove-Item $xlsxFile
}
$xl=New-Object -ComObject "Excel.Application"
$wb=$xl.Workbooks.Add()
$ws=$wb.ActiveSheet
$xl.Visible=$false
$cells=$ws.Cells
$Content = Get-Content $SourcePath1
$Content2 = Get-Content $SourcePath2
$numOfRows = $Content.Length
$numOfRows2 = $Content2.Length
$numOfColumns = $Content[3].split($deleimter).Count
$numOfColumns2 = $Content2[3].split($deleimter).Count
for ($i=0; $i -lt $numOfRows ;$i++)
{
  $rowData = $Content[$i].split($deleimter)
  for ($j=0; $j -lt $numOfColumns; $j++)
  {
    $cellData = $rowData[$j]
    $cells.item($i+1,$j+1) = $cellData
  }
}
for ($i=0; $i -lt $numOfRows2 ;$i++)
{
  $rowData2 = $Content2[$i].split($deleimter)
  for ($j=0; $j -lt $numOfColumns2; $j++)
  {
    $cellData = $rowData2[$j]
    $cells.item($i+1,$j+4) = $cellData
  }
}
 
$xl.Cells.EntireColumn.AutoFit()
$xl.Cells.EntireColumn.AutoFilter()
$xl.Rows.Item(4).Font.Bold = $false
$xl.Range("A1:F1").font.size = 14
$xl.Rows.Item(4).Interior.ColorIndex = 2
$xl.Range("A1:F50").Borders.LineStyle = 1
$xl.Range("A1:F1").font.size = 14
$xl.Range("A1:F1").font.bold = $true
$xl.Range("A1:F4").HorizontalAlignment = -4108
$xl.Range("A1:F4").VerticalAlignment = -4108
$wb.SaveAs($xlsxFile) 
$wb.Close()
xl.Quit()

using namespace System.Collections.Generic
using namespace System.IO
using namespace System.Linq
 
param (
    $Dir1 = "c:\tmp\dir1",
    $dir2 = "c:\tmp\dir2"
)
 
 
class MyMegaClass{
    [string]$Filepath
    [string]$Hash
}
 
$List1 =[List[MyMegaClass]]::new()
$List2 =[List[MyMegaClass]]::new()
 
foreach ($file in [Directory]::GetFiles($Dir1, '*.*', [SearchOption]::AllDirectories)) {
    $List1.Add(
        [MyMegaClass]@{
            Filepath = $file
            Hash = (Get-FileHash $file -Algorithm SHA256).Hash
        }
    )
}
 
foreach ($file in [Directory]::GetFiles($Dir2, '*.*', [SearchOption]::AllDirectories)) {
    $List2.Add(
        [MyMegaClass]@{
            Filepath = $file
            Hash = (Get-FileHash $File -Algorithm SHA256).Hash
        }
    )
}
 
$dupHash = [Enumerable]::Intersect([string[]]$List1.Hash, [string[]]$List2.Hash)
# Тут ты получил список хешей файлов с дублями
 
$List1.Where{$_.Hash -in $dupHash}
# Тут ты получил список объектов с такими хешами из первого списка
# И вопрос: "Что же с ними делать?"

Get-ChildItem -Recurse -File| Get-FileHash

$Dir1Files = Get-ChildItem -Recurse -File "C:\tmp\Dir1"
$Dir2Files = Get-ChildItem -Recurse -File "C:\tmp\Dir2"
 
. {
    foreach ($origFile in $Dir1Files) {
        foreach ($copyFile in $Dir1Files) {
            if ($origFile.Name -EQ $copyFile.Name) {
                [pscustomobject]@{
                    OrigFile = $origFile.FullName
                    CopyFile = $CopyFile.FullName
                }
            }
        }
    }
} | Export-Csv out.csv