自动填充

最新推荐文章于 2021-05-18 21:32:15 发布

张家可

最新推荐文章于 2021-05-18 21:32:15 发布

阅读量455

点赞数

分类专栏： C#操作Excel

本文链接：https://blog.csdn.net/llxlett/article/details/8512929

版权

C#操作Excel 专栏收录该内容

40 篇文章 0 订阅

订阅专栏

/// <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);