SkyExcelHelper 1.0.0

Install-Package SkyExcelHelper -Version 1.0.0
dotnet add package SkyExcelHelper --version 1.0.0
<PackageReference Include="SkyExcelHelper" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SkyExcelHelper --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SkyExcelHelper, 1.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install SkyExcelHelper as a Cake Addin
#addin nuget:?package=SkyExcelHelper&version=1.0.0

// Install SkyExcelHelper as a Cake Tool
#tool nuget:?package=SkyExcelHelper&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

SkyExcelHelper

项目开源 GitHub URL:https://github.com/jkh404/SkyExcelHelper 这是一个Excel表格的帮助类,也是一个ORM,可以将实体类集合转为Excel表格数据 已经实现 List<T> ⇐==>ExSheet<T><===> DataTable 互相转换进而保存为Excel文件

简单样例:
	//User.cs
    [ExTable("会员用户表")]
    public class User
    {
        [ExPrimaryKey]
        [ExCol("ID")]
        public int id { get; set; }
        [ExCol("姓名")]
        public string Name { get; set; }
    }
        static void Main(string[] args)
        {
            ExWorkbook exWorkbook = ExcelHelper.CreateWorkBook("测试");
            ExSheet<User> UserSheet = exWorkbook.CreateSheet<User>("用户表");
            int ID = 0;
            UserSheet.Add(new User() { id = ID++, Name = "sky" })
                .Add(new User() { id = ID++, Name = "sky2" })
                .Add(new User() { id = ID++, Name = "sky3" })
                .Add(new User() { id = ID++, Name = "sky4" });
            List<User> users= UserSheet.ToList();
            DataTable UserTable=users.ToExSheet<User>().ToDataTable<User>();
            UserSheet.Submit().SaveToFile();

        }
结果:

最终结果图片

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
1.0.0 75 8/5/2021
0.9.0 100 8/5/2021