Hey Guys. Can someone help me?
I am wanting to return a value from the same row but am unsure how it’s done. I can get the row number but then I am stuck.
Can someone point me in the right direction of what the next step would be.
$File = "C:\Temp\DemoData.xlsx" $hostname = 'hostnameHere' #Serial in 'V1' #End date in 'H1' # Setup Excel, open $File and select the 2nd worksheet $Excel = New-Object -ComObject Excel.Application $Excel.visible = $false $Workbook = $Excel.workbooks.open($file) $Worksheets = $Workbooks.worksheets $Worksheet = $Workbook.Worksheets.Item(2) $Range = $Worksheet.Range("V1").EntireColumn $Cell = $Range.find($hostname) $RowNumber = $Cell.row $RowNumber