Hi All,
Can anyone tell me how to import data from an Excel sheet into a grid view in ASP.Net?
Can anyone tell me how to import data from an Excel sheet into a grid view in ASP.Net?
-
-
Your question is very vague...
The first thing that you're going to have to do is import the Excel sheet into your application.
Check out this article about Import Excel File to Dataset.
Or check out this article about Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database (this one actually refers to ASP.NET usage)
After that, you should be able to bind the GridView to the the desired table within the DataSet that you imported.
-Frinny
Comment