用PowerShell在Excel中查找和替换

# 创建Excel应用程序对象
$excel = New-Object -ComObject Excel.Application

# 打开Excel文件
$workbook = $excel.Workbooks.Open("C:\path\to\your\excel_file.xlsx")

# 选择要操作的工作表
$worksheet = $workbook.Worksheets.Item(1)

# 查找和替换数据
$find = "old_value"
$replace = "new_value"
$lookAt = -4163  # xlPart，部分匹配
$searchOrder = 1  # xlByRows，按行搜索
$matchCase = $false  # 不区分大小写
$matchWholeWord = $false  # 不匹配整个单词
$matchByte = $true  # 匹配全角和半角字符
$worksheet.Cells.Replace($find, $replace, $lookAt, $searchOrder, $matchCase, $matchWholeWord, $matchByte)

# 保存并关闭Excel文件
$workbook.Save()
$workbook.Close()

# 退出Excel应用程序
$excel.Quit()