write two excel sheet

I

imabegginner

object missing=Missing.Value;
Excel.Application myExcel = new Excel.Application ( ) ;

myExcel.Application.Workbooks.Open(fileName,missing,missing,missing,missing,
missing,missing,missing,missing,missing,missing,missing,missing);

Excel.Workbook myBook=myExcel.Workbooks[1];
Excel.Sheets sheets=myBook.Worksheets;

for(int currSheet=1; currSheet < 2; currSheet ++)
{
Excel.Worksheet mySheet=(Excel.Worksheet)sheets.get_Item(currSheet);

//write data, eg:：
mySheet.Cells[1,1] = "1";
mySheet.Cells[2,1] = "2";

Excel.Range r=mySheet.get_Range(mySheet.Cells[1,1],mySheet.Cells[2,1]);
r.Select(); //wrong when second loop, Why?
}
 
Top