Comments (2)
Check what column has a data type mismatch and then figure out why from the source Excel files.
Closing this since it seems to be more of a general programming help question which is better suited for sites like stackoverflow. Please reopen if you think there's an issue with ExcelDataReader.
from exceldatareader.
You are 100% correct. The issue involved merging the DataTable values dervied from iterating through my Excel source files. And the first source sheet I was reading was blank, only having column headers. Then my routine iterated to the second sheet, which had valid values. The inferred DataTable column values from that first sheet threw off things. Fixed that now. Appreciate your patience!
from exceldatareader.
Related Issues (20)
- ExcelDataReader not able to get references HOT 1
- DateTime incoherent value HOT 9
- Reading data as a string HOT 3
- Read data from specific column/row? HOT 1
- Extract text from big documents faster HOT 3
- Enumeration yielded no results HOT 1
- Suggestion for adding reading named range HOT 2
- "End of Central Directory record could not be found" Random Error during CreateReader HOT 1
- IExcelDataReader.AsDataSet() does not contains definition for AsDataSet HOT 1
- IExcelDataReader.Read() and .GetXXX() methods are so slow HOT 6
- Export Control Classification Number (ECCN) for the library
- How do I get data in a DataTable and/or Observablecollection? HOT 3
- Getting Null values when reading xlsb file using ExcelDataReader HOT 3
- XLSX link cell type HOT 1
- Getting Null values when Reading xlsb file HOT 1
- JObject.FromObject on xlsx file throws "Can not add Newtonsoft.Json.Linq.JProperty to Newtonsoft.Json.Linq.JProperty" HOT 1
- CSV File - Delimiter Between Quotes HOT 3
- How to read an excel file with linked data type HOT 2
- DotNet 8 Support HOT 1
- Error CS0426 The type name 'CreateReader' does not exist in the type 'ExcelReaderFactory' HOT 4
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.