write two excel sheet
object missing=Missing.Value;
Excel.Application myExcel = new Excel.Application ( ) ;
myExcel.Application.Workbooks.Open(fileName,missin g,missing,missing,missing,
missing,missing,missing,missing,missing,missing,mi ssing,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?
}
|