MESCIUS SPREAD for Windows Forms 17.0J
FpSpread プロパティ

シートビューからFpspreadを取得します。
構文
'Declaration
 
Public ReadOnly Property FpSpread As FpSpread
public FpSpread FpSpread {get;}
次のサンプルコードは、SheetViewのFpSpreadプロパティを使用します。
private void Form1_Load(object sender, EventArgs e)
       {
           fpSpread1.Sheets.Count = 4;
           fpSpread2.Sheets.Count = 2;
           fpSpread1.AllowCellOverflow = true;
           fpSpread2.AllowCellOverflow = true;
           fpSpread1.ActiveSheet.Cells[4, 0].Text = "fpSpread1.ActiveSheet.Cells[0, 0].Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()";
           fpSpread2.ActiveSheet.Cells[4, 0].Text = "fpSpread2.ActiveSheet.Cells[0, 0].Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()";         
       }

       private void button1_Click(object sender, EventArgs e)
       {
           fpSpread1.ActiveSheet.Cells[0, 0].Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString();
           fpSpread2.ActiveSheet.Cells[0, 0].Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString();
       }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets.Count = 4
        fpSpread2.Sheets.Count = 2
        FpSpread1.AllowCellOverflow = True
        fpSpread2.AllowCellOverflow = True
        FpSpread1.ActiveSheet.Cells(4, 0).Text = "fpSpread1.ActiveSheet.Cells(0,0).Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()"
        fpSpread2.ActiveSheet.Cells(4, 0).Text = "fpSpread2.ActiveSheet.Cells(0,0).Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()"
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        FpSpread1.ActiveSheet.Cells(0, 0).Text = FpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()
        FpSpread2.ActiveSheet.Cells(0, 0).Text = FpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()
    End Sub
参照

SheetView クラス
SheetView メンバ

 

 


© MESCIUS inc. All rights reserved.