Hi friends, in this article I will explain about how to read the data from excel in VB.NET or C# windows Forms.
I searched so many sites and finally get the solution of how
to read the data from excel in VB.NET or C# windows Forms.You can know the How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime in the next article How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime
For this first we have to add the reference Microsoft.Office.Interop.Excel.
Menu—project—Add reference—COM—Microsoft Excel 12.0 Object Library
Next come to code and imports or using Microsoft.Office.Interop.Excel