複数のセル範囲に異なる値を一括で設定できますか？ – MESCIUS ナレッジベース

作成日: 2019/12/09 最終更新日: 2019/12/09

文書種別

使用方法

詳細

GcExcelのIRange.Valueプロパティには、String／Double／Int／Boolean／DateTime／TimeSpan型の各データの他、下記のようにobject型の二次元配列も設定可能です。

◎サンプルコード(VB)

Dim data As Object(,) = {
　　{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
　　{"Richard", "New York", New DateTime(1968, 6, 8), "Blue", 67, 165},
　　{"Nia", "New York", New DateTime(1972, 7, 3), "Brown", 62, 134},
　　{"Jared", "New York", New DateTime(1964, 3, 2), "Hazel", 72, 180},
　　{"Natalie", "Washington", New DateTime(1972, 8, 8), "Blue", 66, 163},
　　{"Damon", "Washington", New DateTime(1986, 2, 2), "Hazel", 76, 176},
　　{"Angela", "Washington", New DateTime(1993, 2, 15), "Brown", 68, 145}
}

worksheet.Range("A1:F7").Value = data

◎サンプルコード(C#)

object[,] data = new object[,]{
　　{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
　　{"Richard", "New York", new DateTime(1968, 6, 8), "Blue", 67, 165},
　　{"Nia", "New York", new DateTime(1972, 7, 3), "Brown", 62, 134},
　　{"Jared", "New York", new DateTime(1964, 3, 2), "Hazel", 72, 180},
　　{"Natalie", "Washington", new DateTime(1972, 8, 8), "Blue", 66, 163},
　　{"Damon", "Washington", new DateTime(1986, 2, 2), "Hazel", 76, 176},
　　{"Angela", "Washington", new DateTime(1993, 2, 15), "Brown", 68, 145}
};

worksheet.Range["A1:F7"].Value = data;

旧文書番号

84711