作成日: 2026/01/22    最終更新日: 2026/01/22

文書種別

使用方法

詳細

はい。IWorksheet インタフェースの InsertRows メソッド/ InsertColumns メソッドを使用することでスタイルを継承して行や列を挿入することができます。

・InsertRows メソッドでスタイルが設定されたセルの下に行を挿入した場合
→ 挿入された行のセルにも同じスタイルが適用される

・InsertColumns メソッドでスタイルが設定されたセルの右に列を挿入した場合
→ 挿入された列のセルにも同じスタイルが適用される

一方で、 SheetView クラスの AddRows メソッド/ AddColumns メソッドを使用して行や列を挿入した場合には、挿入した行や列にスタイルは継承されません。

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    '背景色設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A1").Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Red)
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C1").Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Blue)
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A3").Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Green)
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C3").Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Orange)

    '罫線設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A1").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thin
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C1").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thick
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A3").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Double
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C3").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.DashDot

    'データ設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A1").Value = "AAA"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C1").Value = "BBB"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A3").Value = "CCC"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C3").Value = "DDD"

    'フォントの設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A1").Font.Bold = True
    FpSpread1.ActiveSheet.AsWorksheet().Cells("C1").Font.Size = 7
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A3").Font.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.White)
End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    '【スタイルあり】行の挿入
    FpSpread1.ActiveSheet.AsWorksheet().InsertRows(1, 1)

    '【スタイルあり】列の挿入
    FpSpread1.ActiveSheet.AsWorksheet().InsertColumns(1, 1)

    'データ設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A2").Value = "aaa"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("B1:B2").Value = "aaa"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("B4").Value = "ccc"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("D2").Value = "bbb"
End Sub

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    '【スタイルなし】行の挿入
    FpSpread1.ActiveSheet.AddRows(1, 1)

    '【スタイルなし】列の挿入
    FpSpread1.ActiveSheet.AddColumns(1, 1)

    'データ設定
    FpSpread1.ActiveSheet.AsWorksheet().Cells("A2").Value = "aaa"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("B1:B2").Value = "aaa"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("B5").Value = "ccc"
    FpSpread1.ActiveSheet.AsWorksheet().Cells("E2").Value = "bbb"
End Sub

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

private void Form1_Load(object sender, EventArgs e)
{
      //背景色設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A1"].Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Red);
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C1"].Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Blue);
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A3"].Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Green);
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C3"].Interior.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.Orange);

      //罫線設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A1"].Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thin;
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C1"].Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thick;
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A3"].Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Double;
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C3"].Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.DashDot;

      //データ設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A1"].Value = "AAA";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C1"].Value = "BBB";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A3"].Value = "CCC";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C3"].Value = "DDD";

      //フォント設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A1"].Font.Bold = true;
      fpSpread1.ActiveSheet.AsWorksheet().Cells["C1"].Font.Size = 7;
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A3"].Font.Color = GrapeCity.Spreadsheet.Color.FromKnownColor(GrapeCity.Core.KnownColor.White);
}

private void button1_Click(object sender, EventArgs e)
{
      //行の挿入
      fpSpread1.ActiveSheet.AsWorksheet().InsertRows(1, 1);
      
      //列の挿入
      fpSpread1.ActiveSheet.AsWorksheet().InsertColumns(1, 1);

      //データ設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A2"].Value = "aaa";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["B1:B2"].Value = "aaa";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["B4"].Value = "ccc";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["D2"].Value = "bbb";
}

private void button2_Click(object sender, EventArgs e)
{
      //【スタイルなし】行の挿入
      fpSpread1.ActiveSheet.AddRows(1, 1);

      //【スタイルなし】列の挿入
      fpSpread1.ActiveSheet.AddColumns(1, 1);

      //データ設定
      fpSpread1.ActiveSheet.AsWorksheet().Cells["A2"].Value = "aaa";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["B1:B2"].Value = "aaa";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["B5"].Value = "ccc";
      fpSpread1.ActiveSheet.AsWorksheet().Cells["E2"].Value = "bbb";
}

＜実行イメージ＞

関連情報

• シートに表示されている行のセル範囲に対して背景色を適用すると、Excelエクスポート時にセル範囲ではなく行全体に背景色が設定される