Comments (9)
嗯,可以的,也可以提供一个委托,根据当前数据来判断是否合法,下个版本加一下
from weihanli.npoi.
Issue Label Bot is not confident enough to auto-label this issue. See dashboard for more details.
from weihanli.npoi.
看源码里面,Setting里面只提供了开始行数StartRowIndex,可否在新增一个配置EndRowIndex,表示读取XLS的结束行,这样,可以就可以只读取需要的行数就可以了
from weihanli.npoi.
目前暂不支持数据验证,我之前遇到这种问题一般是导入成一个 list 之后再通过 LINQ 过滤不符合条件的数据,类型不对的数据可以配置 FluentAPI
通过 ColumnInputFormatter
来配置转换
from weihanli.npoi.
目前暂不支持数据验证,我之前遇到这种问题一般是导入成一个 list 之后再通过 LINQ 过滤不符合条件的数据,类型不对的数据可以配置
FluentAPI
通过ColumnInputFormatter
来配置转换
嗯,目前是用这个方法解决的,主要遇到很多表格,前面是表头,后面是表尾,中间是数据,能否给Setting加一个EndRowIndex,这样读取数据的时候,就只要标记范围内的数据?
from weihanli.npoi.
发布了一个新版本,现在是预览版 1.10.0-preview-20200912-144223
,你可以先试一下,没问题的话我再发布一个正式版
https://www.nuget.org/packages/WeihanLi.Npoi/1.10.0-preview-20200912-144223
- 增加了
EndRowIndex
最后一行(从0开始,会读取,包含在读取范围内) - FluentAPI 增加了
WithDataValidation
可以设置一个委托验证数据是否合法,如果不合法就不返回,可以参考单元测试
from weihanli.npoi.
感谢大佬,完美解决问题,可以发版了,感谢感谢
from weihanli.npoi.
好的,感谢反馈
from weihanli.npoi.
新版本发布了, fixed by #81
from weihanli.npoi.
Related Issues (20)
- List.Count in the method of ToEntityList<> HOT 2
- 数据校验 HOT 7
- 如何实现头部粗体或者不同的颜色的 HOT 4
- `ConfigProfile` feature request
- Hepler/CsvFileHelper.cs(71,13): error CS8652: The feature 'using declarations' is currently in Preview and *unsupported*. To use Preview features, use the 'preview' language version.
- .net core 2.1 的程序 引用该包后 docker编译不通过? HOT 14
- 依賴.net standard HOT 2
- ExcelHelper.ToEntityList<T> ,对象属性包含图片映射时,导入表格无图直接报错 HOT 3
- Add `ToEntities` return `IEnumerable<TEntity>`
- Word template export feature HOT 2
- Add maxColumns and removeEmptyRows parameters to ExcelHelper.ToDataTable() HOT 2
- Support duplicate column names and avoid System.Data.DuplicateNameException HOT 3
- sheetname问题 HOT 6
- ToEntityList 不支持以 Tab 分隔的 csv 文件 HOT 3
- 格式问题 HOT 1
- Open an exist excel and then modify or write to excelFile HOT 9
- 不能识别纯汉字的日期格式 HOT 4
- 中文乱码 HOT 8
- Excel导出超出65536行报错 Invalid row number (65536) outside allowable range (0..65535) HOT 5
- picture HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from weihanli.npoi.