ExcelPatternTool.Core 0.3.1

.NET 6.0

dotnet add package ExcelPatternTool.Core --version 0.3.1

NuGet\Install-Package ExcelPatternTool.Core -Version 0.3.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="ExcelPatternTool.Core" Version="0.3.1" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add ExcelPatternTool.Core --version 0.3.1

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: ExcelPatternTool.Core, 0.3.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.

// Install ExcelPatternTool.Core as a Cake Addin
#addin nuget:?package=ExcelPatternTool.Core&version=0.3.1

// Install ExcelPatternTool.Core as a Cake Tool
#tool nuget:?package=ExcelPatternTool.Core&version=0.3.1

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

ExcelPatternTool.Core

开箱即用的应用程序包，*不需要编写pattern.json，指定一个C#类即可立即开始

*若验证Excel需要指定pattern.json

快速开始

在项目中引用ExcelPatternTool.Core

dotnet add package ExcelPatternTool.Core

从Excel导入

Importer import = new Importer();
import.LoadXlsx(File.ReadAllBytes(filePath));   //导入xlsx文件
// or
import.LoadXls(File.ReadAllBytes(filePath));    //或导入xls文件
var importOption = new ImportOption<T>(0, 0);
var result = import.Process<T>(importOption).ToList()

Console.WriteLine(result);      //导入完成！

导出Excel

IList<T> src = ...  //准备数据


Exporter exporter = new Exporter();
exporter.DumpXlsx(filePath);    //导出xlsx文件
// or
exporter.DumpXls(filePath);     //或导出xls文件
var exportOption = new ExportOption<T>(0, 0);
var issuccess = exporter.Process(src, exportOption);

使用说明

编辑你的C#类，此类将作为ExcelPatternTool导入导出功能的承载实体类型，继承自IExcelEntity

常规类型

可定义 string， DateTime，int，double，bool

EF标签

若涉及数据库导入导出，请使用Table标签指定表名称，使用Key标签指定主键类型，无键实体类型请使用Keyless 详情请参考EFCore官方文档https://docs.microsoft.com/zh-cn/ef/core/modeling/

ImportableAttribute

Order 列序号为此列在Excel中的编号，从0开始，即A列对应0，B列对应1 ...
Ignore 为True时将忽略这一列，等效于ExcelEntity无此属性

ExportableAttribute

Order 列序号为此列在Excel中的编号，从0开始，即A列对应0，B列对应1 ...
Name 列名称，将指定导出时的该列第一行名称
Ignore 为True时将忽略这一列，等效于ExcelEntity无此属性

Format 指定单元格格式，对应的值有

"General",
"0",
"0.00",
"#,##0",
"#,##0.00",
"\"$\"#,##0_);(\"$\"#,##0)",
"\"$\"#,##0_);[Red](\"$\"#,##0)",
"\"$\"#,##0.00_);(\"$\"#,##0.00)",
"\"$\"#,##0.00_);[Red](\"$\"#,##0.00)",
"0%",
"0.00%",
"0.00E+00",
"# ?/?",
"# ??/??",
"m/d/yy",
"d-mmm-yy",
"d-mmm",
"mmm-yy",
"h:mm AM/PM",
"h:mm:ss AM/PM",
"h:mm",
"h:mm:ss",
"m/d/yy h:mm",
"#,##0_);(#,##0)",
"#,##0_);[Red](#,##0)",
"#,##0.00_);(#,##0.00)",
"#,##0.00_);[Red](#,##0.00)",
"_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)",
"_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)",
"_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)",
"_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)",
"mm:ss",
"[h]:mm:ss",
"mm:ss.0",
"##0.0E+0",
"@"

Type: 单元格类型， Exportable中可指定Type类型的为

值含义

Any 自定义

Text 文本

Numeric 数值

Date 时间

Bool 布尔值

值	含义
`Any`	自定义
`Text`	文本
`Numeric`	数值
`Date`	时间
`Bool`	布尔值

高级类型

ExcelEntity中的属性为常规类型时，直接输出的为单元格值；属性为AdvancedType类型时，导入时将读取单元格细节，导出至Excel时，将保留这些细节导出。高级类型有："包含注解"，"包含样式"，"包含公式"，"全包含"类型

CommentedType<>: 包含注解的对象，泛型中的类型同"常规类型"
StyledType<>: 包含样式的对象，泛型中的类型同"常规类型"
FormulatedType<>: 包含公式的对象，泛型中的类型同"常规类型"
FullAdvancedType<>: 全包含对象，泛型中的类型同"常规类型"

Sample：

    [Keyless]
    [Table("EmployeeEntity")]
    public class EmployeeEntity : IExcelEntity
    {

        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Exportable(ignore: true)]
        public Guid Id { get; set; }

        [Exportable(ignore: true)]
        [Importable(ignore: true)]
        public long RowNumber { get; set; }
        [DisplayName("常规")]
        [Exportable("常规")]
        [Importable(0)]
        public string StringValue { get; set; }
        [DisplayName("日期")]
        [Exportable("日期")]
        [Importable(1)]
        public DateTime DateTimeValue { get; set; }

        [DisplayName("整数")]
        [Exportable("整数")]
        [Importable(2)]
        public int IntValue { get; set; }

        [DisplayName("小数")]
        [Exportable("小数")]
        [Importable(3)]
        public double DoubleValue { get; set; }


        [DisplayName("布尔值")]
        [Exportable("布尔值")]
        [Importable(4)]
        public bool BoolValue { get; set; }

        [DisplayName("常规(注释)")]
        [Exportable("常规(注释)")]
        [Importable(5)]
        public CommentedType<string> StringWithNoteValue { get; set; }

        [DisplayName("常规(样式)")]
        [Exportable("常规(样式)")]
        [Importable(6)]
        public StyledType<string> StringWithStyleValue { get; set; }


        [DisplayName("公式")]
        [Exportable("公式")]
        [Importable(10)]
        public FormulatedType<int> IntWithFormula { get; set; }
    }

工具

Roslyn Syntax Tool

此工具能将C#代码，转换成使用语法工厂构造器（SyntaxFactory）生成等效语法树代码

已知问题

作者信息

作者：林小

邮箱：jevonsflash@qq.com

License

The MIT License (MIT)

Product	Compatible and additional computed target framework versions.
.NET	net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net6.0
- ExcelPatternTool.Common (>= 0.3.1)
- ExcelPatternTool.Contracts (>= 0.3.1)
- Microsoft.CodeAnalysis.Common (>= 4.7.0)
- Microsoft.CodeAnalysis.CSharp (>= 4.7.0)
- Microsoft.Extensions.Configuration.Json (>= 7.0.0)
- Newtonsoft.Json (>= 13.0.3)
- NPOI (>= 2.6.2)
- SixLabors.ImageSharp (>= 2.1.6)
- SixLabors.ImageSharp.Drawing (>= 1.0.0)
net7.0
- ExcelPatternTool.Common (>= 0.3.1)
- ExcelPatternTool.Contracts (>= 0.3.1)
- Microsoft.CodeAnalysis.Common (>= 4.7.0)
- Microsoft.CodeAnalysis.CSharp (>= 4.7.0)
- Microsoft.Extensions.Configuration.Json (>= 7.0.0)
- Newtonsoft.Json (>= 13.0.3)
- NPOI (>= 2.6.2)
- SixLabors.ImageSharp (>= 2.1.6)
- SixLabors.ImageSharp.Drawing (>= 1.0.0)

NuGet packages (1)

Showing the top 1 NuGet packages that depend on ExcelPatternTool.Core:

Package	Downloads
ExcelPatternTool.Validation Out-of-the-box Excel toolkit with NPOI, No need to write pattern.json, specify a C# class to start immediately	350

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last updated
0.3.1	280	10/24/2023
0.3.0	129	10/24/2023
0.2.0	114	10/19/2023
0.1.2	95	10/19/2023
0.1.1	304	8/8/2022

1. 更新引用库，使用SixLabors.ImageSharp替换System.Drawing以兼容Linux 2. 升级项目框架到 .Net 7.0

Total 922

Current version 280

Per day average 1