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

Take contents of an excel file (.xls or .xlsx) in to Dataset

i have an excel file named test.xls and i want to get the contents in the excel sheet into a Dataset.Is it possible i tried a code but it throws exception,here is my code string FilePath = Server.MapPath("portals\\_default") + "\\" +…
Anilkumar
  • 85
  • 4
  • 14
0
votes
1 answer

Read xls/xlsx and display on screen

I'm using 'ExcelDataReader' to read in an Excel file, I want to display the file on screen. protected void Page_Load(object sender, EventArgs e) { string filePath = @"C:\WORK\BoireannSVN\trunk\VS\CRCConnect\Spreadsheet\Spreadsheet.xlsx"; …
John
  • 3,965
  • 21
  • 77
  • 163
0
votes
3 answers

Refresh external data in Excel 2010 while the file is open in the background but not in use

I am using Excel 2010 to query MS SQL databases and other Excel files to import data. I have set different intervals for each data connection (10 connections). In excel this data is sliced and diced to create meaningful charts which are presented in…
hoz
  • 502
  • 2
  • 9
  • 25
-1
votes
1 answer

ExcelDataReader, can't read "html-format" file

I have the following code: MemoryStream ms = new MemoryStream(); using (var fileStream = File.OpenRead("G:\\tmp\\abc.xls")) { fileStream.CopyTo(ms); } var reader =…
Oleg Sh
  • 8,496
  • 17
  • 89
  • 159
-1
votes
2 answers

How to Update an Excel Reader without using an openfiledialog C#

I've probably worded the question wrongly but it is easier to explain. Basically on my form I have a button where if you click it, it opens up an OpenFileDialog search box and you are able to open an excel file and it gets displayed on various…
D McCracken
  • 33
  • 1
  • 8
-1
votes
2 answers

ExcelDataReader : Import XLSX file without parsing it into {System.DateTime} object

I am using http://exceldatareader.codeplex.com/. I have an Excel file with a column having dates i.e. D/M/Y. I am trying to read this file using this code: FileStream stream = File.Open(FilePath, FileMode.Open, FileAccess.Read); IExcelDataReader…
Awais
  • 319
  • 3
  • 13
1 2 3
…
9
10