How to use ExcelDataReader nuget for creating Excel File and Write

c# excel exceldatareader
Milind picture Milind · May 26, 2016 · Viewed 9.8k times · Source

can we use ExcelDataReader for creating excel sheet and writing into excel template. Or suggest any tool for the same

Answer

gpanagopoulos picture gpanagopoulos · Jul 4, 2016

You can use EPPLUS

However, please be aware that it does not handle .xls files (Excel 97-2003)

Related questions

Using ExcelDataReader to read Excel data starting from a particular cell

I am using ExcelDataReader to read data from my Excel workbook in C#. But structure of my Excel sheet is such that data to be read can start from any particular cell and not necessarily A1. Can any one Please …

Read More
ExcelDataReader.AsDataSet not working

I'm using ExcelDataReader v.2.1. library to read both xls and xlsx files in my C# project. This way: FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader; string extension = Path.GetExtension(filePath); if (extension == ".xls") { excelReader = ExcelReaderFactory.CreateBinaryReader(…

Read More
Excel Data Reader Issues, column Names, and Sheet Selection

I am using Excel Data Reader to read some data in to an Entity Framework Database The code below is working but i need some further refinements First of all IsFirstRowAsColumnNames does not seem to be working as intended and …

Read More