Comments (9)
WeihanLi
commented on August 26, 2024
1
嗯，可以的，也可以提供一个委托，根据当前数据来判断是否合法，下个版本加一下
from weihanli.npoi.
issue-label-bot
commented on August 26, 2024
Issue Label Bot is not confident enough to auto-label this issue. See dashboard for more details.
from weihanli.npoi.
crashsol
commented on August 26, 2024
看源码里面，Setting里面只提供了开始行数StartRowIndex，可否在新增一个配置EndRowIndex，表示读取XLS的结束行，这样，可以就可以只读取需要的行数就可以了
from weihanli.npoi.
WeihanLi
commented on August 26, 2024
目前暂不支持数据验证，我之前遇到这种问题一般是导入成一个 list 之后再通过 LINQ 过滤不符合条件的数据，类型不对的数据可以配置 FluentAPI 通过 ColumnInputFormatter 来配置转换
from weihanli.npoi.
crashsol
commented on August 26, 2024
目前暂不支持数据验证，我之前遇到这种问题一般是导入成一个 list 之后再通过 LINQ 过滤不符合条件的数据，类型不对的数据可以配置
FluentAPI通过ColumnInputFormatter来配置转换
嗯，目前是用这个方法解决的，主要遇到很多表格，前面是表头，后面是表尾，中间是数据，能否给Setting加一个EndRowIndex，这样读取数据的时候，就只要标记范围内的数据？
from weihanli.npoi.
WeihanLi
commented on August 26, 2024
发布了一个新版本，现在是预览版 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.
crashsol
commented on August 26, 2024
感谢大佬，完美解决问题，可以发版了，感谢感谢
from weihanli.npoi.
WeihanLi
commented on August 26, 2024
好的，感谢反馈
from weihanli.npoi.
WeihanLi
commented on August 26, 2024
新版本发布了， 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.