How to fetch line by line (row wise) data from excel file in c# using ExcelDataReader

Question

I want to fetch data row wise from excel file.

Please find Image for Sample data.

I want to fetch this data row wise using ExcelDataReader. Is there a way of doing it?

Sample Imageack.imgur.com/jCSnx.png

using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream))
{
    DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration()
    {
        ConfigureDataTable = (_) => new ExcelDataTableConfiguration()
        {
            UseHeaderRow = true
        }
    });
}

I am trying this code to fetch data. But it gives me 1st row as column header and then prints all the data same as it is.

Is there any code you've tried? – Dumisani Feb 13 '20 at 13:29 — Dumisani, Feb 13 '20 at 13:29
yes, i 've updated the ques – Kushagra Verma Feb 13 '20 at 13:39 — Kushagra Verma, Feb 13 '20 at 13:39

score 0 · Answer 1 · answered Feb 13 '20 at 13:49

0

You can get the first sheet as a DataTable by using result.Tables[0] then loop through the DataTable's rows. result.Tables is a collection of sheets inside your workbook.

using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream))
{
    DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration()
    {
        ConfigureDataTable = (_) => new ExcelDataTableConfiguration()
        {
            UseHeaderRow = true
        }
    });

    DataTable dataTable = result.Tables[0];
    foreach(var row in dataTable.Rows)
    {
        //Your logic
    }
}

answered Feb 13 '20 at 13:49

Dumisani

2,988
1
29
40

Thanks Dumisani :) – Kushagra Verma Feb 13 '20 at 18:31
You're welcome @KushagraVerma. Please mark as answer if it solved your problem, thanks. – Dumisani Feb 14 '20 at 06:37

How to fetch line by line (row wise) data from excel file in c# using ExcelDataReader

1 Answers1