René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"\"IBM437 is not supported encoding name\" exception when saving Excel workbook on daily PS 7.3 build","articleBody":"### Prerequisites\r\n\r\n- [X] Write a descriptive title.\r\n- [X] Make sure you are able to repro it on the [latest released version](https://github.com/PowerShell/PowerShell/releases)\r\n- [X] Search the existing issues.\r\n- [X] Refer to the [FAQ](https://github.com/PowerShell/PowerShell/blob/master/docs/FAQ.md).\r\n- [X] Refer to [Differences between Windows PowerShell 5.1 and PowerShell](https://docs.microsoft.com/powershell/scripting/whats-new/differences-from-windows-powershell).\r\n\r\n### Steps to reproduce\r\n\r\nSaving Excel workbook with *ImportExcel* module on latest daily build of PS 7.3 throws following exception:\r\n*(It works correctly on PowerShell 7.3.0 GA and PowerShell 7.2.7 or PowerShell 5.1)*\r\n```powershell\r\nPSMessageDetails      :\r\nException             : System.Management.Automation.MethodInvocationException: Exception calling \"SaveAs\" with \"1\" argument(s): \"Error saving file ---\"\r\n                         ---\u003e System.InvalidOperationException: Error saving file ---\r\n                         ---\u003e System.ArgumentException: 'IBM437' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method. (Parameter 'name')\r\n                           at System.Text.EncodingTable.InternalGetCodePageFromName(String name)\r\n                           at System.Text.EncodingTable.GetCodePageFromName(String name)\r\n                           at System.Text.Encoding.GetEncoding(String name)\r\n                           at OfficeOpenXml.Packaging.Ionic.Zip.ZipOutputStream..ctor(Stream stream, Boolean leaveOpen)\r\n                           at OfficeOpenXml.Packaging.ZipPackage.Save(Stream stream)\r\n                           at OfficeOpenXml.ExcelPackage.Save()\r\n                           --- End of inner exception stack trace ---\r\n                           at OfficeOpenXml.ExcelPackage.Save()\r\n                           at CallSite.Target(Closure, CallSite, ExcelPackage, Object)\r\n                           --- End of inner exception stack trace ---\r\n                           at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\runtime\\Operations\\MiscOps.cs:line 1659\r\n                           at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\CallInstruction.Generated.cs:line 504\r\n                           at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\ControlFlowInstructions.cs:line 338\r\n                           at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\ControlFlowInstructions.cs:line 338\r\n                           at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\Interpreter.cs:line 101\r\n                           at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\LightLambda.Generated.cs:line 82\r\n                           at System.Management.Automation.PSScriptCmdlet.RunClause(Action`1 clause, Object dollarUnderbar, Object inputToProcess) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\runtime\\CompiledScriptBlock.cs:line 2435\r\n                           at System.Management.Automation.CommandProcessorBase.Complete() in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\CommandProcessorBase.cs:line 593\r\nTargetObject          :\r\nCategoryInfo          : NotSpecified: (:) [], MethodInvocationException\r\nFullyQualifiedErrorId : InvalidOperationException\r\nErrorDetails          :\r\nInvocationInfo        : System.Management.Automation.InvocationInfo\r\nScriptStackTrace      : at Close-ExcelPackage, C:\\Program Files\\WindowsPowerShell\\Modules\\ImportExcel\\7.8.2\\Public\\Close-ExcelPackage.ps1: line 25\r\n                        at Export-KBExcelNodeStatusReport\u003cEnd\u003e, \u003cNo file\u003e: line 1001\r\n                        at \u003cScriptBlock\u003e, \u003cNo file\u003e: line 1\r\nPipelineIterationInfo : {}\r\n\r\n```\r\n\r\n### Expected behavior\r\n\r\n```console\r\nThe Excel workbook should be saved without exception like on PowerShell 7.3.0 GA and PowerShell 7.2.7, or PowerShell 5.1\r\n```\r\n\r\n\r\n### Actual behavior\r\n\r\n```console\r\nAn exception is thrown.\r\n```\r\n\r\n\r\n### Error details\r\n\r\n```console\r\nPSMessageDetails      :\r\nException             : System.Management.Automation.MethodInvocationException: Exception calling \"SaveAs\" with \"1\" argument(s): \"Error saving file ---\"\r\n                         ---\u003e System.InvalidOperationException: Error saving file ---\r\n                         ---\u003e System.ArgumentException: 'IBM437' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method. (Parameter 'name')\r\n                           at System.Text.EncodingTable.InternalGetCodePageFromName(String name)\r\n                           at System.Text.EncodingTable.GetCodePageFromName(String name)\r\n                           at System.Text.Encoding.GetEncoding(String name)\r\n                           at OfficeOpenXml.Packaging.Ionic.Zip.ZipOutputStream..ctor(Stream stream, Boolean leaveOpen)\r\n                           at OfficeOpenXml.Packaging.ZipPackage.Save(Stream stream)\r\n                           at OfficeOpenXml.ExcelPackage.Save()\r\n                           --- End of inner exception stack trace ---\r\n                           at OfficeOpenXml.ExcelPackage.Save()\r\n                           at CallSite.Target(Closure, CallSite, ExcelPackage, Object)\r\n                           --- End of inner exception stack trace ---\r\n                           at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\runtime\\Operations\\MiscOps.cs:line 1659\r\n                           at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\CallInstruction.Generated.cs:line 504\r\n                           at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\ControlFlowInstructions.cs:line 338\r\n                           at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\ControlFlowInstructions.cs:line 338\r\n                           at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\Interpreter.cs:line 101\r\n                           at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\interpreter\\LightLambda.Generated.cs:line 82\r\n                           at System.Management.Automation.PSScriptCmdlet.RunClause(Action`1 clause, Object dollarUnderbar, Object inputToProcess) in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\runtime\\CompiledScriptBlock.cs:line 2435\r\n                           at System.Management.Automation.CommandProcessorBase.Complete() in D:\\DEVELOPMENT\\PowerShellCore\\src\\System.Management.Automation\\engine\\CommandProcessorBase.cs:line 593\r\nTargetObject          :\r\nCategoryInfo          : NotSpecified: (:) [], MethodInvocationException\r\nFullyQualifiedErrorId : InvalidOperationException\r\nErrorDetails          :\r\nInvocationInfo        : System.Management.Automation.InvocationInfo\r\nScriptStackTrace      : at Close-ExcelPackage, C:\\Program Files\\WindowsPowerShell\\Modules\\ImportExcel\\7.8.2\\Public\\Close-ExcelPackage.ps1: line 25\r\n                        at Export-KBExcelNodeStatusReport\u003cEnd\u003e, \u003cNo file\u003e: line 1001\r\n                        at \u003cScriptBlock\u003e, \u003cNo file\u003e: line 1\r\nPipelineIterationInfo : {}\r\n```\r\n\r\n\r\n### Environment data\r\n\r\n```powershell\r\nName                           Value\r\n----                           -----\r\nPSVersion                      7.3.0-preview.3\r\nPSEdition                      Core\r\nGitCommitId                    7.3.0-preview.3-461-g9f459c05f617fe530dac340aa546d198724d85da\r\nOS                             Microsoft Windows 10.0.19045\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0, 5.0, 5.1, 6.0.0, 6.1.0…}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n```\r\n\r\n\r\n### Visuals\r\n\r\n![exception](https://user-images.githubusercontent.com/16168755/201366948-8225c4ec-938d-4925-9466-bce19dff5850.jpg)\r\n","author":{"url":"https://github.com/kborowinski","@type":"Person","name":"kborowinski"},"datePublished":"2022-11-11T15:10:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":11},"url":"https://github.com/18537/PowerShell/issues/18537"}