Add option to disable hyperlinking

[dbaileyut]

Hi,

Using ImportExcel 7.1.1, there doesn't appear to be a way to disable making text a hyperlink if there's letters on either side of a colon. E.g.:

[PSCustomObject]@{Test='abc:123'} | Export-Excel -Path test123.xlsx

Results in this:

I have some data that matches this format but I'd like it to be plain text and not a hyperlink. Am I missing something? If not, could you add a parameter or format option to disable hyperlinking?

Thanks!

[dfinke]

No there is no helper functions for the or examples. You'd need to use -PassThru and Set-Format for the range(s) to turn off the underline.

[dbaileyut]

That would turn off the underline, but wouldn't it still be a hyperlink?

[dbaileyut]

I think what I'm asking for is an option to avoid falling into code paths where "IsWellFormedUriString" evaluates as true like this:

ImportExcel/Public/Export-Excel.ps1

Lines 331 to 341 in 0a77a83

	elseif ( [System.Uri]::IsWellFormedUriString($v , [System.UriKind]::Absolute) ) {
	if ($v -match "^xl://internal/") {
	$referenceAddress = $v -replace "^xl://internal/" , ""
	$display = $referenceAddress -replace "!A1$" , ""
	$h = New-Object -TypeName OfficeOpenXml.ExcelHyperLink -ArgumentList $referenceAddress , $display
	$ws.Cells[$row, $ColumnIndex].HyperLink = $h
	}
	else {$ws.Cells[$row, $ColumnIndex].HyperLink = $v } #$ws.Cells[$row, $ColumnIndex].Value = $v.AbsoluteUri
	$ws.Cells[$row, $ColumnIndex].Style.Font.Color.SetColor([System.Drawing.Color]::Blue)
	$ws.Cells[$row, $ColumnIndex].Style.Font.UnderLine = $true
	}

[dfinke]

Understood. Sorry, at this point, I don't have the time to build that or add the tests to prove it out.

[joelwiesmann]

@dbaileyut I had the same issue today. I solved it with a little workaround:
[PSCustomObject]@{Test='="abc:asd123"'} | Export-Excel -Path test123.xlsx

Might not be the best solution for all use-cases, but for me it works.