PwerShell Excel 列值遍历 3

$xl=New-Object -ComObject excel.application
$xl.visible=$true
$wb=$xl.workbooks.open("C:\Users\lwang52\Desktop\部门.xlsx")
$sheet=$wb.sheets.item(1)
$object=
for($i=1;$i -lt $sheet.range("a65536").end(-4162).row;$i++) #xlDown -4121 Down. xlToLeft -4159 To left. xlToRight -4161 To right. xlUp -4162 Up.
{
Write-Host $sheet.range("A$i").text #A列对应每行的值 A column correspond to per row value
}

$xl.displayAlerts=$False
$wb.Close()
$xl.Application.Quit()