Stack Overflow
Stack Overflow

Questions tagged [exceldatareader]

Questions about ExcelDataReader, a .NET library for reading Microsoft Excel files. When using this tag, also tag the question with the programming language being used unless your question is not specific to any programming language.

ExcelDataReader is a lightweight and fast .NET library written in C# for reading Microsoft Excel (97 and newer) files.

Cross-platform:

  • Windows with .Net Framework 2
  • Windows Mobile with Compact Framework
  • Linux, OS X, BSD with Mono 2+

Project page at CodePlex: http://exceldatareader.codeplex.com/

Latest sources available at GitHub: https://github.com/ExcelDataReader/ExcelDataReader

For more information read its Read-Me file at GitHub.

141 questions
1
vote
2 answers

How to read xls file in c#?

Net core API. I am trying to read xls file using ExcelDataReader. In ExcelDataReader I do not want to pass file path but I want to pass stream. I tried below [HttpPost("import")] public async Task Import(IFormFile formFile) { …
Niranjan godbole
  • 721
  • 3
  • 13
  • 28
1
vote
1 answer

ExcelDataReader Problem with 1252 Encoding

I'm just getting started with Xamarin development in Visual Studio 2022 Preview. I'm working on an app that reads Excel or CSV files, for which I have elected to use ExcelDataReader. Despite following the guidelines to add support for CodePages as…
RogerB
  • 222
  • 3
  • 11
1
vote
0 answers

Azure Pipline issue- ExcelDataReader Not found used by Specflow External Data Package

I am using Specflow External Data for data input in my Specflow Tests. I have my .xsl file as a DataSource for the Feature files located in the same Feature Folder. It is running fine on my local machine but when integrated to Azure DevOps Pipeline,…
PriyadarshaniPPatil
  • 11
  • 2
1
vote
1 answer

ExcelDataReader not working in Class Library project

Receiving the following error when trying to run a Server Process, class library project: "ERROR : Error (0) Could not load file or assembly 'ExcelDataReader, Version=3.6.0.0, Culture=neutral, PublicKeyToken=93517dbe6a4012fa' or one of its…
LearningStuff
  • 9
  • 2
1
vote
0 answers

Python program for iteration based on multiple criterias

i'm new to Python, need Experts support to get output 1 & output 2 based on attached Input Can somebody help me to complete the below python code, need output 1 and Output 2 in separate…
PyDev
  • 11
  • 1
1
vote
1 answer

ExcelDataReader changing columns name

I am reading an Excel file using ExcelDataReader Dim entireExcel As DataTableCollection Using ofd As OpenFileDialog = New OpenFileDialog() With {.Filter = "Excel Workbook|*.xlsx|Excel 97-2003 Workbook|*.xls"} If ofd.ShowDialog() =…
Florin
  • 375
  • 3
  • 13
1
vote
1 answer

How to get the contents a particular cell using excel data reader in Visual Basic? Using ExcelData Reader

I'm using the following code and I'm trying to understand how to access the content of each cell in the excel document in order to Validate it... but everything that I've found on the internet is in C# I tried to translate it but I'm getting some…
armando t
  • 131
  • 1
  • 4
  • 13
1
vote
1 answer

ExcelDataReader - Get index of currently read row

I'm using ExcelDataReader to read .xlsx files. using (var reader = ExcelReaderFactory.CreateReader(stream)) { for (bool canRead = true; canRead; canRead = reader.NextResult()) { //reader.Read(); many times } } How to get the…
havon
  • 21
  • 3
1
vote
1 answer

The type or namespace name could not be found in MSBuild but works in Visual Studio

I'm trying to build my multi-project solution from the dotnet CLI, but one project throws error CS0246. I have no problems building it from Visual Studio. The error is encountered on line 1 in the file using the NuGet package that is causing the…
Zebrastian
  • 421
  • 2
  • 7
  • 18
1
vote
0 answers

C# - Add Empty Column to DataTable

I am creating an Excel using DataTable. My requirement is to skip first two columns and populate values from third column. When I try to add column with string.Empty, it creates Column1,Column2 in Excel. As per link…
Tech Learner
  • 1,227
  • 6
  • 24
  • 59
1
vote
1 answer

how to keep the datetimeformat of excel.cell into dataset cell

Having some hard time understanding the conversion between excel file to .net object type such as DataSet or DataTable. One issue I see in this 3rd party library (and the issue still lingers in the latest I believe) called ExcelDataReader is its…
swcraft
  • 2,014
  • 3
  • 22
  • 43
1
vote
2 answers

I get a "Specified method is not supported" error when i try to use ExcelDataReader to upload file to database

I've written a method, BulkCopy, to upload my Excel file to SQL Server database table. I am trying to unit test this and it fails each time with "System.NotSupportedException : Specified method is not supported". If someone could have a look it…
Barrassment
  • 75
  • 1
  • 7
1
vote
0 answers

How to read the header row (assuming first row is header) in excel without loading entire excel file

I am combining multiple large excel files with different columns and number of columns. Before starting to combine, I want to collect all header rows in order to make a data table which having all columns in advance. I know that there is a method…
user3819222
  • 127
  • 8
1
vote
1 answer

how to read textbox data in xlsx file using python

I have an excel file and I am having data in textbox of the sheet. I want to extract the data from that textbox. I did search all possible modules that I can find in python to parse but nothing is helping here. Is it a bug that needs to be fixed or…
Kishan
  • 197
  • 1
  • 1
  • 6
1
vote
1 answer

Unsupported encoding while parsing excel

I use the following code to open an Excel file using ExcelDataReader. excelReader = ExcelReaderFactory.CreateReader(stream, new ExcelReaderConfiguration() { FallbackEncoding = Encoding.UTF8, LeaveOpen =…
user6038900
1 2
3
…
9 10