tag:blogger.com,1999:blog-4577946163419870602.post8687008143722252355..comments2024-03-21T00:36:20.085-07:00Comments on Sarvesh Kushwaha: Excel To Database (Sample Code)Sarvesh Kushwahahttp://www.blogger.com/profile/00637015347460902643noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4577946163419870602.post-68889276993314792462013-08-28T21:41:54.539-07:002013-08-28T21:41:54.539-07:00Hi Mohamed EL AZZOUZI
try this ...
http://dontbrea...Hi Mohamed EL AZZOUZI<br />try this ...<br />http://dontbreakthebuild.com/2011/01/30/excel-and-c-interop-with-net-4-how-to-read-data-from-excel/<br /><br />or<br /><br />try this to see can we iterate using this <br />using (StreamWriter sw = File.CreateText("ExtractedText.txt"))<br />{<br /> var excelApp = new Excel.Application();<br /> var workBook = excelApp.Workbooks.Open(thisFile);<br /><br /> foreach (var sheet in workBook.Worksheets)<br /> {<br /> foreach (var row in sheet.UsedRange.Rows)<br /> {<br /> foreach (var cell in row.Columns)<br /> {<br /> sw.Write(cell.Value + " ");<br /> } <br /> sw.WriteLine();<br /> }<br /> }<br />}<br /><br />Anonymoushttps://www.blogger.com/profile/14108086149293280948noreply@blogger.comtag:blogger.com,1999:blog-4577946163419870602.post-41739336722775893182013-08-28T15:17:56.565-07:002013-08-28T15:17:56.565-07:00Hi Sarvesh,
your code is amazing thanks.
Can you...Hi Sarvesh,<br /><br />your code is amazing thanks.<br />Can you help to upload and save multi sheets in one click(the hall workbook), I try to use your code with forech loop but it does'nt work for me,Anonymoushttps://www.blogger.com/profile/11584972371085617879noreply@blogger.comtag:blogger.com,1999:blog-4577946163419870602.post-88278188370139028442013-05-14T23:19:33.983-07:002013-05-14T23:19:33.983-07:00Sir can we use SSIS for this purpose?.Sir can we use SSIS for this purpose?.Er. Anurag Tyagihttps://www.blogger.com/profile/01710319408627715407noreply@blogger.comtag:blogger.com,1999:blog-4577946163419870602.post-82106589970362063482013-03-19T19:34:17.001-07:002013-03-19T19:34:17.001-07:00THANK YOU MUCH SIR ! THIS WILL HELP ME SO MUCHTHANK YOU MUCH SIR ! THIS WILL HELP ME SO MUCHAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4577946163419870602.post-82204998816876429982012-11-03T22:13:51.084-07:002012-11-03T22:13:51.084-07:00Thanks dear :) ... Thanks dear :) ... Anonymoushttps://www.blogger.com/profile/14108086149293280948noreply@blogger.comtag:blogger.com,1999:blog-4577946163419870602.post-33664343810516190622012-11-03T21:13:00.983-07:002012-11-03T21:13:00.983-07:00Gud Sir ji..
Gud Sir ji..<br />Anonymoushttps://www.blogger.com/profile/13935985465371789319noreply@blogger.com