Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query insert
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.xlByR ows, Microsoft.Office.Interop.Excel.XlSearchDirection.x lPrevious, 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...4-install.aspx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query insert
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/sh...d.php?t=196332 http://www.thecodecage.com/forumz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert subtotal in a query database Excel 2007 | Excel Worksheet Functions | |||
Excel query then insert row | Excel Programming | |||
Using ADO with INSERT query | Excel Programming | |||
Using ADO with INSERT query | Excel Programming | |||
Using ADO with INSERT query | Excel Programming |