how to convert .xls to Datatable in C#

Posted by Gayathri under ASP.NET on 9/11/2012 | Points: 10 | Views : 3277 | Status : [Member] | Replies : 3
Please help


How to convert .xls to C#
i dnot want to use any third party dll for this.
need an easy coding to implement this.




Responses

Posted by: Sheonarayan on: 9/11/2012 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Gayathri,

This article of mine has the answer of your question http://www.dotnetfunda.com/articles/article1954-how-to-read-ms-excel-file-and-populate-into-gridview.aspx.

Hope this is what you are looking for.

Thanks

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

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

Posted by: Gayathri on: 9/11/2012 [Member] Starter | Points: 25

Up
0
Down
thanks for the reply. what if ,if i donot know the sheet name?
i am taking itout dynamically


Kindly clarify

also i need the same for a txt file.

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

Posted by: Megan00 on: 9/11/2012 [Member] Starter | Points: 25

Up
0
Down
hello you can use a free source: Free Data Export component to export xls.
http://www.e-iceblue.com/Introduce/free-dataexport-component.html

Never give up! Smile to the world!
http://excelcsharp.blog.com/

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

Login to post response