[Running] powershell -ExecutionPolicy ByPass -File "c:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1" Unable to index into an object of type System.Management.Automation.PSObject. At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:20 char:9 + $defectRow['CF_ITEM_PATH'] = $almRow['CF_ITEM_PATH'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : CannotIndex Unable to index into an object of type System.Management.Automation.PSObject. At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:21 char:9 + $defectRow['BG_BUG_ID'] = $almRow['BG_BUG_ID'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : CannotIndex Cannot convert value "CF_ITEM_PATH" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:20 char:9 + $defectRow['CF_ITEM_PATH'] = $almRow['CF_ITEM_PATH'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Cannot convert value "BG_BUG_ID" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:21 char:9 + $defectRow['BG_BUG_ID'] = $almRow['BG_BUG_ID'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Cannot convert value "CF_ITEM_PATH" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:20 char:9 + $defectRow['CF_ITEM_PATH'] = $almRow['CF_ITEM_PATH'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Cannot convert value "BG_BUG_ID" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:21 char:9 + $defectRow['BG_BUG_ID'] = $almRow['BG_BUG_ID'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Cannot convert value "CF_ITEM_PATH" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:20 char:9 + $defectRow['CF_ITEM_PATH'] = $almRow['CF_ITEM_PATH'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Cannot convert value "BG_BUG_ID" to type "System.Int32". Error: "Input string was not in a correct format." At C:\Users\erick.b.lopez\Downloads\Test PW Citi\Test V0.ps1:21 char:9 + $defectRow['BG_BUG_ID'] = $almRow['BG_BUG_ID'] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Exception calling "Save" with "0" argument(s): "Error saving file C:\Users\erick.b.lopez\Downloads\Test PW Citi\Book1.xlsx" At C:\Users\erick.b.lopez\OneDrive - Accenture\Documents\WindowsPowerShell\Modules\ImportExcel\7.8.5\Public\Export-Excel.ps1:686 char:20 + else { $pkg.Save() } + ~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : InvalidOperationException [Done] exited with code=0 in 6.957 seconds