Comments (6)
Hi,
Can you give us any info about the file and your environment? Obviously this is not as intended.
from exceldatareader.
On windows 11, Microsoft Excel version 2309 Build 16.0.16827.20166, 64-bit
from exceldatareader.
That's not enough information.
from exceldatareader.
Tried the open/read of the same excel data file using the AsDataSet() method, it is blazing fast.
so, there is issue with the reader.Read() method.
from exceldatareader.
Ok, I was using the reader.Read() method to read the .xlsx file, not the binary .xls file. So, maybe that is why it was slow? It worked though, just slow. I see the comment in the sample code saying OpenXml is used for xlsx files and the reader.Read() for the older .xls file.
from exceldatareader.
AsDataSet is just a helper method that uses the reader implementation so it cannot be faster.
Most likely the issue lies in your code.
from exceldatareader.
Related Issues (20)
- Blazor Input File: Specified method not supported exception thrown HOT 1
- ExcelDataReader reading partial data from .xlsb file in .net 6 HOT 4
- 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
- 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
- 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
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 exceldatareader.