OfficeOpenXml删除HyperLink

Question

我使用Powershell模块"ImportExcel“来生成xlsx报告。一些字符串，如"openstack-9cea5509-ed06-4301-b9e2-10f742e8c174:8"，，在单元格中添加为HyperLink。我无法删除HyperLink，下一个方法不起作用：

$d = @(
    [PSCustomObject]@{
        HLUNID = "String11`nString22"
        HostID = "String33`nStrong44"
    }
    [PSCustomObject]@{
        HLUNID = "String55`nString552"
        HostID = "openstack-9cea5509-ed06-4301-b9e2-10f742e8c174:8"
    }
)

Export-Excel -Path "out1.xlsx" -InputObject $d -WorksheetName 'Luns' -AutoNameRange
$Excel = Open-ExcelPackage -Path "out1.xlsx"
$Excel.Workbook.Worksheets['Luns'].Cells['HostID'] | Set-ExcelRange -ResetFont
$Excel.Workbook.Worksheets['Luns'].Cells[3,2].HyperLink = ''
Close-ExcelPackage -ExcelPackage $Excel

字符串钢保持可点击：Image - "Clickable cell"

下一个方法不存在：

$Excel.Workbook.Worksheets['Luns'].Cells[3,2].HyperLink.Remove()
$Excel.Workbook.Worksheets['Luns'].Cells[3,2].HyperLink.Dispose()

请给我另一种删除HyperLynk的方法。

Answer 1

尝试设置超链接$null

$Excel.Workbook.Worksheets['Luns'].Cells[3,2].HyperLink = $null

它将删除超链接，但不会触及格式。

请阅读有关管理超链接的方法和功能，我建议将其包含在模块中。How to make Excel hyperlinks with PowerShell?