spikes/ConvertFrom-ExcelColumnName.ps1
|
function ConvertFrom-ExcelColumnName { param($columnName) $sum=0 $columnName.ToCharArray() | ForEach-Object { $sum*=26 $sum+=[char]$_.tostring().toupper()-[char]'A'+1 } $sum } ConvertFrom-ExcelColumnName p ConvertFrom-ExcelColumnName ah ConvertFrom-ExcelColumnName xfd |