HOW TO ASSIGN SPECIFIC ROW FOR TEXTBOX IN VS2010 TO EXCEL

Hi,

Try below code..

//Creates new istance of Excel

Excel.Application excelApp = new Excel.Application();

//Set path to the excel file to open

string myPath = @"C:\Test.xls";

//opens excel file

excelApp.Workbooks.Open(myPath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

//Your Condition here i.e.

string TextBoxvalue = "Test";

if (TextBoxvalue.StartsWith("R")

//Row and column the Excel cell is in (eg 1,1)

int rowIndex = 1; int colIndex = 1;

//Excel cell of (1,1) should have the value in cell

excelApp.Cells[rowIndex, colIndex] = TextBoxvalue;

}

//Show excel app

excelApp.Visible = true;