Chang.OpenXml
8.0.1
dotnet add package Chang.OpenXml --version 8.0.1
NuGet\Install-Package Chang.OpenXml -Version 8.0.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Chang.OpenXml" Version="8.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Chang.OpenXml" Version="8.0.1" />
<PackageReference Include="Chang.OpenXml" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Chang.OpenXml --version 8.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Chang.OpenXml, 8.0.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Chang.OpenXml@8.0.1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Chang.OpenXml&version=8.0.1
#tool nuget:?package=Chang.OpenXml&version=8.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
📘 Chang.OpenXml
輕量、無相依、可在任何 .NET 環境中運行的 Excel 匯入/匯出工具,
基於 DocumentFormat.OpenXml 建構,
支援 DataSet / DataTable 的快速匯出、匯入、串流下載,適合 ASP.NET Core、WinForm、WPF 或背景批次使用。
✨ 功能特色
- ✅ 匯出 DataSet / DataTable 至 Excel (
.xlsx)- 支援多個 Sheet,自動命名、避免重複
- 以 SharedStringTable 寫入,檔案體積小
- 可輸出為檔案、byte[] 或 Stream
- ✅ 從 Excel 匯入為 DataSet
- 自動處理缺欄位(以 CellReference 對齊)
- 可選首列是否為欄名 (
hasHeaderRow) - 內建 Sheet 名稱清理(Sanitize)
- ✅ 效能優化
- SharedString 快取(避免 O(n²) 查找)
- 適用大資料集(可改以 FileStream 暫存)
- ✅ 無需 COM / Interop
- 完全托管、無外部依賴,可於 Linux / macOS 執行
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- DocumentFormat.OpenXml (>= 3.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 8.0.1 | 314 | 10/25/2025 |