How to read excel file using C# [duplicate]

Question

I have tried this code but it doesn't work:

private void Load_Button_Click(object sender, EventArgs e)
{
    using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel Workbook|*.xls", ValidateNames = true })
    {
        if (ofd.ShowDialog() == DialogResult.OK)
        {
             System.IO.FileStream fs = File.Open(ofd.FileName, System.IO.FileMode.Open, FileAccess.Read);
             ExcelDataReader.IExcelDataReader reader = ExcelDataReader.ExcelReaderFactory.CreateBinaryReader(fs);
             reader.IsFirstRowAsColumnNames = true;
             result = reader.AsDataSet();
             cboSheet.Items.Clear();

             foreach (DataTable dt in result.Tables)
                 cboSheet.Items.Add(dt.TableName);

             reader.Close();    
         }
     }
}

I can't seem to run this code because the IsFirstRowAsColumnNames and AsDataSet has red underlines.

I found the code here https://www.youtube.com/watch?v=7X3fTnuII7c

you can use answer here: stackoverflow.com/questions/15828/… — Plasmazion
– Plasmazion, Commented Aug 10, 2017 at 9:28

DavidG · Accepted Answer · 2017-08-10 09:28:34Z

2

From the instructions for the library:

Install the ExcelDataReader.DataSet extension package to use the AsDataSet() method to populate a System.Data.DataSet.

So you need an additional library here.

The IsFirstRowAsColumnNames property doesn't exist at all, perhaps it's a legacy item that has been removed. Instead, it looks like you need to pass in configuration to the AsDataSet method, for example:

ds = reader.AsDataSet(new ExcelDataSetConfiguration()
{
    ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration()
    {
        UseHeaderRow = true
    }
});

answered Aug 10, 2017 at 9:28

DavidG

120k13 gold badges232 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tramyer Over a year ago

I have already installed this. Still it's not working. I'm a beginner in C# programming . I kinda stuck again XD

DavidG Over a year ago

Read the instructions for the library.

Tramyer Over a year ago

Currently reading it. i hope i could find the key.

Collectives™ on Stack Overflow

How to read excel file using C# [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related