Uploading Excel file in Windows Forms using C#

Posted by Santhoshalla under WPF on 2/11/2013 | Points: 10 | Views : 9232 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to upload excel files n Win Forms
and store excel data in datatable

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Santhoshalla on: 2/11/2013 [Member] Starter | Points: 25

0	How to upload xls files in Windows Forms in windows how to upload xls files Santhoshalla, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Grdon on: 2/19/2013 [Member] Starter | Points: 25

0	Hi, It is easy to work with excel in .Net if you use 3rd party components. For example look at this C# code by using http://www.eleriumsoft.com/Excel_NET/ExcelReader/: string xlload = @"d:\Tutorials.xls"; ExcelWorkbook Wbook = ExcelWorkbook.ReadXLS(xlload); ExcelWorksheet Wsheet = Wbook.Worksheets[0]; DataTable dt = Wsheet.WriteToDataTable(); Santhoshalla, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,
It is easy to work with excel in .Net if you use 3rd party components. For example look at this C# code by using http://www.eleriumsoft.com/Excel_NET/ExcelReader/:

string xlload = @"d:\Tutorials.xls";

ExcelWorkbook Wbook = ExcelWorkbook.ReadXLS(xlload);

ExcelWorksheet Wsheet = Wbook.Worksheets[0];

DataTable dt = Wsheet.WriteToDataTable();

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

Posted by: Rimi1289 on: 2/19/2013 [Member] Starter | Points: 25

0	This will help. Rimi. Santhoshalla, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Megan00 on: 2/19/2013 [Member] Starter | Points: 25

0	You can try this article: http://excelcsharp.blog.com/2012/10/29/export-excel-to-datatable-and-import-datatable-to-excel/ or directly go here in source code page: http://spreadsheet.codeplex.com/ Never give up! Smile to the world! http://excelcsharp.blog.com/ Santhoshalla, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts