Comments (2)
As explained in other issues, unfortunately this is how dates are encoded.
You can manually convert them using the date features and DataType::as_date
function.
Line 750 in 75de8f2
from calamine.
As explained in other issues, unfortunately this is how dates are encoded. You can manually convert them using the date features and
DataType::as_date
function.Line 750 in 75de8f2
Thanks tafia. I think I did a poor job explaining the issue. Code is clearer than words, so I implemented my proposed fix, a test demonstrating the desired behavior, and created a pull request. I tried to keep the style of the existing code, but please let me know if you want anything changed!
from calamine.
Related Issues (20)
- Parse Integer Error from Excel files with empty `s` attributes
- 对于位数比较多的数据无法保证解析后的结果于默认解析器一致 HOT 1
- Ignoring Cell Formatting HOT 3
- Header in second row HOT 2
- Accessing raw string value of the cell (without Data enum)
- Would it be possible to provide an api that lets me know when a cell is hidden, so that I can easily work with hidden data as well?
- Memory error and panic on large Excel sheets HOT 1
- RangeDeserializerBuilder example does not works HOT 3
- Next release ETA? HOT 2
- Example Code from Readme Doesn't Work (no method named `ok_or`)
- Xlsx Chart Sheet Crash
- Reading rich text formatted cells HOT 1
- Garbled characters HOT 2
- Unable to get all formulas
- memory allocation error when reading xls files with merged regions HOT 4
- Error while attempting to read formulas from simple XLSX file
- bump quick-xml dependency HOT 1
- Strange failure to determine `string` dtype column in ODS sheet/file
- Reading Excel Table Documentation
- will it support wasm
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 calamine.