EPPlus support for net6 on linux.

[gr3ysky]

I use EPPlus for export data as Excel files. Currently, System.Drawwing.Common is not supported for net6 applications runing under linux (as a docker image).

Here is the exception

//inner exception

              "ClassName" : "System.TypeInitializationException",
              "Message" : "The type initializer for 'Gdip' threw an exception.",
              "Source" : "System.Drawing.Common",
              "StackTraceString" : """   at System.Drawing.SafeNativeMethods.Gdip.GdipGetGenericFontFamilySansSerif(IntPtr& fontfamily)
   at System.Drawing.FontFamily.GetGdipGenericSansSerif()
   at System.Drawing.FontFamily.get_GenericSansSerif()
   at System.Drawing.Font.CreateFont(String familyName, Single emSize, FontStyle style, GraphicsUnit unit, Byte charSet, Boolean isVertical)
   at System.Drawing.Font..ctor(String familyName, Single emSize, FontStyle style, GraphicsUnit unit, Byte gdiCharSet, Boolean gdiVerticalFont)
   at OfficeOpenXml.ExcelRangeBase.AutoFitColumns(Double MinimumWidth, Double MaximumWidth)

-----
//actual exception
"ClassName" : "System.PlatformNotSupportedException",
              "Message" : "System.Drawing.Common is not supported on non-Windows platforms. See https://aka.ms/systemdrawingnonwindows for more information.",
              "Source" : "System.Drawing.Common",
              "StackTraceString" : """   at System.Drawing.LibraryResolver.EnsureRegistered()
   at System.Drawing.SafeNativeMethods.Gdip.PlatformInitialize()
   at System.Drawing.SafeNativeMethods.Gdip..cctor()""",

This was working on net5.
Is there a way to fix this?
Thanks.

[JanKallman]

We are currently working on replacing System.Drawing.Common, likely available early next year, but for now you can set the System.Drawing.EnableUnixSupport switch. See https://docs.microsoft.com/en-us/dotnet/core/compatibility/core-libraries/6.0/system-drawing-common-windows-only .

[JLOrdaz]

This not working for me, I waiting for new update. While I have to use a windows container 😞

[JanKallman]

Hmm that's weired. We are currently working on this in this branch https://github.com/EPPlusSoftware/EPPlus/tree/feature/drawing_to_skia, but it's "Work In Progress". System.Drawing.Common will be removed from .NET standard/core (we will also add a new .NET6 build). We will add native image and text measure support with fallback on Skia or System.Drawing.Common.

[SymbioticKilla]

This not working for me, I waiting for new update. While I have to use a windows container 😞

Have you tried with libgdiplus? We use it in alpine image. Ex.::
RUN echo "https://dl-cdn.alpinelinux.org/alpine/edge/testing" >> /etc/apk/repositories
&& apk add --update --no-cache
libgdiplus

[farhadmammadli]

Just set this line anywhere before creating an excel file and forget about it
AppContext.SetSwitch("System.Drawing.EnableUnixSupport", true);

Alternatively, you can set switch in csproj

<ItemGroup>
      <RuntimeHostConfigurationOption Include="System.Drawing.EnableUnixSupport" Value="true" />
</ItemGroup>

or environment variable in the Dockerfile
ENV DOTNET_System_Drawing_EnableUnixSupport=true

[durranitech]

Dotnet 7 preview has removed the compatibility flag also.

dotnet/runtime#64084

[JanKallman]

EPPlus 6 will remove the dependence on System.Drawing.Common. We will release EPPlus 6 as beta this week or the week after. Feel free to help us test if when it's available. If you want to test it now, please build EPPlus from this branch...https://github.com/EPPlusSoftware/EPPlus/tree/beta/epplus6.
See breaking changes here... https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-6

[durranitech]

Many thanks @JanKallman I'll build from source and try

[JanKallman]

Feel free to try EPPlus 6.0.0-beta, now released on Nuget. Also checkout our new docker sample available here...https://github.com/EPPlusSoftware/EPPlus.DockerSample

[JanKallman]

Fixed in version 6.0.3

[gr3ysky]

Fixed in version 6.0.3

many thanks.

[saxx]

Sorry for commenting on an older, closed isuse - but I'm tracking down an issue with System.Drawing.Common and .NET 7 and as far as I can say, EPPlus 6 still has an (indirect) dependency on System.Drawing.Common (via EPPlus.System.Drawing)? Is this correct?

[JanKallman]

Yes, but it is only used under Linux if libgdiplus is installed. Otherwise the internal generic image handler is used.
System.Drawing.Common is still used under Windows.