Breaking News: Grepper is joining You.com. Read the official announcement!

exceldatareader example c#

Worrisome Weasel answered on January 28, 2022 Popularity 9/10 Helpfulness 4/10

answer exceldatareader example c#

exceldatareader example c#

Comment

1
private void btnBrowse_Click(object sender, EventArgs e)
        {
            this.openFileDialog1.Filter = "Excel Files(.xlsx)|*.xlsx";
            this.openFileDialog1.Title = "Select an excel file";
            if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                this.txtPath.Text = openFileDialog1.FileName;
                FileStream stream = File.Open(openFileDialog1.FileName, FileMode.Open, FileAccess.Read);
                IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
                DataSet result = excelReader.AsDataSet();
 
                var people = new List&amp;amp;lt;Person&amp;amp;gt;();
                while (excelReader.Read())
                {
                    people.Add(new Person
                    {
                        FirstName = excelReader.GetString(0),
                        LastName = excelReader.GetString(1)
                    });
                }
 
                this.resultGrid.DataSource = people;
            }
        }

Popularity 9/10 Helpfulness 4/10 Language csharp

Source: alexcodetuts.com

Tags: c# exceldatareader

Link to this answer
Share Copy Link

Contributed on Jan 28 2022

Worrisome Weasel

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

exceldatareader example c#

Contents

More Related Answers

exceldatareader example c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.