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 = base.GetIntValue(1, Feng.Utils.Constants.NOINT999_, args);
}
int column = Feng.Utils.Constants.NOINT999_;
cel = base.GetCell(2, args);
if (cel != null)
{
column = cel.Column.Index;
}
if (column < 0)
{
column = base.GetIntValue(2, Feng.Utils.Constants.NOINT999_, args);
}
if (column >= 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 <= maxrowindex; row++)
{
for (int column = mincolumnindex; column <= maxcolumnindex; column++)
{
ICell cell = proxy.Grid.GetCell(row, column);
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
string txt = Feng.Utils.ConvertHelper.ToString(cell.Value);
Feng.Utils.TraceHelper.WriteTrace("", "", "FindCell", true, txt);
if (text == txt)
{
return cell;
}
}
}
}
}
return null;
}
public virtual object CellLike(params object[] args)
{
#warning 未完成 返回集合
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
string text = base.GetTextValue(1, args);
SelectCellCollection cells = base.GetArgIndex(2, args) as SelectCellCollection;
if (cells == null)
{
foreach (IRow row in proxy.Grid.Rows)
{
foreach (IColumn column in proxy.Grid.Columns)
{
ICell cell = row.Cells[column];
if (cell == null)
{
continue;
}
}
}
}
}
return null;
}
public virtual object CellValue(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
if (cell != null)
{
object value = base.GetArgIndex(2, args);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
else
{
return Feng.Utils.Constants.Fail;
}
}
if (cell != null)
{
return cell.Value;
}
return null;
}
public virtual object CellText(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string value = base.GetTextValue(2, args);
cell.Text = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.Text;
}
return null;
}
public virtual object CellScript(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string value = base.GetTextValue(2, args);
cell.Expression = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.Expression;
}
return null;
}
public virtual object CellText1(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string value = base.GetTextValue(2, args);
cell.Text1 = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.Text1;
}
return null;
}
public virtual object CellText2(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string value = base.GetTextValue(2, args);
cell.Text2 = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.Text2;
}
return null;
}
public virtual object CellText3(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string value = base.GetTextValue(2, args);
cell.Text3 = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.Text3;
}
return null;
}
public virtual object CellDateTime(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
object obj = base.GetArgIndex(2, args);
DateTime? value = Feng.Utils.ConvertHelper.ToDateTimeNullable(obj);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return Feng.Utils.ConvertHelper.ToDateTimeNullable(cell.Value);
}
return null;
}
public virtual object CellInt(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
int value = base.GetIntValue(2, args);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return Feng.Utils.ConvertHelper.ToInt32(cell.Value);
}
return null;
}
public virtual object CellLong(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
long value = base.GetLongValue(2, args);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return Feng.Utils.ConvertHelper.ToInt64(cell.Value);
}
return null;
}
public virtual object CellDecimal(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
decimal value = base.GetDecimalValue(2, args);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return Feng.Utils.ConvertHelper.ToDecimal(cell.Value);
}
return null;
}
public virtual object CellBool(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
bool value = base.GetBooleanValue(2, args);
cell.Value = value;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return Feng.Utils.ConvertHelper.ToBoolean(cell.Value);
}
return null;
}
public virtual object CellID(params object[] args)
{
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string id = base.GetTextValue(2, args);
cell.ID = id;
return Feng.Utils.Constants.OK;
}
if (cell != null)
{
return cell.ID;
}
return null;
}
public virtual object Cells(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
return null;
ICell begincell = null;
ICell endCell = null;
SelectCellCollection selectcell = this.GetCell(1, args) as SelectCellCollection;
if (selectcell != null)
{
return selectcell.GetAllCells();
}
begincell = this.GetCell(1, args);
endCell = this.GetCell(2, args);
if (endCell == null)
{
endCell = begincell;
}
if (endCell != null)
{
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
if (true)
{
string cellreange = base.GetTextValue(1, args);
if (cellreange.Contains(":"))
{
string[] cells = cellreange.Split(':');
if (cells.Length != 2)
{
return null;
}
begincell = proxy.Grid.GetCellByText(cells[0]);
if (begincell == null)
return null;
endCell = proxy.Grid.GetCellByText(cells[1]);
if (endCell == null)
{
endCell = begincell;
}
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
}
List<ICell> list = new List<ICell>();
for (int m = 1; m < args.Length; m++)
{
string text = base.GetTextValue(m, args);
string[] textes = Feng.Utils.TextHelper.Split(text, ",");
for (int i = 0; i < textes.Length; i++)
{
string cellreange = textes[i];
selectcell = DataExcelTools.GetSelectCell(proxy.Grid, cellreange);
if (selectcell != null)
{
list.AddRange(selectcell.GetAllCells());
}
}
}
return list;
}
public virtual object CellValues(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
return null;
List<object> values = new List<object>();
IEnumerable<ICell> list = base.GetArgIndex(1, args) as IEnumerable<ICell>;
if (list == null)
{
list = Cells(args) as List<ICell>;
}
if (list != null)
{
foreach (ICell item in list)
{
if (item != null)
{
values.Add(item.Value);
}
}
}
return values;
}
public virtual object CellRange(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell begincell = null;
ICell endCell = null;
SelectCellCollection selectcell = null;
begincell = this.GetCell(1, args);
endCell = this.GetCell(2, args);
if (endCell == null)
{
endCell = begincell;
}
if (endCell != null)
{
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell;
}
string cellreange = base.GetTextValue(1, args);
if (!cellreange.Contains(":"))
{
return null;
}
string[] cells = cellreange.Split(':');
if (cells.Length != 2)
{
return null;
}
begincell = proxy.Grid.GetCellByText(cells[0]);
if (begincell == null)
return null;
endCell = proxy.Grid.GetCellByText(cells[1]);
if (endCell == null)
{
endCell = begincell;
}
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell;
}
return null;
}
public virtual object CellList(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell begincell = null;
ICell endCell = null;
SelectCellCollection selectcell = null;
begincell = this.GetCell(1, args);
endCell = this.GetCell(2, args);
if (endCell == null)
{
endCell = begincell;
}
if (endCell != null)
{
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
string cellreange = base.GetTextValue(1, args);
if (!cellreange.Contains(":"))
{
return null;
}
string[] cells = cellreange.Split(':');
if (cells.Length != 2)
{
return null;
}
begincell = proxy.Grid.GetCellByText(cells[0]);
if (begincell == null)
return null;
endCell = proxy.Grid.GetCellByText(cells[1]);
if (endCell == null)
{
endCell = begincell;
}
selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
return null;
}
public virtual object CellRangeExecScript(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
SelectCellCollection selectcell = CellRange(args[0], args[1]) as SelectCellCollection;
if (selectcell == null)
{
return Feng.Utils.Constants.Fail;
}
string script = base.GetTextValue(2, args);
if (!string.IsNullOrWhiteSpace(script))
{
List<ICell> list = selectcell.GetAllCells();
foreach (ICell item in list)
{
Feng.Excel.Script.Function.RunExpress(proxy.Grid, item, script);
}
return Feng.Utils.Constants.OK;
}
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellRangeExecFunction(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
List<ICell> list = null;
SelectCellCollection selectcell = CellRange(args[0], args[1]) as SelectCellCollection;
if (selectcell != null)
{
list = selectcell.GetAllCells();
}
else
{
list = base.GetArgIndex(1, args) as List<ICell>;
}
if (list != null)
{
return Feng.Utils.Constants.Fail;
}
string function = base.GetTextValue(2, args);
if (!string.IsNullOrWhiteSpace(function))
{
object scriptobj = proxy.Grid.FunctionList[function];
if (scriptobj == null)
{
return Feng.Utils.Constants.Fail;
}
string script = scriptobj.ToString();
foreach (ICell item in list)
{
Feng.Excel.Script.Function.RunExpress(proxy.Grid, item, script);
}
return Feng.Utils.Constants.OK;
}
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellName(params object[] args)
{
ICell cell = this.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (cell != null)
{
return cell.Name;
}
return null;
}
public virtual object CellCaption(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)
{
string value = this.GetTextValue(2, args);
if (cell != null)
{
cell.Caption = value;
return Feng.Utils.Constants.OK;
}
}
else
{
if (cell != null)
{
return cell.Caption;
}
}
return null;
}
public virtual object CellAction(params object[] args)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
string shortname = this.GetTextValue(2, args);
if (cell != null)
{
if (args.Length > 3)
{
string script = this.GetTextValue(3, args);
Actions.PropertyActionTools.ActionScript(cell, shortname, script);
return Feng.Utils.Constants.OK;
}
else
{
return Actions.PropertyActionTools.ActionScript(cell, shortname);
}
}
return null;
}
public virtual object CellTable(params object[] args)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
string tablename = this.GetTextValue(2, args);
int tablerowindex = this.GetIntValue(3,-1, args);
string tablecolumnname = this.GetTextValue(4, args);
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
cell.TableName=tablename;
cell.TableRowIndex = tablerowindex;
cell.TableColumnName = tablecolumnname;
return Feng.Utils.Constants.OK;
}
return null;
}
public virtual object CellTableName(params object[] args)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
string tablename = this.GetTextValue(2, args);
if (args.Length == 3)
{
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
cell.TableName = tablename;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.TableName;
}
return null;
}
public virtual object CellTableRowIndex(params object[] args)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
int tablerowindex = this.GetIntValue(2, -1, args);
if (args.Length == 3)
{
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
cell.TableRowIndex = tablerowindex;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.TableRowIndex;
}
return null;
}
public virtual object CellTableColumnName(params object[] args)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
string tablecolumnname = this.GetTextValue(2, args);
if (args.Length == 3)
{
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
cell.TableColumnName = tablecolumnname;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.TableColumnName;
}
return null;
}
public virtual object CellProperty(params object[] args)
{
object value1 = GetArgIndex(1, args);
string propertyname = base.GetTextValue(2, args);
object res = ReflectionHelper.GetValue(value1, propertyname);
return res;
}
public virtual object CellColumnIndex(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
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.Column.Index;
}
return null;
}
public virtual object CellColumnName(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
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.Column.Name;
}
return null;
}
public virtual object CellRowIndex(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
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.Row.Index;
}
return null;
}
public virtual object CellColumnMaxIndex(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
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.MaxColumnIndex;
}
return null;
}
public virtual object CellRowMaxIndex(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
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.MaxRowIndex;
}
return null;
}
public virtual object CellUp(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
int len = GetIntValue(2, 1, args);
if (cell == null)
return null;
if (len > 1)
{
for (int i = 0; i < len; i++)
{
cell = CellUp(args[0], cell) as ICell;
}
return cell;
}
else
{
len = 1;
}
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
ICell rescell = cell.Grid[cell.Row.Index - len, cell.Column.Index];
if (rescell != null)
{
if (rescell.OwnMergeCell != null)
{
rescell = rescell.OwnMergeCell;
}
return rescell;
}
}
return null;
}
public virtual object CellDown(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
int len = GetIntValue(2, 1, args);
if (cell == null)
return null;
if (len > 1)
{
for (int i = 0; i < len; i++)
{
cell = CellDown(args[0], cell) as ICell;
}
return cell;
}
else
{
len = 1;
}
if (cell != null)
{
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
ICell rescell = cell.Grid[cell.MaxRowIndex + len, cell.Column.Index];
if (rescell != null)
{
if (rescell.OwnMergeCell != null)
{
rescell = rescell.OwnMergeCell;
}
return rescell;
}
}
return null;
}
public virtual object CellLeft(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
int len = GetIntValue(2, -1, args);
if (cell == null)
return null;
if (len > 1)
{
for (int i = 0; i < len; i++)
{
cell = CellLeft(args[0], cell) as ICell;
}
return cell;
}
else
{
len = 1;
}
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
ICell rescell = cell.Grid[cell.Row.Index, cell.Column.Index - len];
if (rescell != null)
{
if (rescell.OwnMergeCell != null)
{
rescell = rescell.OwnMergeCell;
}
return rescell;
}
return null;
}
public virtual object CellsLeft(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
ICell cellme= GetArgIndex(1, args) as ICell;
IMergeCell cell = null;
if (cellme != null)
{
cell = cellme.OwnMergeCell;
}
int len = GetIntValue(2, 0, args);
if (cell == null)
return null;
ICell begincell = proxy.Grid[cell.Row.Index, cell.Column.Index - len];
ICell endCell = proxy.Grid[cell.MaxRowIndex, cell.Column.Index - len];
if (endCell == null)
{
endCell = begincell;
}
if (endCell != null)
{
SelectCellCollection selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
return null;
}
public virtual object CellRight(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
ICell cell = GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
int len = GetIntValue(2, 1, args);
if (cell == null)
return null;
if (len > 1)
{
for (int i = 0; i < len; i++)
{
cell = CellRight(args[0], cell) as ICell;
}
return cell;
}
else
{
len = 1;
}
if (cell.OwnMergeCell != null)
{
cell = cell.OwnMergeCell;
}
ICell rescell = cell.Grid[cell.Row.Index, cell.MaxColumnIndex + len];
if (rescell != null)
{
if (rescell.OwnMergeCell != null)
{
rescell = rescell.OwnMergeCell;
}
return rescell;
}
return null;
}
public virtual object CellsRight(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy == null)
{
return null;
}
IMergeCell cell = GetArgIndex(1, args) as IMergeCell;
int len = GetIntValue(2, 0, args);
if (cell == null)
return null;
ICell begincell = proxy.Grid[cell.Row.Index, cell.Column.Index + len];
ICell endCell = proxy.Grid[cell.MaxRowIndex, cell.Column.Index + len];
if (endCell == null)
{
endCell = begincell;
}
if (endCell != null)
{
SelectCellCollection selectcell = new SelectCellCollection();
selectcell.BeginCell = begincell;
selectcell.EndCell = endCell;
return selectcell.GetAllCells();
}
return null;
}
public virtual object CellFocused(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell cell = base.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (cell != null)
{
cell.Grid.FocusedCell = cell;
return Feng.Utils.Constants.OK;
}
return cell.Grid.FocusedCell;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellClear(params object[] args)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
cell.Clear();
return Feng.Utils.Constants.OK;
}
public virtual object CellTrim(params object[] args)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
cell.Value = cell.Text.Trim();
return Feng.Utils.Constants.OK;
}
public virtual object CellHide(params object[] args)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
cell.Visible = false;
return Feng.Utils.Constants.OK;
}
public virtual object CellShow(params object[] args)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
cell.Visible = true;
return Feng.Utils.Constants.OK;
}
public virtual object CellVisible(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.Visible = value;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.Visible;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellMerge(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell cellbegin = GetParamsCell(1, args) as ICell;
ICell cellend = GetParamsCell(2, args) as ICell;
IMergeCell mergeCell = cellbegin.Grid.MergeCell(cellbegin, cellend);
return mergeCell;
}
return null;
}
#warning 合相同内容
public virtual object CellUnMerge(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
IMergeCell mergeCell = null;
if (cell is IMergeCell)
{
mergeCell = cell as IMergeCell;
}
if (cell.OwnMergeCell != null)
{
mergeCell = cell.OwnMergeCell;
}
cell.Grid.UnMergeCell(mergeCell);
return Feng.Utils.Constants.OK;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellGetMergeCell(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell cell = base.GetArgIndex(1, args) as ICell;
if (cell != null)
{
return cell.OwnMergeCell;
}
}
return null;
}
public virtual object CellEdit(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy proxy = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (proxy != null)
{
ICell cell = this.GetCell(1, args);
if (cell == null)
{
cell = Cell(GetArgIndex(0, args), GetArgIndex(1, args)) as ICell;
}
if (args.Length == 3)
{
string shortname = base.GetTextValue(1, args);
ICellEditControl edit = Feng.Excel.Edits.EditControlBuilder.Build(cell.Grid, shortname);
cell.OwnEditControl = edit;
}
else
{
return cell.OwnEditControl;
}
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellReadOnly(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.ReadOnly = value;
cell.InhertReadOnly = false;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.ReadOnly;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellBackImage(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)
{
Bitmap value = this.GetArgIndex(2, args) as Bitmap;
if (cell != null)
{
cell.BackImage = value;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.BackImage;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellBackColor(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 = Feng.Utils.ConvertHelper.ToColor(this.GetIntValue(2, args));
if (cell != null)
{
cell.BackColor = value;
return Feng.Utils.Constants.OK;
}
}
else
{
return cell.BackColor;
}
return Feng.Utils.Constants.Fail;
}
public virtual object CellBorderOutside(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.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<object> values = base.GetArgIndex(2, args) as Feng.Collections.ListEx<object>;
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 < start + len; i++)
{
cell = value1.Grid[row, column];
cell.Value = values[i];
row++;
}
return Feng.Utils.Constants.OK;
}
List<ICell> cells = base.GetArgIndex(1, args) as List<ICell>;
if (cells != null)
{
for (int i = start, j = 0; (i < start + len) && j < cells.Count; i++, j++)
{
cell = cells[j];
cell.Value = values[i];
}
return Feng.Utils.Constants.OK;
}
return null;
}
public virtual object CellRefernce(params object[] args)
{
Feng.Excel.Script.DataExcelScriptStmtProxy value1 = args[0] as Feng.Excel.Script.DataExcelScriptStmtProxy;
if (value1 == null)
{
return null;
}
string targetfile = value1.Grid.FileName;
#warning 表格引用
return null;
}
private ICell GetParamsCell(int index, params object[] args)
{
ICell cell = base.GetArgIndex(index, args) as ICell;
if (cell != null)
{
return cell;
}
cell = Cell(GetArgIndex(0, args), GetArgIndex(index, args)) as ICell;
if (cell != null)
{
return cell;
}
return null;
}
public virtual object CellMoveUp(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)
{
CellMoveUp(cells, cell);
}
else if (step>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;
}
}
}
