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
3
votes
2 answers

ExcelDataReader FilterColumn usage

I am trying to return a data set that returns the first row as the header row(this is working) as well as filter out entire columns from the data depending on their column header. ExcelDataReader 3.4.0 introduced the FilterColumn callback option…
Matt
  • 500
  • 7
  • 18
3
votes
1 answer

Get correct text display from excel with IExcelDataReader

tl;dr: How to get display text in excel file instead of value after convert to string. I have an Excel file from upload control, convert it to DataSet by IExcelDataReader and select a table in it. In some cases, I got incorrect value of string with…
tungns
  • 96
  • 1
  • 9
2
votes
0 answers

ExcelDataReader : I have 5 columns, the code creates one more "Column6": null . Any idea on how to avoid this or filter it?

I am using the following code- private static HashSet keepHeaders = new HashSet{ "Screen", "Section", "Question Name", "Question Label", "Question Type", "Required?", "Choice Group", "Min", "Max", "Max Length",…
jo_Veera
  • 293
  • 3
  • 12
2
votes
1 answer

get excel sheet row id using exceldatareader into dataset

I have chosen the ExcelDataReader Library for Reading the .XLS and .XLSX files using C#. ExcelDataReader is perfectly working with both file formats with my local and deployment server environment. I'm facing issue, how to get all the row id from…
Dinesh Patil
  • 104
  • 2
  • 8
2
votes
0 answers

C# ExcelDataReader.Exceptions.HeaderException: 'Invalid file signature.'

I am trying to read my excel file using the windows application that I am currently developing now. It consist of 8 headers and contains of almost 300 data value. If you know the solution please help me ;( And additional question, what nuget can I…
Alfredo Canonizado
  • 21
  • 1
  • 6
2
votes
1 answer

Set UseHeaderRow on ExcelDataReader AsDataSet ExcelDataSetConfiguration from F#

Using the ExcelDataReader within a F# project. To use the first row as Column names (headers) the configuration needs to be adjusted with the following C# code: var result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable =…
Titus
  • 41
  • 1
  • 4
2
votes
3 answers

Ignore specific columns from loading into the DataSet using ExcelDataReader?

I'm using ExcelDataReader to load the data into an DataSet, which will be eventually be loaded into an DataGrid in WPF. I have specific columns with headers as SLNO and FY which I don't want to include. How can I ignore those columns using…
Dante123
  • 45
  • 7
2
votes
1 answer

ExcelDataReader reading values like #N/A as string instead of NULL or missing while reading excel file

I'm using ExcelDataReader for reading .xlsx, .xls, .csv file while reading it treats everything as strings so a #N/A or #value! is also treated as a string and gives an exception when I try to do computation on them. FileStream stream =…
Maryam Dairkee
  • 137
  • 1
  • 6
2
votes
3 answers

Error for ExcelDataReader

I am doing a project in C# and I have downloaded ExcelDataReader from codeplex and added it to my project reference. There is an error in namespace 'using Excel;' though I have added Excel, Excel.4.5, Microsoft.Office.Interop.Excel to my project…
Rituja Nashikkar
  • 71
  • 1
  • 1
  • 7
2
votes
1 answer

How to extract link url from Excel cell

I have a c# webjob that downloads and then reads an Excel file. One of the columns contains links that I'd like to save in my database. I'm currently using ExcelDataReader to convert the Excel file to a DataSet and then looping through the rows to…
Alec Menconi
  • 735
  • 1
  • 16
  • 36
2
votes
4 answers

Read CSV files in C#

I have the following code that imports excel documents and parses them so I can manipulate the data before it is saved to the database. I can parse .xlsx and .xls files just fine but cannot figure out how to use my existing code for .csv files the…
Big Al Ruby Newbie
  • 69
  • 1
  • 2
  • 14
2
votes
1 answer

How to use ExcelDataReader nuget for creating Excel File and Write

can we use ExcelDataReader for creating excel sheet and writing into excel template. Or suggest any tool for the same
Milind
  • 437
  • 2
  • 9
  • 23
2
votes
1 answer

"ExcelReaderFactory.cs not found" Error

I've downloaded ExcelDataReader from the Visual Studio Package Manager Console and followed the C# instructions on its Code Plex page http://exceldatareader.codeplex.com/, but, during run-time, I get an "ExcelReaderFactory.cs not found" message when…
jle
  • 269
  • 8
  • 25
2
votes
2 answers

C# how to determine excel file version

I am using excel data reader, and I've noticed it is not compatible with older excel 5.0/95 workbook files. Is there a way I can get the version of the .xls file before I send it into excel data reader to prevent sending in earlier versions of excel…
Mitch
  • 389
  • 1
  • 6
  • 19
1
vote
2 answers

How to format datetime to date only with ExcelDataReader nuget while excel to csv conversion

I am using ExcelDateReader nuget package for converting excel file to csv but while conversion getting datetime instead of date. i want the date in dd/MM/yyyy format or yyyy-MM-dd format. but getting it in yyyy-MM-dd hh:mm:ss t format. Is there any…
shreyas35
  • 145
  • 9
1
2
3
…
9 10