EPPlus error reading file

Question

using code like

using OfficeOpenXml;  // namespace for the ExcelPackage assembly
…
FileInfo newFile = new FileInfo(@"C:\mynewfile.xlsx"); 
using (ExcelPackage xlPackage = new ExcelPackage(newFile)) { … }

I get an exception error of

'IBM437' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method. Parameter name: name

Any ideas as to what the problem could be?

Thanks Martin

post an answer so others have some use of it too – dee zg Jul 13 '17 at 07:50 — dee zg, Jul 13 '17 at 07:50

score 6 · Answer 1 · answered Mar 17 '19 at 21:08

6

if your project is .net core edit your project file then add

<ItemGroup>
<PackageReference Include="System.Text.Encoding.CodePages" Version="4.3.0" />
</ItemGroup>

and in your startup.cs

add

System.Text.Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);

answered Mar 17 '19 at 21:08

M.Ali El-Sayed

1,608
20
23

1

I have it in the startup constructor and it works! thanks! – krishna422 Jun 10 '21 at 13:27

score 3 · Answer 2 · answered Sep 16 '17 at 23:37

3

The problem is in the ZIP file reader (ZipInputStream). You need to add the encodings like windows-1252 manually:

dotnet add package System.Text.Encoding.CodePages
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);

More info here: .NET Core doesn't know about Windows 1252, how to fix?

answered Sep 16 '17 at 23:37

Svetlin Nakov

1,599
18
19

1

Where do you apply these steps ?? – Luke Hammer Sep 17 '18 at 22:40

EPPlus error reading file

2 Answers2

Linked