[研究]ASP.NET,WebForm, NuGet安裝ClosedXML 0.104.1相依套件測試

[研究]ASP.NET,WebForm, NuGet安裝ClosedXML 0.104.1相依套件測試

2024-10-09

環境：Visual Studio 2022 + ASP.NET + WebForm + Web Application + C# + SQL Server 2019 + SQL Server Management Studio (SSMS) 19

********************************************************************************

WebApplication1

正在安裝:

DocumentFormat.OpenXml.Framework.3.0.1

DocumentFormat.OpenXml.3.0.1

ExcelNumberFormat.1.1.0

Microsoft.Bcl.HashCode.1.1.1

Microsoft.NETCore.Platforms.1.1.0

Microsoft.Win32.Primitives.4.3.0

System.AppContext.4.3.0

System.Buffers.4.5.1

System.Collections.4.3.0

System.Collections.Concurrent.4.3.0

System.Console.4.3.0

System.Diagnostics.Debug.4.3.0

System.Diagnostics.DiagnosticSource.4.3.0

System.Diagnostics.Tools.4.3.0

System.Diagnostics.Tracing.4.3.0

System.Globalization.4.3.0

System.Globalization.Calendars.4.3.0

System.IO.4.3.0

System.IO.Compression.4.3.0

System.IO.Compression.ZipFile.4.3.0

System.IO.FileSystem.Primitives.4.3.0

System.IO.FileSystem.4.3.0

System.IO.Packaging.8.0.0

System.Linq.4.3.0

System.Linq.Expressions.4.3.0

System.Net.Primitives.4.3.0

System.Net.Sockets.4.3.0

System.Numerics.Vectors.4.5.0

System.ObjectModel.4.3.0

System.Reflection.4.3.0

System.Reflection.Extensions.4.3.0

System.Reflection.Primitives.4.3.0

System.Resources.ResourceManager.4.3.0

System.Runtime.4.3.0

System.Runtime.CompilerServices.Unsafe.4.7.0

System.Memory.4.5.4

ClosedXML.Parser.1.2.0

SixLabors.Fonts.1.0.0

System.Runtime.Extensions.4.3.0

System.Runtime.Handles.4.3.0

System.Runtime.InteropServices.4.3.0

System.Runtime.InteropServices.RuntimeInformation.4.3.0

System.Runtime.Numerics.4.3.0

System.Security.Cryptography.Encoding.4.3.0

System.Security.Cryptography.Primitives.4.3.0

System.Security.Cryptography.Algorithms.4.3.0

System.Security.Cryptography.X509Certificates.4.3.0

System.Net.Http.4.3.0

System.Text.Encoding.4.3.0

System.Text.Encoding.Extensions.4.3.0

System.Text.RegularExpressions.4.3.0

System.Threading.4.3.0

System.Threading.Tasks.4.3.0

System.Threading.Timer.4.3.0

System.Xml.ReaderWriter.4.3.0

System.Xml.XDocument.4.3.0

NETStandard.Library.1.6.1

RBush.3.2.0

ClosedXML.0.104.1

成功

********************************************************************************

再次更新

WebApplication1

更新:

NETStandard.Library.1.6.1 -> NETStandard.Library.2.0.3

System.Xml.ReaderWriter.4.3.0 -> System.Xml.ReaderWriter.4.3.1

System.Text.RegularExpressions.4.3.0 -> System.Text.RegularExpressions.4.3.1

System.Net.Http.4.3.0 -> System.Net.Http.4.3.4

System.Security.Cryptography.X509Certificates.4.3.0 -> System.Security.Cryptography.X509Certificates.4.3.2

System.Security.Cryptography.Algorithms.4.3.0 -> System.Security.Cryptography.Algorithms.4.3.1

System.Runtime.Extensions.4.3.0 -> System.Runtime.Extensions.4.3.1

SixLabors.Fonts.1.0.0 -> SixLabors.Fonts.2.0.4

System.Memory.4.5.4 -> System.Memory.4.5.5

System.Runtime.CompilerServices.Unsafe.4.7.0 -> System.Runtime.CompilerServices.Unsafe.6.0.0

System.Runtime.4.3.0 -> System.Runtime.4.3.1

System.Net.Primitives.4.3.0 -> System.Net.Primitives.4.3.1

System.IO.Packaging.8.0.0 -> System.IO.Packaging.8.0.1

System.Diagnostics.DiagnosticSource.4.3.0 -> System.Diagnostics.DiagnosticSource.8.0.1

System.Console.4.3.0 -> System.Console.4.3.1

Microsoft.NETCore.Platforms.1.1.0 -> Microsoft.NETCore.Platforms.7.0.4

Microsoft.CodeDom.Providers.DotNetCompilerPlatform.2.0.1 -> Microsoft.CodeDom.Providers.DotNetCompilerPlatform.4.1.0

DocumentFormat.OpenXml.3.0.1 -> DocumentFormat.OpenXml.3.1.0

DocumentFormat.OpenXml.Framework.3.0.1 -> DocumentFormat.OpenXml.Framework.3.1.0

出現

嚴重性 程式碼 說明 專案 檔案 行 隱藏項目狀態

錯誤 無法安裝封裝 'SixLabors.Fonts 2.0.4'。您正嘗試將此封裝安裝到以 '.NETFramework,Version=v4.8' 為目標的專案，但該封裝不包含任何與架構相容的組件參考或內容檔。如需詳細資訊，請連絡封裝作者。

但是這個專案就是 4.8 啊？

********************************************************************************

把 SixLabors.Fonts 勾選取消，再一次

WebApplication1

更新:

NETStandard.Library.1.6.1 -> NETStandard.Library.2.0.3

System.Xml.ReaderWriter.4.3.0 -> System.Xml.ReaderWriter.4.3.1

System.Text.RegularExpressions.4.3.0 -> System.Text.RegularExpressions.4.3.1

System.Net.Http.4.3.0 -> System.Net.Http.4.3.4

System.Security.Cryptography.X509Certificates.4.3.0 -> System.Security.Cryptography.X509Certificates.4.3.2

System.Security.Cryptography.Algorithms.4.3.0 -> System.Security.Cryptography.Algorithms.4.3.1

System.Runtime.Extensions.4.3.0 -> System.Runtime.Extensions.4.3.1

System.Memory.4.5.4 -> System.Memory.4.5.5

System.Runtime.CompilerServices.Unsafe.4.7.0 -> System.Runtime.CompilerServices.Unsafe.6.0.0

System.Runtime.4.3.0 -> System.Runtime.4.3.1

System.Net.Primitives.4.3.0 -> System.Net.Primitives.4.3.1

System.IO.Packaging.8.0.0 -> System.IO.Packaging.8.0.1

System.Diagnostics.DiagnosticSource.4.3.0 -> System.Diagnostics.DiagnosticSource.8.0.1

System.Console.4.3.0 -> System.Console.4.3.1

Microsoft.NETCore.Platforms.1.1.0 -> Microsoft.NETCore.Platforms.7.0.4

Microsoft.CodeDom.Providers.DotNetCompilerPlatform.2.0.1 -> Microsoft.CodeDom.Providers.DotNetCompilerPlatform.4.1.0

DocumentFormat.OpenXml.3.0.1 -> DocumentFormat.OpenXml.3.1.0

DocumentFormat.OpenXml.Framework.3.0.1 -> DocumentFormat.OpenXml.Framework.3.1.0

嚴重性 程式碼 說明 專案 檔案 行 隱藏項目狀態

錯誤 由於另一個處理序正在使用檔案 'C:\CodeTemp6\WebApplication1\packages\Microsoft.CodeDom.Providers.DotNetCompilerPlatform.4.1.0\tasks/DotNetCompilerPlatformTasks.dll'，所以無法存取該檔案。

********************************************************************************

再次

WebApplication1

更新:

NETStandard.Library.1.6.1 -> NETStandard.Library.2.0.3

System.Xml.ReaderWriter.4.3.0 -> System.Xml.ReaderWriter.4.3.1

System.Text.RegularExpressions.4.3.0 -> System.Text.RegularExpressions.4.3.1

System.Net.Http.4.3.0 -> System.Net.Http.4.3.4

System.Security.Cryptography.X509Certificates.4.3.0 -> System.Security.Cryptography.X509Certificates.4.3.2

System.Security.Cryptography.Algorithms.4.3.0 -> System.Security.Cryptography.Algorithms.4.3.1

System.Runtime.Extensions.4.3.0 -> System.Runtime.Extensions.4.3.1

System.Memory.4.5.4 -> System.Memory.4.5.5

System.Runtime.CompilerServices.Unsafe.4.7.0 -> System.Runtime.CompilerServices.Unsafe.6.0.0

System.Runtime.4.3.0 -> System.Runtime.4.3.1

System.Net.Primitives.4.3.0 -> System.Net.Primitives.4.3.1

System.IO.Packaging.8.0.0 -> System.IO.Packaging.8.0.1

System.Diagnostics.DiagnosticSource.4.3.0 -> System.Diagnostics.DiagnosticSource.8.0.1

System.Console.4.3.0 -> System.Console.4.3.1

Microsoft.NETCore.Platforms.1.1.0 -> Microsoft.NETCore.Platforms.7.0.4

Microsoft.CodeDom.Providers.DotNetCompilerPlatform.2.0.1 -> Microsoft.CodeDom.Providers.DotNetCompilerPlatform.4.1.0

DocumentFormat.OpenXml.3.0.1 -> DocumentFormat.OpenXml.3.1.0

DocumentFormat.OpenXml.Framework.3.0.1 -> DocumentFormat.OpenXml.Framework.3.1.0

成功

最後只剩下

********************************************************************************

packages.config 內容

<?xml version="1.0" encoding="utf-8"?> <packages> <package id="ClosedXML" version="0.104.1" targetFramework="net48" /> <package id="ClosedXML.Parser" version="1.2.0" targetFramework="net48" /> <package id="DocumentFormat.OpenXml" version="3.1.0" targetFramework="net48" /> <package id="DocumentFormat.OpenXml.Framework" version="3.1.0" targetFramework="net48" /> <package id="ExcelNumberFormat" version="1.1.0" targetFramework="net48" /> <package id="Microsoft.Bcl.HashCode" version="1.1.1" targetFramework="net48" /> <package id="Microsoft.CodeDom.Providers.DotNetCompilerPlatform" version="4.1.0" targetFramework="net48" /> <package id="Microsoft.NETCore.Platforms" version="7.0.4" targetFramework="net48" /> <package id="Microsoft.Win32.Primitives" version="4.3.0" targetFramework="net48" /> <package id="NETStandard.Library" version="2.0.3" targetFramework="net48" /> <package id="RBush" version="3.2.0" targetFramework="net48" /> <package id="SixLabors.Fonts" version="1.0.0" targetFramework="net48" /> <package id="System.AppContext" version="4.3.0" targetFramework="net48" /> <package id="System.Buffers" version="4.5.1" targetFramework="net48" /> <package id="System.Collections" version="4.3.0" targetFramework="net48" /> <package id="System.Collections.Concurrent" version="4.3.0" targetFramework="net48" /> <package id="System.Console" version="4.3.1" targetFramework="net48" /> <package id="System.Diagnostics.Debug" version="4.3.0" targetFramework="net48" /> <package id="System.Diagnostics.DiagnosticSource" version="8.0.1" targetFramework="net48" /> <package id="System.Diagnostics.Tools" version="4.3.0" targetFramework="net48" /> <package id="System.Diagnostics.Tracing" version="4.3.0" targetFramework="net48" /> <package id="System.Globalization" version="4.3.0" targetFramework="net48" /> <package id="System.Globalization.Calendars" version="4.3.0" targetFramework="net48" /> <package id="System.IO" version="4.3.0" targetFramework="net48" /> <package id="System.IO.Compression" version="4.3.0" targetFramework="net48" /> <package id="System.IO.Compression.ZipFile" version="4.3.0" targetFramework="net48" /> <package id="System.IO.FileSystem" version="4.3.0" targetFramework="net48" /> <package id="System.IO.FileSystem.Primitives" version="4.3.0" targetFramework="net48" /> <package id="System.IO.Packaging" version="8.0.1" targetFramework="net48" /> <package id="System.Linq" version="4.3.0" targetFramework="net48" /> <package id="System.Linq.Expressions" version="4.3.0" targetFramework="net48" /> <package id="System.Memory" version="4.5.5" targetFramework="net48" /> <package id="System.Net.Http" version="4.3.4" targetFramework="net48" /> <package id="System.Net.Primitives" version="4.3.1" targetFramework="net48" /> <package id="System.Net.Sockets" version="4.3.0" targetFramework="net48" /> <package id="System.Numerics.Vectors" version="4.5.0" targetFramework="net48" /> <package id="System.ObjectModel" version="4.3.0" targetFramework="net48" /> <package id="System.Reflection" version="4.3.0" targetFramework="net48" /> <package id="System.Reflection.Extensions" version="4.3.0" targetFramework="net48" /> <package id="System.Reflection.Primitives" version="4.3.0" targetFramework="net48" /> <package id="System.Resources.ResourceManager" version="4.3.0" targetFramework="net48" /> <package id="System.Runtime" version="4.3.1" targetFramework="net48" /> <package id="System.Runtime.CompilerServices.Unsafe" version="6.0.0" targetFramework="net48" /> <package id="System.Runtime.Extensions" version="4.3.1" targetFramework="net48" /> <package id="System.Runtime.Handles" version="4.3.0" targetFramework="net48" /> <package id="System.Runtime.InteropServices" version="4.3.0" targetFramework="net48" /> <package id="System.Runtime.InteropServices.RuntimeInformation" version="4.3.0" targetFramework="net48" /> <package id="System.Runtime.Numerics" version="4.3.0" targetFramework="net48" /> <package id="System.Security.Cryptography.Algorithms" version="4.3.1" targetFramework="net48" /> <package id="System.Security.Cryptography.Encoding" version="4.3.0" targetFramework="net48" /> <package id="System.Security.Cryptography.Primitives" version="4.3.0" targetFramework="net48" /> <package id="System.Security.Cryptography.X509Certificates" version="4.3.2" targetFramework="net48" /> <package id="System.Text.Encoding" version="4.3.0" targetFramework="net48" /> <package id="System.Text.Encoding.Extensions" version="4.3.0" targetFramework="net48" /> <package id="System.Text.RegularExpressions" version="4.3.1" targetFramework="net48" /> <package id="System.Threading" version="4.3.0" targetFramework="net48" /> <package id="System.Threading.Tasks" version="4.3.0" targetFramework="net48" /> <package id="System.Threading.Timer" version="4.3.0" targetFramework="net48" /> <package id="System.Xml.ReaderWriter" version="4.3.1" targetFramework="net48" /> <package id="System.Xml.XDocument" version="4.3.0" targetFramework="net48" /> </packages>

相依套件頗多的，比較重要是 DocumentFormat.OpenXml，而且必須是 3.x 版才行。

********************************************************************************

額外補充

嚴重性 程式碼 說明 專案 檔案 行 隱藏項目狀態

錯誤 無法安裝封裝 'SixLabors.Fonts 2.0.4'。您正嘗試將此封裝安裝到以 '.NETFramework,Version=v4.8' 為目標的專案，但該封裝不包含任何與架構相容的組件參考或內容檔。如需詳細資訊，請連絡封裝作者。

https://www.nuget.org/packages/SixLabors.Fonts/1.0.1

SixLabors.Fonts 1.0.1 支援 .NET Core 3.1 和 .NET Standard 2.0

https://www.nuget.org/packages/SixLabors.Fonts/2.0.4

SixLabors.Fonts 2.0.4 支援 .NET 6.0

(完)

相關