在powershell中使用excel com对象拉取单元格的值问题

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\your\excel_file.xlsx")

$worksheet = $workbook.Worksheets.Item(1)  # 选择第一个工作表
# 或者
$worksheet = $workbook.Worksheets.Item("Sheet1")  # 通过名称选择工作表

$cell = $worksheet.Cells.Item(1, 1)  # 选择第一个单元格（A1）
# 或者
$cell = $worksheet.Range("A1")  # 通过地址选择单元格

$value = $cell.Value()

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\your\excel_file.xlsx")
$worksheet = $workbook.Worksheets.Item(1)
$cell = $worksheet.Cells.Item(1, 1)
$value = $cell.Value()
$excel.Quit()