Read and Import Excel File into DataSet or DataTable using C# in ASP.Net

Posted by Naidulaxmi under ASP.NET on 9/9/2014 | Points: 10 | Views : 12099 | Status : [Member] | Replies : 2
Hi friends,


How to implement this task that is Read and Import Excel File into DataSet or DataTable using C# and VB.Net in ASP.Net.


Plz send me this task code ,

Thanks,

appalanaidu


Responses

Posted by: Sheonarayan on: 9/10/2014 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Naidu,

Visit this article of mine http://www.dotnetfunda.com/articles/show/1954/how-to-read-ms-excel-file-and-populate-into-gridview

There is one more way to do that, read about it http://www.dotnetfunda.com/articles/show/1370/reading-opening-excel-file-in-csharp-using-microsoftofficeintropexcel.

Hope this will help.

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Naidulaxmi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Yesi on: 12/26/2014 [Member] Starter | Points: 25

Up
0
Down
Import Excel to DataSet:
http://stackoverflow.com/questions/18006318/how-to-import-all-the-excel-sheets-to-dataset-in-c-sharp
Read Excel to DataTable:
http://www.codeproject.com/Questions/445400/Read-Excel-Sheet-Data-into-DataTablehttp://www.codeproject.com/Questions/445400/Read-Excel-Sheet-Data-into-DataTable
And this may help:
http://www.gemboxsoftware.com/support/articles/import-export-dataset-xls-xlsx-ods-csv-html-net
Or you can use free interface for .net http://www.e-iceblue.com/Introduce/data-export-for-net-intro.html .

Naidulaxmi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response