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

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