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

5 votes300 views3 answers
Substring c# after character
C#
1 vote282 views1 answer
How to not overwrite a text file in c#
C#
9 votes296 views2 answers
How to change textMesh Pro unity
C#
0 vote290 views1 answer
Validate base64 string c#
C#
3 votes257 views2 answers
Unity mouse click m
C#
0 vote281 views1 answer
Mouselook script unity
C#
0 vote315 views1 answer
C# webbrowser control append
C#
0 vote287 views1 answer
Linq c# object except two lists
C#
5 votes285 views2 answers
Vscode c# how to change to externial terminal
C#
1 vote318 views1 answer
How to get object to spawn in a curcle
C#