SPREAD控件的用法

protected void SpreadInit()
  {
   GCom.InitSpread(spdBody);
   spdBody.Height=400;
   System.Drawing.ColorConverter coverter=new System.Drawing.ColorConverter();
   spdBody.Sheets[0].BackColor  = (System.Drawing.Color)coverter.ConvertFromString("#EEEEFF");
   spdBody.Sheets[0].Columns.Count = COLUMN_MAXCOLUMNCOUNT;
   spdBody.Sheets[0].ColumnHeader.Cells[0,1].ColumnSpan = 2;
   //spdBody.Rows.Count = 8;
   //項目
   SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL1,FarPoint.Web.Spread.ImeMode.Active,300);
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].Width = 230;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL1].Label = COLUMN_NM_PRM_VAL1;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   //数量
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_SURYO,0);
   spdBody.Sheets[0].Columns[COLUMN_SURYO].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_SURYO].Label = COLUMN_NM_SURYO;
   spdBody.Sheets[0].Columns[COLUMN_SURYO].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_SURYO].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //数量単位
   SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL2,FarPoint.Web.Spread.ImeMode.Active,300);
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].Width = 45;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL2].Label = COLUMN_NM_PRM_VAL2;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
   //単価
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_TANKA,1);
   spdBody.Sheets[0].Columns[COLUMN_TANKA].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_TANKA].Label = COLUMN_NM_TANKA;
   spdBody.Sheets[0].Columns[COLUMN_TANKA].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_TANKA].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //金額
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_KINGAKU,1);
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_KINGAKU].Label = COLUMN_NM_KINGAKU;
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //PRM_KEY
   spdBody.Sheets[0].Columns[COLUMN_PRM_KEY].Visible = false;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_KEY].Label = COLUMN_NM_PRM_KEY;
  } 

 

protected void SpreadInit()
  {
   GCom.InitSpread(spdBody);
   spdBody.Height=400;
   System.Drawing.ColorConverter coverter=new System.Drawing.ColorConverter();
   spdBody.Sheets[0].BackColor  = (System.Drawing.Color)coverter.ConvertFromString("#EEEEFF");
   spdBody.Sheets[0].Columns.Count = COLUMN_MAXCOLUMNCOUNT;
   spdBody.Sheets[0].ColumnHeader.Cells[0,1].ColumnSpan = 2;
   //spdBody.Rows.Count = 8;
   //項目
   SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL1,FarPoint.Web.Spread.ImeMode.Active,300);
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].Width = 230;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL1].Label = COLUMN_NM_PRM_VAL1;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   //数量
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_SURYO,0);
   spdBody.Sheets[0].Columns[COLUMN_SURYO].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_SURYO].Label = COLUMN_NM_SURYO;
   spdBody.Sheets[0].Columns[COLUMN_SURYO].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_SURYO].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //数量単位
   SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL2,FarPoint.Web.Spread.ImeMode.Active,300);
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].Width = 45;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL2].Label = COLUMN_NM_PRM_VAL2;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
   //単価
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_TANKA,1);
   spdBody.Sheets[0].Columns[COLUMN_TANKA].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_TANKA].Label = COLUMN_NM_TANKA;
   spdBody.Sheets[0].Columns[COLUMN_TANKA].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_TANKA].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //金額
   SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_KINGAKU,1);
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].Width = 140;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_KINGAKU].Label = COLUMN_NM_KINGAKU;
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
   spdBody.Sheets[0].Columns[COLUMN_KINGAKU].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
   //PRM_KEY
   spdBody.Sheets[0].Columns[COLUMN_PRM_KEY].Visible = false;
   spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_KEY].Label = COLUMN_NM_PRM_KEY;
  }