[研究]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' 為目標的專案，但該封裝不包含任何與架構相容的組件參考或內容檔。如需詳細資訊，請連絡封裝作者。
SixLabors.Fonts 1.0.1 支援 .NET Core 3.1 和 .NET Standard 2.0
SixLabors.Fonts 2.0.4 支援 .NET 6.0
