Support for running ImportExcel on Amazon (using aws lambdas) ?

[ninmonkey]

My main question is: Should I be able to use ImportExcel in a linux container?

I'm using aws lambdas. I'm trying to figure out if I can include it like a regular Pwsh module, in a layer.
Or, if I have to build a custom runtime, for those dependencies.

I do not need autosize, if it simplifies things.

WARNING: ImportExcel Module Cannot Autosize. Please run the following command to install dependencies:
apt-get -y update && apt-get install -y --no-install-recommends libgdiplus libc6-dev

I'm using the Amazon Linux 2 provided.al2

PwshRuntimeLayer2:
    Type: AWS::Serverless::LayerVersion
    Properties:
      ContentUri: powershell-runtime
      CompatibleRuntimes:
        - provided.al2

Exception             : 
    Type           : System.Management.Automation.MethodInvocationException
    ErrorRecord    : 
        Exception             : 
            Type    : System.Management.Automation.ParentContainsErrorRecordException
            Message : Exception calling "AutoFitColumns" with "0" argument(s): "The type initializer for 'Gdip' threw an exception."

    InnerException : 
        Type           : System.TypeInitializationException
        TypeName       : Gdip
        TargetSite     : 
            Name          : GdipGetGenericFontFamilySansSerif
            DeclaringType : System.Drawing.SafeNativeMethods+Gdip, System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
            MemberType    : Method
            Module        : System.Drawing.Common.dll
        Message        : The type initializer for 'Gdip' threw an exception.
        InnerException : 
            Type       : System.PlatformNotSupportedException
            TargetSite : 
                Name          : EnsureRegistered
                DeclaringType : System.Drawing.LibraryResolver, System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
                MemberType    : Method
                Module        : System.Drawing.Common.dll
            Message    : System.Drawing.Common is not supported on non-Windows platforms. See https://aka.ms/systemdrawingnonwindows for more information.
            Source     : System.Drawing.Common

Summary (Click to Expand)

Exception             : 
    Type           : System.Management.Automation.MethodInvocationException
    ErrorRecord    : 
        Exception             : 
            Type    : System.Management.Automation.ParentContainsErrorRecordException
            Message : Exception calling "AutoFitColumns" with "0" argument(s): "The type initializer for 'Gdip' threw an exception."
            HResult : -2146233087
        CategoryInfo          : NotSpecified: (:) [], ParentContainsErrorRecordException
        FullyQualifiedErrorId : TypeInitializationException
        InvocationInfo        : 
            ScriptLineNumber : 37
            OffsetInLine     : 9
            HistoryId        : -1
            ScriptName       : /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1
            Line             : $Cells.AutoFitColumns()
                               
            PositionMessage  : At /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1:37 char:9
                               +         $Cells.AutoFitColumns()
                               +         ~~~~~~~~~~~~~~~~~~~~~~~
            PSScriptRoot     : /var/task/modules/ImportExcel/7.6.0
            PSCommandPath    : /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1
            CommandOrigin    : Internal
        ScriptStackTrace      : at <ScriptBlock>, /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1: line 37
                                at <ScriptBlock>, /var/task/examplehandler.ps1: line 52
                                at <ScriptBlock>, <No file>: line 32
    TargetSite     : 
        Name          : CheckActionPreference
        DeclaringType : System.Management.Automation.ExceptionHandlingOps, System.Management.Automation, Version=7.2.4.500, Culture=neutral, PublicKeyToken=31bf3856ad364e35
        MemberType    : Method
        Module        : System.Management.Automation.dll
    Message        : Exception calling "AutoFitColumns" with "0" argument(s): "The type initializer for 'Gdip' threw an exception."
    Data           : System.Collections.ListDictionaryInternal
    InnerException : 
        Type           : System.TypeInitializationException
        TypeName       : Gdip
        TargetSite     : 
            Name          : GdipGetGenericFontFamilySansSerif
            DeclaringType : System.Drawing.SafeNativeMethods+Gdip, System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
            MemberType    : Method
            Module        : System.Drawing.Common.dll
        Message        : The type initializer for 'Gdip' threw an exception.
        InnerException : 
            Type       : System.PlatformNotSupportedException
            TargetSite : 
                Name          : EnsureRegistered
                DeclaringType : System.Drawing.LibraryResolver, System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51
                MemberType    : Method
                Module        : System.Drawing.Common.dll
            Message    : System.Drawing.Common is not supported on non-Windows platforms. See https://aka.ms/systemdrawingnonwindows for more information.
            Source     : System.Drawing.Common
            HResult    : -2146233031
            StackTrace : 
   at System.Drawing.LibraryResolver.EnsureRegistered()
   at System.Drawing.SafeNativeMethods.Gdip..cctor()
        Source         : System.Drawing.Common
        HResult        : -2146233036
        StackTrace     : 
   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)
   at OfficeOpenXml.ExcelRangeBase.AutoFitColumns(Double MinimumWidth, Double MaximumWidth)
   at CallSite.Target(Closure , CallSite , Object )
    Source         : System.Management.Automation
    HResult        : -2146233087
    StackTrace     : 
   at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
   at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
FullyQualifiedErrorId : TypeInitializationException
InvocationInfo        : 
    ScriptLineNumber : 37
    OffsetInLine     : 9
    HistoryId        : -1
    ScriptName       : /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1
    Line             : $Cells.AutoFitColumns()
                       
    PositionMessage  : At /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1:37 char:9
                       +         $Cells.AutoFitColumns()
                       +         ~~~~~~~~~~~~~~~~~~~~~~~
    PSScriptRoot     : /var/task/modules/ImportExcel/7.6.0
    PSCommandPath    : /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1
    CommandOrigin    : Internal
ScriptStackTrace      : at <ScriptBlock>, /var/task/modules/ImportExcel/7.6.0/ImportExcel.psm1: line 37
                        at <ScriptBlock>, /var/task/examplehandler.ps1: line 52
                        at <ScriptBlock>, <No file>: line 32

[dfinke]

I have successfully run ImportExcel in Linux containers on GitHub Actions. That is just a warning about Autosize. Should work to read/write xlsx files.