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
0
votes
1 answer

Using exceldatareader to take data from excel file and paste it in a xml file?

I have some xml files in the format
Don_B
  • 243
  • 2
  • 15
0
votes
1 answer

Getting Excel sheetname and add them to comboBox

I am trying to add a feature into my application where users can choose the sheets from the comboBox. But I am hitting some bumps, I need some help! I was able to read the the excel file previously as I already sheet the default sheetname. But now I…
user9178291
0
votes
1 answer

ExcelDataReader ConfigureDataTable Error

I'm attempting to use .asDataSet() with a configuration: Dim x_config As New ExcelDataSetConfiguration Dim table_config As New ExcelDataTableConfiguration With { .UseHeaderRow = True …
dv3
  • 4,369
  • 5
  • 28
  • 50
0
votes
1 answer

How can I resolve a System.FormatException error on DateTime parsing when using ExcelDataReader.CreateReader()?

I receive an .xlsx file from a supplier and it contains a column for duration in HH:mm:ss format, which when I open the file in Excel appears as a date but should really just be a string. I would like to read this .xslx file into my c# application…
Dylan Finley
  • 3
  • 1
0
votes
1 answer

ExcelDataReader GetOrdinal method in .Net Core

ExcelDataReader with .NetCore 1.1 does not support GetOrdinal. Calling the GetOrdinal method results in an exception: 'Method is not supported' while (reader.Read()) { var id = reader.GetOrdinal("id"); ... } I believe the intent is…
Mohand Mokri
  • 75
  • 1
  • 8
0
votes
0 answers

ExcelDataReader AsDataSet method crashes with OutOfMemoryException

What's the best library to read Excel files, I used ExcelDataReader and it seems dealing only small sizes < 1mo. Any suggestion ?
Mirtov
  • 77
  • 11
0
votes
2 answers

Import multiple excel sheet into gridview using exceldatareader

currently I able to import an excel file into gridview by using exceldatareader library. Now, I want to further improve to import multiple excel sheet into gridview. This is the output I wish to do. ImageOutput I able to get the excel sheet name…
Weng Tan
  • 11
  • 5
0
votes
1 answer

c# importing excel to datagridview doesn't work

I am using ExcelDataReader here. I don't know why below code doesn't work. It doesn't generate any error but it still doesn't show excel data. It simply doesn't do anything after loading excel file. I am new to C# and after 5 hours of digging I feel…
F.j.Jason
  • 25
  • 2
  • 8
0
votes
1 answer

Can't read XLS files when i download them and try to open them in openfiledialog C#

So I am downloading some excel files from a service that calculates a day of a worker in this company when I download this file this comes up: Now I think everything alright, it should work fine. So here's the deal if I try and open this file in my…
Robbe De Clercq
  • 3
  • 5
0
votes
1 answer

Excel cell format [$-10409]m-d-yyyy h:mm:ss AM/PM

I have a c# application where data is read from an MS excel file. The excel cell format is [$-10409]m-d-yyyy h:mm:ss AM/PM I am using ExcelDataReader from NuGet to read data from the excel file. var file = new FileInfo(strFilePath); using…
Sobhan
  • 796
  • 1
  • 9
  • 31
0
votes
1 answer

ExcelDataReader - What is the Data Reader Methods Section Used For?

Forum. Referencing: https://github.com/ExcelDataReader/ExcelDataReader C# code : FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); //1. Reading from a binary Excel file ('97-2003 format; *.xls) IExcelDataReader excelReader =…
HappyCoding
  • 641
  • 16
  • 36
0
votes
0 answers

ExcelDataReader Error on Web Server - Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))

I am attempting to write results of records being updated to an Excel file using ExcelDataReader after each successful update. Currently, the functionality works fine on my machine running thru Visual Studio, however, once this same functionality…
MTL323
  • 177
  • 3
  • 14
0
votes
3 answers

Error 115 Type 'Excel.IExcelDataReader' is not defined

I have a vb.net application with excel export and import. I am not much familiar with this application as my ec-colleague left this to me without much information. Now when i am trying to build the application its showing the following error Error …
TechNo
  • 615
  • 2
  • 7
  • 24
0
votes
1 answer

Read openoffice ods file using CreateOpenXmlReader in C#

I'm looking for a library which will read all types of excel formats(eg:.xsl,.xlsx,.ods) I tried the The following code to read the spreadsheets. try { string extension =…
Tom Cruise
  • 1,395
  • 11
  • 30
  • 58
0
votes
2 answers

Where to keep data from excel file before saving it in database?

I've got an issue with my app. Using a form, user can choose an excel file to populate some table in database. I validate data before saving it and show the table with some validation messages. I also presents whole data from excel. Here's my…
WaltLift0
  • 43
  • 1
  • 5
1 2 3
…
9
10