Exceldatareader example c#

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;
            }
        }

Source: alexcodetuts.com

Similar codes

0 vote231 views1 answer
Update listbox using class c#
C#
0 vote175 views1 answer
There is no implicit reference conversion from 'xxxx.Database.Domain.Entities.Order' to 'System.IDisposable'
C#
0 vote173 views1 answer
What function is called just before the a script is ended c#
C#
10 votes188 views1 answer
Unity c# get bool from another script
C#
89 votes234 views3 answers
How to generate random numbers in c#
C#
0 vote260 views1 answer
Unity Reverse string
C#Unity
1 vote170 views1 answer
Entity framework update child records
C#
0 vote130 views1 answer
Carousel in asp.net
C#
0 vote169 views1 answer
Internal working of ioc container c#
C#
0 vote185 views1 answer
Reference a class by string unity
C#