Angri450.Nong.Excel
1.0.1
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Angri450.Nong.Excel --version 1.0.1
NuGet\Install-Package Angri450.Nong.Excel -Version 1.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="Angri450.Nong.Excel" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Angri450.Nong.Excel" Version="1.0.1" />
<PackageReference Include="Angri450.Nong.Excel" />
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 Angri450.Nong.Excel --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Angri450.Nong.Excel, 1.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 Angri450.Nong.Excel@1.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=Angri450.Nong.Excel&version=1.0.1
#tool nuget:?package=Angri450.Nong.Excel&version=1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Angri450.Nong.Excel
农学生表格生成库——ClosedXML 封装,链式建表。
核心能力
ExcelBuilder.Sheet — 链式建表
var wb = new XLWorkbook();
ExcelBuilder.Sheet(wb, "实验数据")
.Headers("处理", "重复1", "重复2", "重复3")
.Data(new[] {
new[] { "CK", "12.3", "13.1", "11.8" },
new[] { "T1", "18.5", "19.2", "17.9" },
})
.ColumnWidths(10, 8, 8, 8);
FormulaValidator.SaveWithEvaluation(wb, "data.xlsx");
StylePresets.BuildFromJson — 一键配色
var preset = StylePresets.BuildFromJson("formats/mono.json");
// preset.HeaderBgColor, preset.AccentColor...
内置 mono(深灰白字)和 finance(深蓝暖橙)两套配色。
ExcelPreview — 生成即诊断
var r = ExcelPreview.Preview("data.xlsx");
Console.WriteLine(r.Text); // 文本网格预览
// r.Warnings: ### 截断、公式错误、列宽问题
快速开始
dotnet add package Angri450.Nong.Excel
using ClosedXML.Excel;
using ExcelCore;
var wb = new XLWorkbook();
ExcelBuilder.Sheet(wb, "Sheet1").Headers("A", "B").Data(data);
FormulaValidator.SaveWithEvaluation(wb, "output.xlsx");
协议
Apache-2.0。基于 ClosedXML。
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net11.0 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net11.0
- ClosedXML (>= 0.105.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.