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 vote185 views1 answer
C# propertyinfo indexof
C#
7 votes135 views2 answers
C# mapper.map
C#
9 votes149 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string); the really long string variable is a string in which a very long string is stored.
C#
0 vote144 views1 answer
Check dotnet version command line
C#
0 vote131 views1 answer
.Net Core Bundling & minification 02 : .net core The name 'Scripts' does not exist in the current context
C#
16 votes120 views2 answers
Movetowards unity
C#Unity
0 vote186 views1 answer
Unity slider not empty
C#Unity
0 vote197 views1 answer
Unity iterate all child objects
C#Unity
1 vote148 views1 answer
Creating a button Dynamically c# winform
C#
0 vote143 views2 answers
DWGExportOptions
C#