I'm not that familiar with pscustomobject and param.Īnyway, what I tried to do was to first declare them in variables with ImportExcel: $Services = Import-Excel -Path 'C:\Users\*.xlsx' I'm novice in Powershell, so I only know basic stuff. I'm not that familiar with Excel, so I thought, this should be possible to do in Powershell. Then if they match, write "the whole row" from $Services So my mission is to compare column: "Number" from $Services with column "Number" from each other Excel file. The important thing is that in $Services, it contains more important columns like "Mobile data", One file containing 50 rows with header columns: "Number", "Name", etc. Now, I want to compare that file with other Excel-files. I have an Excel-file which contains 6 000 rows and 4-5 columns with headers: I need help comparing two Excel files in Powershell.
0 kommentar(er)
