自动填充

/// <summary>
  /// 自动填充
  /// </summary>
  public void RangAutoFill()
  {
   Excel.Range rng = workSheet.get_Range("B4", Type.Missing);
   rng.Value2 = "星期一 ";
   rng.AutoFill(workSheet.get_Range("B4","B9"),
    Excel.XlAutoFillType.xlFillWeekdays);

   rng = workSheet.get_Range("C4", Type.Missing);
   rng.Value = "一月";
   rng.AutoFill(workSheet.get_Range("C4","C9"),
    Excel.XlAutoFillType.xlFillMonths);

   rng = workSheet.get_Range("D4",Type.Missing);
   rng.Value2 = "1";
   rng.AutoFill(workSheet.get_Range("D4","D9"),
    Excel.XlAutoFillType.xlFillSeries);

   rng = workSheet.get_Range("E4",Type.Missing);
   rng.Value2 = "3";
   rng = workSheet.get_Range("E5",Type.Missing);
   rng.Value2 = "6";
   rng = workSheet.get_Range("E4","E5");
   rng.AutoFill(workSheet.get_Range("E4","E9"),
    Excel.XlAutoFillType.xlFillSeries);

  }