.net dataexcel 单元格函数源码

using Feng.Excel.Builder;
using Feng.Excel.Collections;
using Feng.Excel.Interfaces;
using Feng.Excel.Utils;
using Feng.Script.CBEexpress;
using Feng.Script.Method;
using Feng.Utils;
using System;
using System.Collections.Generic;
using System.Drawing;
namespace Feng.Excel.Script
{
    [Serializable]
    public class DataExcelCellFunctionContainer : DataExcelMethodContainer
    {
        public const string Function_Name = "DataExcelCell";
        public const string Function_Description = "单元格函数";
        public override string Name
        {
            get { return Function_Name; }
        }
        public override string Description
        {
            get { return Function_Description; }
        }
        public DataExcelCellFunctionContainer()
        {
            BaseMethod model = null;
            model = new BaseMethod();
            model.Name = "CellID";
            model.Description = @"设置单元格ID CellID(CELL(""A5""),""NAME"")";
            model.Eg = @"var res=CellID(CELL(""A5""),""NAME"")";
            model.Function = CellID;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellColumnIndex";
            model.Description = @"获取单元格列索引 CellColumnIndex(CELL(""A5"")) 返回 1";
            model.Eg = @"var columnindex=CellColumnIndex(CELL(""A5""))";
            model.Function = CellColumnIndex;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellColumnName";
            model.Description = @"获取单元格列名称 CellColumnName(CELL(""A5"")) 返回 A";
            model.Eg = @"var columnname=CellColumnName(CELL(""A5""))";
            model.Function = CellColumnName;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellRowIndex";
            model.Description = @"获取单元格列名称 CellRowIndex(CELL(""A5"")) 返回 5";
            model.Eg = @"CellRowIndex(CELL(""A5""))";
            model.Function = CellRowIndex;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellColumnMaxIndex";
            model.Description = @"获取合并单元格最大列索引 CellColumnMaxIndex(CELL(""A5"")) 返回 1";
            model.Eg = @"CellColumnMaxIndex(CELL(""A5""))";
            model.Function = CellColumnMaxIndex;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellRowMaxIndex";
            model.Description = @"获取合并单元格最大列名称 CellRowMaxIndex(CELL(""A5"")) 返回 5";
            model.Eg = @"CellRowMaxIndex(CELL(""A5""))";
            model.Function = CellRowMaxIndex;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellUp";
            model.Description = @"获取单元格的上一个单元格 CellUp(CELL(""A5"")) 返回 A4";
            model.Eg = @"CellUp(CELL(""A5""))";
            model.Function = CellUp;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellDown";
            model.Description = @"获取单元格的下一个单元格 CellDown(CELL(""A5"")) 返回 A6";
            model.Eg = @"CellDown(CELL(""A5""))";
            model.Function = CellDown;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellLeft";
            model.Description = @"获取单元格的左一个单元格 CellLeft(CELL(""B5"")) 返回 A5";
            model.Eg = @"CellLeft(CELL(""B5""))";
            model.Function = CellLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellRight";
            model.Description = @"获取单元格的左一个单元格 CellRight(CELL(""B5"")) 返回 C5";
            model.Eg = @"CellRight(CELL(""B5""))";
            model.Function = CellRight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellsLeft";
            model.Description = @"获取合并单元格的左单元格 CellsLeft(mcell,2)";
            model.Eg = @"CellsLeft(mcell,2)";
            model.Function = CellsLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellsRight";
            model.Description = @"获取合并单元格的右单元格 CellsRight(mcell,2)";
            model.Eg = @"CellsRight(mcell,2)";
            model.Function = CellsRight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellProperty";
            model.Description = "获取单元格属性值";
            model.Function = CellProperty;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellName";
            model.Description = @"获取单元格名称 CellName(CellRight(CELL(""B5""))) 返回""A5""";
            model.Eg = @"CellName(CellRight(CELL(""B5"")))";
            model.Function = CellName;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellID";
            model.Description = @"获取或设置单元格ID CellID(CELL(""B5""))";
            model.Eg = @"CellID(CELL(""B5""))";
            model.Function = CellID;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellCaption";
            model.Description = @"获取单元格标题 CellCaption(CELL(""B5""))";
            model.Eg = @"CellCaption(CELL(""B5""))";
            model.Function = CellCaption;
            MethodList.Add(model);
 
            model = new BaseMethod();
            model.Name = "CellAction";
            model.Description = @"获取单元格标题 CellAction(CELL(""B5""),""CellClick"")";
            model.Eg = @"CellAction(CELL(""B5""),""CellClick"")";
            model.Function = CellAction;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTable";
            model.Description = @"获取或设置单元格 表格名称，行索引，列名称 CellTable(""B5"",""TableName"",1,""ColumnName"")";
            model.Eg = @"CellTable(""B5"",""TableName"",1,""ColumnName"")";
            model.Function = CellTable;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTableName";
            model.Description = @"获取或设置单元格 表格名称 CellTableName(""B5"",""TableName"")";
            model.Eg = @"CellTableName(""B5"",""TableName"")";
            model.Function = CellTableName;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTableRowIndex";
            model.Description = @"获取或设置单元格 表格行索引 CellTableRowIndex(""B5"",1)";
            model.Eg = @"CellTableRowIndex(CELL(""B5"",1)";
            model.Function = CellTableRowIndex;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTableColumnName";
            model.Description = @"获取或设置单元格 表格列名称 CellTableColumnName(""B5"",""ColumnName"")";
            model.Eg = @"CellTableColumnName(""B5"",""ColumnName"")";
            model.Function = CellTableColumnName;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFocused";
            model.Description = "获取或设置焦点单元格 CellFocused()";
            model.Eg = "CellFocused(Cell(2,2))";
            model.Function = CellFocused;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "Cell";
            model.Description = "获取单元格 Cell(\"A5\") Cell(\"ID\") CELL(2,2)";
            model.Eg = @"Cell(""A1"")";
            model.Function = Cell;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFind";
            model.Description = "查找单元格 CellFind(\"A5\",3,5)";
            model.Eg = @"CellFind(""文本值"",""C"",5)";
            model.Function = CellFind;
            MethodList.Add(model);
            
            model = new BaseMethod();
            model.Name = "CellLike";
            model.Description = @"查找符合条件的所有单元格 CellLike(""好%"")";
            model.Eg = @"CellLike(""好%"")";
            model.Function = CellLike;
            MethodList.Add(model);
 
            model = new BaseMethod();
            model.Name = "CellValue";
            model.Description = "获取或设置单元格值 CellValue(\"A5\") CellValue(\"ID\")";
            model.Eg = @"CellValue(""A1"",1024)";
            model.Function = CellValue;
            MethodList.Add(model);
 
            model = new BaseMethod();
            model.Name = "CellText";
            model.Description = "获取或设置单元格文本 CellText(\"A5\") CellText(\"ID\")";
            model.Eg = @"CellText(""A1"",""1024"")";
            model.Function = CellText;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellScript";
            model.Description = "获取或设置单元格脚本 CellScript(\"A5\") CellScript(\"ID\")";
            model.Eg = @"CellScript(""A1"",""1024"")";
            model.Function = CellScript;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellText1";
            model.Description = "获取或设置单元格文本1 CellText1(\"A5\") CellText1(\"ID\")";
            model.Eg = @"CellText1(""A1"",""1024"")";
            model.Function = CellText1;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellText2";
            model.Description = "获取或设置单元格文本2 CellText2(\"A5\") CellText1(\"ID\")";
            model.Eg = @"CellText2(""A1"",""1024"")";
            model.Function = CellText2;
            MethodList.Add(model);

            model = new BaseMethod();
            model.Name = "CellText3";
            model.Description = "获取或设置单元格文本3 CellText3(\"A5\") CellText1(\"ID\")";
            model.Eg = @"CellText3(""A1"",""1024"")";
            model.Function = CellText3;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellInt";
            model.Description = "获取或设置单元格文本 CellInt(\"A5\") CellInt(\"ID\")";
            model.Eg = @"CellInt(""A1"",""1024"")";
            model.Function = CellInt;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellDateTime";
            model.Description = "获取或设置单元格文本 CellDateTime(\"A5\") CellDateTime(\"ID\")";
            model.Eg = @"CellDateTime(""A1"",""2021-12-1"")";
            model.Function = CellDateTime;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellLong";
            model.Description = "获取或设置单元格文本 CellLong(\"A5\") CellLong(\"ID\")";
            model.Eg = @"CellLong(""A1"",""1024"")";
            model.Function = CellLong;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellDecimal";
            model.Description = "获取或设置单元格文本 CellDecimal(\"A5\") CellDecimal(\"ID\")";
            model.Eg = @"CellDecimal(""A1"",""1024"")";
            model.Function = CellDecimal;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBool";
            model.Description = "获取或设置单元格文本 CellBool(\"A5\") CellBool(\"ID\")";
            model.Eg = @"CellBool(""A1"",true)";
            model.Function = CellBool;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "Cells";
            model.Description = @"获取单元格集合 Cells(""A1,A2:B10,C3"")";
            model.Eg = @"Cells(""A1,A2:B10,C3"")";
            model.Function = Cells;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellValues";
            model.Description = "获取单元格集合的值";
            model.Eg = @"CellValues(""A1,A2:B10,C3"")";
            model.Function = CellValues;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CelLRange";
            model.Description = @"获取单元格范围 CelLRange(""A1:A10"")";
            model.Eg = @"CelLRange(""A1:A10"")";
            model.Function = CellRange;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellList";
            model.Description = @"获取单元格集合 CellList(""A1:A10"")";
            model.Eg = @"CellList(""A1:A10"")";
            model.Function = CellList;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellRangeExecScript";
            model.Description = "单元格集合中的每个单元格执行脚本,每个单元格使用ME代指";
            model.Eg = @"CellRangeExecScript(""A1:10"",""CELLVALUE(ME,CELLNAME(ME))"")";
            model.Function = CellRangeExecScript;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellRangeExecFunction";
            model.Description = "单元格集合中的每个单元格执行脚本,每个单元格使用ME代指";
            model.Eg = @"CellRangeExecFunction(""A1:10"",""Add"")";
            model.Function = CellRangeExecFunction;
            MethodList.Add(model);
 
            model = new BaseMethod();
            model.Name = "CellClear";
            model.Description = "清除单元格内容";
            model.Function = CellClear;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTrim";
            model.Description = "清除单元格内容包含的空格";
            model.Eg = "CellTrim()";
            model.Function = CellTrim;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellShow";
            model.Description = "显示单元格";
            model.Function = CellShow;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellHide";
            model.Description = "隐藏单元格";
            model.Function = CellHide;
            MethodList.Add(model);
 
            model = new BaseMethod();
            model.Name = "CellVisible";
            model.Description = @"获取或设置单元格可见 CellVisible(cell(""name""),false)";
            model.Eg = @"CellVisible(cell(""name""),false)";
            model.Function = CellVisible;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellMerge";
            model.Description = @"合并单元格CellMerge(Cell(""A2""),Cell(""B5""))";
            model.Eg = @"CellMerge(Cell(""A2""),Cell(""B5""))";
            model.Function = CellMerge;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellUnMerge";
            model.Description = "取消合并单元格";
            model.Eg = @"CellUnMerge(""A2"")";
            model.Function = CellUnMerge;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellGetMergeCell";
            model.Description = @"CellGetMergeCell(Cell(""A2""))";
            model.Eg = @"CellGetMergeCell(Cell(""A2""))";
            model.Function = CellGetMergeCell;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellReadOnly";
            model.Description = "单元格只读";
            model.Eg = @"";
            model.Function = CellReadOnly;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellEdit";
            model.Description = "单元格编辑控件";
            model.Eg = @"";
            model.Function = CellEdit;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBackImage";
            model.Description = "单元格背景图片";
            model.Eg = @"";
            model.Function = CellBackImage;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBackColor";
            model.Description = "单元格背景颜色";
            model.Eg = @"";
            model.Function = CellBackColor;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBorderOutside";
            model.Description = "单元格外边框";
            model.Eg = @"CellBorderOutside(CELL(""A5""))";
            model.Function = CellBorderOutside;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBorderTop";
            model.Description = "单元格上边框";
            model.Eg = @"CellBorderTop(CELL(""A5""))";
            model.Function = CellBorderTop;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBorderBottom";
            model.Description = "单元格下边框";
            model.Eg = @"CellBorderTop(CELL(""A5""))";
            model.Function = CellBorderBottom;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBorderLeft";
            model.Description = "单元格下边框";
            model.Eg = @"CellBorderLeft(CELL(""A5""))";
            model.Function = CellBorderLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBorderRight";
            model.Description = "单元格下边框";
            model.Eg = @"CellBorderRight(CELL(""A5""))";
            model.Function = CellBorderRight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFormatNumber";
            model.Description = @"单元格格式 CellFormatNumber(cell(""num""),""0.00"")";
            model.Eg = @"CellFormatNumber(cell(""num""),""0.00"")";
            model.Function = CellFormatNumber;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFormatDateTime";
            model.Description = @"单元格日期格式 CellFormatDateTime(cell(""time""),""yyyy-MM-dd HH:mm:ss"")";
            model.Eg = @"CellFormatDateTime(cell(""time""),""yyyy-MM-dd HH:mm:ss"")";
            model.Function = CellFormatDateTime;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFormatClear";
            model.Description = "清除单元格格式";
            model.Eg = @"";
            model.Function = CellFormatClear;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentCenter";
            model.Description = "单元格居中对齐";
            model.Eg = @"";
            model.Function = CellAlignmentCenter;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentLeft";
            model.Description = "单元格左对齐";
            model.Eg = @"";
            model.Function = CellAlignmentLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentRight";
            model.Description = "单元格右对齐";
            model.Eg = @"";
            model.Function = CellAlignmentRight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentHorizontalCenter";
            model.Description = "单元格水平居中对齐";
            model.Eg = @"";
            model.Function = CellAlignmentHorizontalCenter;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentTop";
            model.Description = "单元格上对齐";
            model.Eg = @"";
            model.Function = CellAlignmentTop;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentBottom";
            model.Description = "单元格上对齐";
            model.Eg = @"";
            model.Function = CellAlignmentBottom;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAlignmentVerticalCenter";
            model.Description = "单元格垂直居中对齐";
            model.Eg = @"";
            model.Function = CellAlignmentVerticalCenter;
            MethodList.Add(model);
            //model = new BaseMethod();
            //model.Name = "CellEditMode";
            //model.Description = "单元格对齐";
            //model.Eg = @"";
            //model.Function = CellEditMode;
            //MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellAutoMultiline";
            model.Description = "单元格自动换行";
            model.Eg = @"";
            model.Function = CellAutoMultiline;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellForeColor";
            model.Description = "单元格前景色";
            model.Eg = @"";
            model.Function = CellForeColor;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTabStop";
            model.Description = "单元格Tab键顺序";
            model.Eg = @"";
            model.Function = CellTabStop;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellTextDirection";
            model.Description = "单元格文字顺序";
            model.Eg = @"";
            model.Function = CellTextDirection;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellFont";
            model.Description = "单元格字体";
            model.Eg = @"CellFont(""宋体"",2)";
            model.Function = CellFont;
            MethodList.Add(model);

            model = new BaseMethod();
            model.Name = "CellListFill";
            model.Description = "显示集合内容 参数1:单元格,参数2:数据集合,参数3:超点，参数4:长度";
            model.Eg = @"CellListFill(LIST,Cells(""B3:B10""),5)";
            model.Function = CellListFill;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBoundLeft";
            model.Description = "左边距";
            model.Eg = @"CellBoundLeft(Cell(""B3""))";
            model.Function = CellBoundLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBoundTop";
            model.Description = "上边距";
            model.Eg = @"CellBoundTop(Cell(""B3""))";
            model.Function = CellBoundTop;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBoundWidth";
            model.Description = "宽度";
            model.Eg = @"CellBoundWidth(Cell(""B3""))";
            model.Function = CellBoundWidth;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBoundHeight";
            model.Description = "高度";
            model.Eg = @"CellBoundHeight(Cell(""B3""))";
            model.Function = CellBoundHeight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellBounds";
            model.Description = "大小和位置";
            model.Eg = @"CellBounds(Cell(""B3""))";
            model.Function = CellBounds;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellMoveUp";
            model.Description = "移动单元格 向上移动";
            model.Eg = @"CellMoveUp(Cell(""B3""))";
            model.Function = CellMoveUp;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellMoveDown";
            model.Description = "移动单元格 向下移动";
            model.Eg = @"CellMoveDown(Cell(""B3""),1)";
            model.Function = CellMoveDown;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellMoveLeft";
            model.Description = "移动单元格 向左移动";
            model.Eg = @"CellMoveLeft(Cell(""B3""),1)";
            model.Function = CellMoveLeft;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellMoveRight";
            model.Description = "移动单元格 向右移动";
            model.Eg = @"CellMoveRight(Cell(""B3""),1)";
            model.Function = CellMoveRight;
            MethodList.Add(model);
            model = new BaseMethod();
            model.Name = "CellSwap";
            model.Description = @"交换单元格 CellSwap(Cell(""B3""),Cell(""C9""))";
            model.Eg = @"CellSwap(Cell(""B2""),Cell(""C3""));GridRefresh();";
            model.Function = CellSwap;
            MethodList.Add(model);
        }
        public virtual object CellBoundLeft(params object[] args)
        {
            ICell cell = GetArgIndex(1, args) as ICell;
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (cell != null)
            {
                return cell.Left;
            }
            return null;
        }
        public virtual object CellBoundTop(params object[] args)
        {
            ICell cell = GetArgIndex(1, args) as ICell;
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (cell != null)
            {
                return cell.Top;
            }
            return null;
        }
        public virtual object CellBoundWidth(params object[] args)
        {
            ICell cell = GetArgIndex(1, args) as ICell;
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (cell != null)
            {
                return cell.Width;
            }
            return null;
        }
        public virtual object CellBoundHeight(params object[] args)
        {
            ICell cell = GetArgIndex(1, args) as ICell;
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (cell != null)
            {
                return cell.Height;
            }
            return null;
        }
        public virtual object CellBounds(params object[] args)
        {
            ICell cell = GetArgIndex(1, args) as ICell;
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            } 
            if (cell != null)
            {
                return cell.Rect;
            }
            return null;
        }
        public virtual object Cell(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy != null)
            {
                ICell cell = null;
                if (args.Length == 3)
                {
                    ICell cel = null;
                    int row = Feng.Utils.Constants.NOINT999_;
                    cel = base.GetCell(1, args);
                    if (cel != null)
                    {
                        row = cel.Row.Index;
                    }
                    if (row = 0 && row >= 0)
                    {
                        cell = proxy.Grid[row, column];
                        if (cell.OwnMergeCell != null)
                        {
                            return cell.OwnMergeCell;
                        }
                        return cell;
                    }
                    string fieldname = base.GetTextValue(2, args);
                    if (row > 0 && (!string.IsNullOrWhiteSpace(fieldname)))
                    {
                        cell = proxy.Grid[row, fieldname];
                        if (cell != null)
                        {
                            if (cell.OwnMergeCell != null)
                            {
                                return cell.OwnMergeCell;
                            }
                        }
                        return cell;
                    }
                }
                if (cell ==null)
                {
                    cell = null;
                    string ct = base.GetTextValue(1, args);
                    cell = proxy.Grid.GetCellByText(ct);
                    if (cell != null)
                    {
                        if (cell.OwnMergeCell != null)
                        {
                            return cell.OwnMergeCell;
                        }
                        return cell;
                    }
                }
            }
            return null;
        }
        public virtual object CellFind(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy != null)
            {
                string text = base.GetTextValue(1, args);
                int mincolumnindex = base.GetIntValue(2, 0, args);
                int minrowindex = base.GetIntValue(3, 0, args);
                int maxcolumnindex = base.GetIntValue(4, 0, args);
                int maxrowindex = base.GetIntValue(5, 0, args);
                Point pt = Point.Empty;
                if (maxrowindex == 0)
                {
                    if (minrowindex == 0)
                    {
                        pt = proxy.Grid.ReSetHasValue();
                        minrowindex = 1;
                        maxrowindex = pt.X;
                    }
                    else
                    {
                        maxrowindex = minrowindex;
                    }
                }
                if (maxcolumnindex == 0)
                {
                    if (mincolumnindex == 0)
                    {
                        pt = proxy.Grid.ReSetHasValue();
                        mincolumnindex = 1;
                        maxcolumnindex = pt.Y;
                    }
                    else
                    {
                        maxcolumnindex = mincolumnindex;
                    }
                }
                for (int row = minrowindex; row  1)
            {
                for (int i = 0; i  1)
            {
                for (int i = 0; i  1)
            {
                for (int i = 0; i  1)
            {
                for (int i = 0; i = 3)
            {
                bool value = this.GetBooleanValue(2, args);
                cell.Grid.CellBorderClear(cell, !value);
            }
            else
            {
                cell.Grid.CellBorderClear(cell, false);
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellBorderTop(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length >= 3)
            {
                bool value = this.GetBooleanValue(2, args);
                cell.Grid.CreateCellBorderTop(cell, value);
            }
            else
            {
                cell.Grid.CreateCellBorderTop(cell);
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellBorderBottom(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length >= 3)
            {
                bool value = this.GetBooleanValue(2, args);
                cell.Grid.CreateCellBorderBottom(cell, value);
            }
            else
            {
                cell.Grid.CreateCellBorderBottom(cell);
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellBorderLeft(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length >= 3)
            {
                bool value = this.GetBooleanValue(2, args);
                cell.Grid.CreateCellBorderLeft(cell, value);
            }
            else
            {
                cell.Grid.CreateCellBorderLeft(cell);
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellBorderRight(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length >= 3)
            {
                bool value = this.GetBooleanValue(2, args);
                cell.Grid.CreateCellBorderRight(cell, value);
            }
            else
            {
                cell.Grid.CreateCellBorderRight(cell);
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellFormatNumber(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            string format = base.GetTextValue(2, args);
            cell.FormatType = FormatType.Numberic;
            cell.FormatString = format;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellFormatDateTime(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            string format = base.GetTextValue(2, args);
            cell.FormatType = FormatType.DateTime;
            cell.FormatString = format;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellFormatClear(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.FormatType = FormatType.Null;
            cell.FormatString = string.Empty;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentCenter(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.HorizontalAlignment = StringAlignment.Center;
            cell.VerticalAlignment = StringAlignment.Center;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentTop(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.VerticalAlignment = StringAlignment.Near;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentBottom(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.VerticalAlignment = StringAlignment.Far;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentLeft(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.HorizontalAlignment = StringAlignment.Near;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentRight(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.HorizontalAlignment = StringAlignment.Far;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentHorizontalCenter(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.HorizontalAlignment = StringAlignment.Center;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAlignmentVerticalCenter(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            cell.VerticalAlignment = StringAlignment.Center;
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellAutoMultiline(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length == 3)
            {
                bool value = this.GetBooleanValue(2, args);
                if (cell != null)
                {
                    cell.AutoMultiline = value;
                    return Feng.Utils.Constants.OK;
                }
            }
            else
            {
                return cell.AutoMultiline;
            }
            return Feng.Utils.Constants.Fail;
        }
        public virtual object CellTabStop(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length == 3)
            {
                int value = this.GetIntValue(2, args);
                if (cell != null)
                {
                    cell.TabIndex = value;
                    return Feng.Utils.Constants.OK;
                }
            }
            else
            {
                return cell.TabIndex;
            }
            return Feng.Utils.Constants.Fail;
        }
        public virtual object CellTextDirection(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length == 3)
            {
                bool value = this.GetBooleanValue(2, args);
                if (cell != null)
                {
                    cell.DirectionVertical = value;
                    return Feng.Utils.Constants.OK;
                }
            }
            else
            {
                return cell.DirectionVertical;
            }
            return Feng.Utils.Constants.Fail;
        }
        public virtual object CellFont(params object[] args)
        {
#warning 需要优化
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length >= 3)
            {
                string fontname = this.GetTextValue(2, args);
                float fontsize = this.GetFloatValue(3, cell.Font.Size, args);
                if (cell != null)
                {
                    Font font = new Font(fontname, fontsize);
                    cell.Font = font;
                    return Feng.Utils.Constants.OK;
                }
            }
            else
            {
                return cell.Font;
            }
            return Feng.Utils.Constants.Fail;
        }
        public virtual object CellForeColor(params object[] args)
        {
            ICell cell = this.GetCell(1, args);
            if (cell == null)
            {
                cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
            }
            if (args.Length == 3)
            {
                Color value = Color.Empty;
                object objvalue = base.GetArgIndex(2,args);
                if (objvalue is Color)
                {
                    value = (Color)objvalue;
                }
                if (value == Color.Empty)
                { 
                    int artvalue = this.GetIntValue(2, -1, args);
                    if (artvalue > 0)
                    {
                        value = Feng.Utils.ConvertHelper.ToColor(artvalue);
                    }
                }
                if (value == Color.Empty)
                {
                    string artvalue = this.GetTextValue(2, -1, args);
                    if (!string.IsNullOrEmpty(artvalue))
                    {
                        value = Color.FromName(artvalue);
                    }
                }
                if (cell != null)
                {
                    if (value != Color.Empty)
                    {
                        cell.ForeColor = value;
                        return Feng.Utils.Constants.OK;
                    }
                }
            }
            else
            {
                return cell.ForeColor;
            }
            return Feng.Utils.Constants.Fail;
        }
        public virtual object CellListFill(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy value1 = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (value1 == null)
            {
                return null;
            }
            ICell cell = this.GetCell(1, args);
            Feng.Collections.ListEx values = base.GetArgIndex(2, args) as Feng.Collections.ListEx;
            int start = base.GetIntValue(3, 0, args);
            int len = base.GetIntValue(4, values.Count, args);
            if (cell != null)
            {
                int row = cell.MaxRowIndex + 1;
                int column = cell.Column.Index;
                for (int i = start; i 0)
                {
                    CellMoveUp(cells, step);
                }
                else
                {
                    CellMoveUp(cells);
                }
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellMoveDown(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy == null)
            {
                return null;
            }
            ISelectCellCollection cells = GetArgIndex(1, args) as ISelectCellCollection;
            if (cells == null)
            {
                ICell cel = GetArgIndex(1, args) as ICell;
                if (cel != null)
                {
                    cells = new SelectCellCollection();
                    cells.BeginCell = cel;
                    cells.EndCell = cel;
                }
            }
            ICell cell = GetArgIndex(2, args) as ICell;
            int step = -1;
            if (cell == null)
            {
                step = base.GetIntValue(2, -1, args);
            }
            if (cells != null)
            {
                if (cell != null)
                {
                    CellMoveDown(cells, cell);
                }
                else if (step > 0)
                {
                    CellMoveDown(cells, step);
                }
                else
                {
                    CellMoveDown(cells);
                }
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellMoveLeft(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy == null)
            {
                return null;
            }
            ISelectCellCollection cells = GetArgIndex(1, args) as ISelectCellCollection;
            if (cells == null)
            {
                ICell cel = GetArgIndex(1, args) as ICell;
                if (cel != null)
                {
                    cells = new SelectCellCollection();
                    cells.BeginCell = cel;
                    cells.EndCell = cel;
                }
            }
            ICell cell = GetArgIndex(2, args) as ICell;
            int step = -1;
            if (cell == null)
            {
                step = base.GetIntValue(2, -1, args);
            }
            if (cells != null)
            {
                if (cell != null)
                {
                    CellMoveLeft(cells, cell);
                }
                else if (step > 0)
                {
                    CellMoveLeft(cells, step);
                }
                else
                {
                    CellMoveLeft(cells);
                }
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellMoveRight(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy == null)
            {
                return null;
            }
            ISelectCellCollection cells = GetArgIndex(1, args) as ISelectCellCollection;
            if (cells == null)
            {
                ICell cel = GetArgIndex(1, args) as ICell;
                if (cel != null)
                {
                    cells = new SelectCellCollection();
                    cells.BeginCell = cel;
                    cells.EndCell = cel;
                }
            }
            ICell cell = GetArgIndex(2, args) as ICell;
            int step = -1;
            if (cell == null)
            {
                step = base.GetIntValue(2, -1, args);
            }
            if (cells != null)
            {
                if (cell != null)
                {
                    CellMoveRight(cells, cell);
                }
                else if (step > 0)
                {
                    CellMoveRight(cells, step);
                }
                else
                {
                    CellMoveRight(cells);
                }
            }
            return Feng.Utils.Constants.OK;
        }
        public virtual object CellSwap(params object[] args)
        {
            Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
            if (proxy == null)
            {
                return null;
            }
            ICell cel = GetArgIndex(1, args) as ICell;
            ICell cell = GetArgIndex(2, args) as ICell;
            proxy.Grid.Swap(cel, cell);
            return Feng.Utils.Constants.OK;
        }
    }
}