Excel query insert
in [Programming]
|
Prev: To enter data in columns in required order in some special way and to ensure this
Next: Sheet delete event
From: ranjith on 17 Apr 2010 02:09 I want to insert a new row into excel sheet after reading from few text boxes in my C# windows application. The sheet has already few lines so I need to find the last row to be written and insert m y data. i found the last row from the below code Microsoft.Office.Interop.Excel.Range rowrange = workSheet.Cells.Find("*", System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, Microsoft.Office.Interop.Excel.XlSearchOrder.xlByRows, Microsoft.Office.Interop.Excel.XlSearchDirection.xlPrevious, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value); Now i need to insert the data from my text boxes into the next row on click of a button Submitted via EggHeadCafe - Software Developer Portal of Choice Get Silverlight 4 Installed: Tips and Tricks http://www.eggheadcafe.com/tutorials/aspnet/05910e41-3846-4db9-8e1b-f54c56a64ed9/get-silverlight-4-install.aspx
From: joel on 17 Apr 2010 08:39
Use offset to get next cell rowrange.offset(1,0) -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196332 http://www.thecodecage.com/forumz |