Casting Error in Export-Excel

[fMichaleczek]

I have an reccurent error in Export-Excel.ps1

The french message error is (sorry I don't have a english system available now) :
Surcharge introuvable pour « TryParse » et le nombre d'arguments « 4 ».

Problem is a casting problem that can be resolve in ligne 184 :

Before :
if( [Double]::TryParse( $cellValue, [System.Globalization.NumberStyles]::Any, [System.Globalization.NumberFormatInfo]::InvariantInfo, [ref]$r ) ) {

After :
if( [Double]::TryParse( [string]$cellValue, [System.Globalization.NumberStyles]::Any, [System.Globalization.NumberFormatInfo]::InvariantInfo, [ref]$r ) ) {

[dfinke]

Thanks, I'll investigate.

[dfinke]

@fMichaleczek Please, could you post a small sample of data that causes the problem

[fMichaleczek]

gps | Export-Clixml -Path $env:temp\a.clixml
$gps = Import-Clixml -Path $env:temp\a.clixml
$gps | Export-Excel -Path $env:temp\a.xlsx

[dfinke]

Great, could you post the a.clixml file?

[dfinke]

never mind. it caused the error on my side