protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); Utils.CheckArgs(args.Count, 2, m_name); SfExcel excel = args[0] as SfExcel; Utils.CheckNotNull(excel, m_name); Variable sheet = Utils.GetSafeVariable(args, 1); if (sheet.Type == Variable.VarType.NUMBER) { int index = sheet.AsInt(); excel.ActivateWorksheet(index); } else { string name = sheet.AsString(); excel.ActivateWorksheet(name); } ParserFunction.UpdateFunction(excel); return(excel); }
protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); int numberSheets = Utils.GetSafeInt(args, 0, 1); SfExcel excel = new SfExcel(numberSheets); return(excel); }
protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); Utils.CheckArgs(args.Count, 1, m_name); string filename = Utils.GetSafeString(args, 0); SfExcel excel = new SfExcel(); excel.Open(filename); return(excel); }
protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); Utils.CheckArgs(args.Count, 2, m_name); SfExcel excel = args[0] as SfExcel; Utils.CheckNotNull(excel, m_name); string sheetName = Utils.GetSafeString(args, 1); excel.SetWorksheetName(sheetName); ParserFunction.UpdateFunction(excel); return(excel); }
protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); Utils.CheckArgs(args.Count, 3, m_name); SfExcel excel = args[0] as SfExcel; Utils.CheckNotNull(excel, m_name); string cell = Utils.GetSafeString(args, 1); string option = Utils.GetSafeString(args, 2); string value = Utils.GetSafeString(args, 3, ""); excel.SetValue(cell, option, value); ParserFunction.UpdateFunction(excel); return(excel); }
protected override Variable Evaluate(ParsingScript script) { List <Variable> args = script.GetFunctionArgs(); Utils.CheckArgs(args.Count, 3, m_name); SfExcel excel = args[0] as SfExcel; Utils.CheckNotNull(excel, m_name); string range = Utils.GetSafeString(args, 1); string title = Utils.GetSafeString(args, 2); int top = Utils.GetSafeInt(args, 3); int bottom = Utils.GetSafeInt(args, 4); int left = Utils.GetSafeInt(args, 5); int right = Utils.GetSafeInt(args, 6); excel.AddChart(range, title, top, bottom, left, right); ParserFunction.UpdateFunction(excel); return(excel); }
public override Variable Clone() { SfExcel newVar = (SfExcel)this.MemberwiseClone(); return(newVar); }