エクセル操作

C#

//エクセルの起動
Excel.Application xls = new Excel.Application();
xls.Visible = true;
//ワークブックス
Excel.Workbooks Workbooks = xls.Workbooks ;
//ワークブック
Excel._Workbook Workbook = Workbooks.Add(Missing.Value );
//シーツ
Excel.Sheets WorkSheets = Workbook.Worksheets ;
//シート選択
Excel._Worksheet WorkSheet = (Excel._Worksheet)WorkSheets.get_Item(1);

Excel.Range Range;
Range = WorkSheet.get_Range("A1",Missing.Value );
Range.Value2 = 2;
Range = (Excel.Range )WorkSheet.Cells.get_Item(3,2);
Range.Value2 = 555;
long Rows;
long Cols;
Cols = 5;
for (Rows = 1; Rows <= 10; Rows++)
{
Range = (Excel.Range)WorkSheet.Cells.get_Item(Rows, Cols);
Range.Value2 = Rows;
}

//シート選択
WorkSheet = (Excel._Worksheet)WorkSheets.get_Item(2);
WorkSheet = (Excel._Worksheet)WorkSheets.get_Item("Sheet3");

Range = WorkSheet.get_Range("A1", Missing.Value);
Range.Value2 = 2;
Range = (Excel.Range)WorkSheet.Cells.get_Item(3, 2);
Range.Value2 = 555;
Cols = 5;
for (Rows = 1; Rows <= 10; Rows++)
{
Range = (Excel.Range)WorkSheet.Cells.get_Item(Rows, Cols);
Range.Value2 = Rows;
}