Comments (3)
The cell probably contains string.Empty value, not null value. How was this excel document saved? Was it created manually or generated by some tools?
Can you send a sample file?
from miniexcel.
@pszybiak I uploaded the file. The link is in the issue description. In the file you will also find the column Date with the same issue.
Good question. I can't tell you if the file was generated or created manually. I assume it was at least modified manually.
from miniexcel.
As I thought, an empty string is inserted in the specified fields.
Changing application behavior in this context can be difficult, because it may break the backward compatibility of the library.
We can introduce a modification that will convert the string.Empty value to NULL for types other than string (of course if this type can be NULL).
But how should the library behave with string fields? Leave the string.Empty value or change it to NULL? Or maybe we need to add an additional configuration option (an attribute on a field or a DynamicColumn), e.g. ReadEmptyStringAsNull. Or a global option like ReadEmptyStringAsNull for CSV files.
@shps951023 what do you think?
from miniexcel.
Related Issues (20)
- how to repeat table template in sheet
- OpenXml.SharedStringsDiskCache 析构函数导致的崩溃
- 希望 SaveAsByTemplate 可以指定模板里某一个 Sheet 进行数据填充 HOT 1
- Hope add support for update single cell in sheet
- 对于ExcelColumnAttribute的Index 属性,能否添加先排序 再填充?
- Query得到的结果会忽略掉空行,那么怎么知道真实的行号呢 HOT 1
- DynamicExcelColumn Configuration doesnt work for DataTable Objects
- Generating excel with datareader ignores DynamicExcelColumn "Ignore" property
- Query faild on specific xlsx file, throws ExcelColumnNotFoundException
- 怎么删除某一行呢? HOT 2
- C# 有现成的System.DateTime.FromOADate方法问什么不用,是有什么特殊处理吗? HOT 2
- DataTable和IDataReader 导出Excel的时候,ExcelColumnInfo没传递导致Format等属性无效(已有解决方案)
- dependency bug with `Portable.System.DateTimeOnly` HOT 1
- Merge async and not-async implementation HOT 6
- New benchmark
- Export image to custom template HOT 1
- Increase support to Async Xlsx write
- SaveAsByTemplate uses too much memory
- Generate Excel Worksheet from HTML
- 增加Excel 文件加密,解密的功能
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 miniexcel.