作成日: 2017/04/04 最終更新日: 2017/04/04
文書種別
使用方法
詳細
シートの左上(コーナー)ヘッダのセルに値を設定するには、SheetCornerクラスを使用します。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
-------------------------------
Webフォームクラス
-------------------------------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).Text = "Cor"
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).Background.Enable = False
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).ForeColor = Drawing.Color.Red
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).BackColor = Drawing.Color.Blue
End Sub
Webフォームクラス
-------------------------------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).Text = "Cor"
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).Background.Enable = False
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).ForeColor = Drawing.Color.Red
FpSpread1.ActiveSheetView.SheetCorner.Cells(0, 0).BackColor = Drawing.Color.Blue
End Sub
◎サンプルコード(C#)
-------------------------------
Webフォームクラス
-------------------------------
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].Text = "Cor";
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].Background.Enable = false;
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].ForeColor = Drawing.Color.Red;
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].BackColor = Drawing.Color.Blue;
}
Webフォームクラス
-------------------------------
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].Text = "Cor";
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].Background.Enable = false;
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].ForeColor = Drawing.Color.Red;
FpSpread1.ActiveSheetView.SheetCorner.Cells[0, 0].BackColor = Drawing.Color.Blue;
}
旧文書番号
40282