關于farpoint公司的控件:SPREAD for .NET Windows Forms Ed.的一些簡單方法.

using System;
using FarPoint.Win.Spread ;
using System.Drawing;
using System.Windows.Forms;
namespace DFO010
{
/// <summary>
/// Fpspread的相關函數.2006/4/12 制作:Chouka
/// </summary>
 public class Classspd
 {
public Classspd()
  {
  }
/// <summary>
///設置spd的最大行列數  參數:表格對象,最大行數,最大列數
/// </summary>
  public static void spdOption(FpSpread ospd,int omaxrow,int omaxcol)
  {
if(omaxrow>=0 && omaxcol>=0)
   {
    ospd.ActiveSheet.ColumnCount = omaxcol;
    ospd.ActiveSheet.RowCount =omaxrow;
   }
  }
///<summary>
/// 清除spd中文本 參數:表格對象
///</summary>
  public static void spdTextClear(FpSpread ospd)
  {
//其中,true是只清除文本,false是清除文本+sheet內部所有的格式.
   ospd.ActiveSheet.ClearRange(0,0,ospd.ActiveSheet.RowCount,ospd.ActiveSheet.ColumnCount,true);
  }
///<summary>
/// 設定單元格的焦點  參數:表格對象,單元格行號,單元格列號 
///</summary>
  public static void spdSetFocus(FpSpread ospd,int orow ,int ocol)
  {
if(orow>=0 && ocol>=0)
   {
    ospd.Focus();
//ospd.ActiveSheet.SetActiveCell(orow,ocol,false);
    ospd.ActiveSheet.ActiveRowIndex =orow;
    ospd.ActiveSheet.ActiveColumnIndex =ocol;
   }
  }
///<summary>
/// 獲取指定單元格內的值  參數:表格對象,單元格行號,單元格列號  返回:值(文本)
///</summary>
  public static string spdGetValue(FpSpread ospd,int orow,int ocol)
  {
string str ="";
if(orow>=0 && ocol>=0)
   {
    str=System.Convert.ToString (ospd.ActiveSheet.GetValue(orow,ocol));
   }
return str;
  }
///<summary>
/// 設定指定單元格內的值   參數:表格對象,值,單元格行號,單元格列號
///</summary>
  public static void spdSetValue(FpSpread ospd,string str,int orow,int ocol)
  {
if (orow>=0 && ocol>=0)
   {
    ospd.ActiveSheet.SetValue(orow,ocol,str);
   }
  }
///<summary>
/// 設定單元格的鎖定(多行多列)   參數:表格對象,開始行號,開始列號,終止行號,終止列號
///</summary>
  public static void spdLock(FpSpread ospd,int orow1,int ocol1,int orow2,int ocol2)
  {
   ospd.ActiveSheet.Cells[orow1,ocol1,orow2,ocol2].Locked=true;
   ospd.ActiveSheet.LockBackColor =Color.LightYellow;
  }

///<summary>
/// 設定單元格的鎖定(單個)   參數:表格對象,行號,列號
///</summary>
  public static void spdLock(FpSpread ospd,int orow,int ocol)
  {
   ospd.ActiveSheet.Cells[orow,ocol].Locked =true; 
   ospd.ActiveSheet.LockBackColor =Color.LightYellow;
  }
///<summary>
/// 解鎖單元格(多行多列)  參數:表格對象,開始行號,開始列號,終止行號,終止列號
///</summary>
  public static void spdUnLock(FpSpread ospd,int orow1,int ocol1,int orow2,int ocol2)
  {
   ospd.ActiveSheet.Cells[orow1,ocol1,orow2,ocol2].Locked =false; 
   ospd.ActiveSheet.LockBackColor =Color.White;
  }
///<summary>
/// 解鎖單元格(單個)  參數:表格對象,行號,列號
///</summary>
  public static void spdUnLock(FpSpread ospd,int orow,int ocol)
  {
   ospd.ActiveSheet.Cells[orow,ocol].Locked =false; 
   ospd.ActiveSheet.LockBackColor =Color.White;
  }
///<summary>
/// spd的初始屬性設置.(回車跳格,清除split,鎖定行高列寬.直接更改文本)
///</summary>
  public static void spdLoad(FpSpread ospd)
  {
//回車進行到下一個單元格
   InputMap im;
   im = ospd.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
   im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter,Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
   im = ospd.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
   im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter,Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
// 清除split按鈕
   ospd.RowSplitBoxPolicy =SplitBoxPolicy.Never;
   ospd.ColumnSplitBoxPolicy =SplitBoxPolicy.Never ;
//鎖定列寬和行高
   ospd.ActiveSheet.Columns[0,ospd.ActiveSheet.ColumnCount  - 1].Resizable =false;
   ospd.ActiveSheet.Rows[0,ospd.ActiveSheet.RowCount  - 1].Resizable =false;
//單元格進入后文本全選.
   ospd.EditModeReplace =true;
  }
///<summary>
/// spd 按回車光標橫向移動,跳過lock的單元格.在spd的LeaveCell事件中使用.參數:sender,事件
///</summary>
  public static void spdLockCheck(FpSpread ospd,object sender, LeaveCellEventArgs e)
  {
if(ospd.ActiveSheet.Cells[e.NewRow,e.NewColumn].Locked  ==true)
   System.Windows.Forms.SendKeys.Send("{ENTER}");
  }

///<summary>
/// 設置多行類型的列標題.    參數:表格控件,行號(標題的index號),列號,標題
///<summary>
  public static void spdColLabel(FpSpread ospd,int orow,int ocol,string ostr) 
  {
   ospd.ActiveSheet.SetColumnLabel(orow,ocol,ostr);
  }
///<summary>
/// 設置多列類型的行標題.    參數:表格控件,行號,列號(標題的index號),標題
///<summary>
  public static void spdRowLabel(FpSpread ospd,int orow,int ocol,string ostr)
  {
   ospd.ActiveSheet.SetRowLabel(orow,ocol,ostr);
  }
///<summary>
///獲得尾行(不空)行號
///</summary>
  public static int spdFullRow(FpSpread ospd)
  {
return ospd.ActiveSheet.NonEmptyRowCount;  
  }
///<summary>
///獲得表格的行數
///</summary>
  public static int spdGetRowNumber(FpSpread ospd)
  {
return ospd.ActiveSheet.RowCount;
  }
///<summary>
///獲得表格的列數
///</summary>
  public static int spdGetColNumber(FpSpread ospd)
  {
return ospd.ActiveSheet.ColumnCount ;
  }

 }
}

?