WeihanLi.Npoi 1.7.0 更新介紹

Intro

昨天晚上發布了 WeihanLi.Npoi 1.7.0 版本，增加了 ColumnInputFormatter/ ColumnOutputFormatter，又進一步增強了導入導出的靈活性，來看下面的示例

ColumnInputFormatter/ColumnOutputFormatter

示例 Model:

internal abstract class BaseEntity {public int PKID { get; set; } } internal class TestEntity : BaseEntity {public Guid SettingId { get; set; }public string SettingName { get; set; }public string DisplayName { get; set; }public string SettingValue { get; set; }public string CreatedBy { get; set; } = "liweihan";public DateTime CreatedTime { get; set; } = DateTime.Now;public string UpdatedBy { get; set; }public DateTime UpdatedTime { get; set; }public bool Enabled { get; set; } }

示例配置：

var setting = ExcelHelper.SettingFor<TestEntity>(); // ExcelSetting setting.HasAuthor("WeihanLi").HasTitle("WeihanLi.Npoi test").HasDescription("WeihanLi.Npoi test").HasSubject("WeihanLi.Npoi test"); setting.HasSheetConfiguration(0, "SystemSettingsList", 1, true); // setting.HasFilter(0, 1).HasFreezePane(0, 1, 2, 1); setting.Property(_ => _.SettingId).HasColumnIndex(0); setting.Property(_ => _.SettingName).HasColumnTitle("SettingName").HasColumnIndex(1); setting.Property(_ => _.DisplayName).HasOutputFormatter((entity, displayName) => $"AAA_{entity.SettingName}_{displayName}").HasInputFormatter((entity, originVal) => originVal.Split(new[] { '_' })[2]).HasColumnTitle("DisplayName").HasColumnIndex(2); setting.Property(_ => _.SettingValue).HasColumnTitle("SettingValue").HasColumnIndex(3); setting.Property(_ => _.CreatedTime).HasColumnTitle("CreatedTime").HasColumnIndex(4).HasColumnWidth(10).HasColumnFormatter("yyyy-MM-dd HH:mm:ss"); setting.Property(_ => _.CreatedBy).HasColumnInputFormatter(x => x += "_test").HasColumnIndex(4).HasColumnTitle("CreatedBy"); setting.Property(x => x.Enabled).HasColumnInputFormatter(val => "啟用".Equals(val)).HasColumnOutputFormatter(v => v ? "啟用" : "禁用"); setting.Property("HiddenProp").HasOutputFormatter((entity, val) => $"HiddenProp_{entity.PKID}"); setting.Property(_ => _.PKID).Ignored(); setting.Property(_ => _.UpdatedBy).Ignored(); setting.Property(_ => _.UpdatedTime).Ignored();

測試代碼：

var entities = new List<TestEntity>() {new TestEntity(){PKID = 1,SettingId = Guid.NewGuid(),SettingName = "Setting1",SettingValue = "Value1",DisplayName = "ddd1"},new TestEntity(){PKID=2,SettingId = Guid.NewGuid(),SettingName = "Setting2",SettingValue = "Value2",Enabled = true}, }; var path = $@"{tempDirPath}\test.xlsx"; entities.ToExcelFile(path); var entitiesT0 = ExcelHelper.ToEntityList<TestEntity>(path);

導出結果：

導入結果：

More

新版本發布，快來嘗鮮吧~

ColumnInputFormatter 結合之前的 InputFormatter/ OutputFormatter 能夠幫助你更靈活的導入導出，快來試試吧~~

Reference

• https://github.com/WeihanLi/WeihanLi.Npoi

• https://github.com/WeihanLi/WeihanLi.Npoi/blob/dev/samples/DotNetCoreSample/Program.cs

• https://www.nuget.org/packages/WeihanLi.Npoi/

總結

以上是生活随笔為你收集整理的WeihanLi.Npoi 1.7.0 更新介绍的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。