public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
ExcelBot.Shared.GetWorkbookByName(wbName, true).Worksheets.Add(wsName);
}
public override void Execute(ActivityContext context)
{
var filePath = context.Get(this.FilePath);
var text = context.Get(this.Text);
File.WriteAllText(filePath, text);
}
public override void Execute(ActivityContext context)
{
var macro = context.Get(this.Macro).ToString();
var param1 = context.Get(this.Param1, null);
var param2 = context.Get(this.Param2, null);
var param3 = context.Get(this.Param3, null);
var param4 = context.Get(this.Param4, null);
var result = string.Empty;
// F*ck! The code below is ugly.
if (param1 == null)
{
result = ExcelBot.Shared.GetApp().Run(macro);
}
else if (param2 == null)
{
result = ExcelBot.Shared.GetApp().Run(macro, param1.ToString());
}
else if (param3 == null)
{
result = ExcelBot.Shared.GetApp().Run(macro, param1.ToString(), param2.ToString());
}
else if (param4 == null)
{
result = ExcelBot.Shared.GetApp().Run(macro, param1.ToString(), param2.ToString(), param3.ToString());
}
else
{
result = ExcelBot.Shared.GetApp().Run(macro, param1.ToString(), param2.ToString(), param3.ToString(), param4.ToString());
}
context.Set(this.Result, result);
}
public override void Execute(ActivityContext context)
{
var fromFilePath = context.Get(this.FromFilePath);
var toFilePath = context.Get(this.ToFilePath);
File.Copy(fromFilePath, toFilePath, true);
}
public override void Execute(ActivityContext context)
{
var x = context.Get(X);
var y = context.Get(Y);
context.Set(Element, true);
}
public override bool Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
return(ExcelBot.Shared.GetWorksheetByName(wbName, wsName, false) != null);
}
public override void Execute(ActivityContext context)
{
var fromFolderPath = context.Get(this.FromFolderPath);
var toFolderPath = context.Get(this.ToFolderPath);
Directory.Move(fromFolderPath, toFolderPath);
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wbNameAs = context.Get(this.WorkbookNameAs);
ExcelBot.Shared.GetWorkbookByName(wbName, true).SaveAs(wbNameAs);
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
var range = context.Get(this.Cell);
ExcelBot.Shared.GetRange(wbName, wsName, range).Copy();
}
public override void Execute(ActivityContext context)
{
var x = context.Get(this.X, 0);
var y = context.Get(this.Y, 0);
var w = context.Get(this.Width, 0);
var h = context.Get(this.Height, 0);
context.Set(this.Text, AIBot.ScreenToText(x, y, w, h));
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
var range = context.Get(this.Cell);
var value = ExcelBot.Shared.GetRange(wbName, wsName, range).Value?.ToString() ?? string.Empty;
context.Set(this.Value, value);
}
public override void Execute(ActivityContext context)
{
// inputs
var workbookName = (string)context.Get(this.WorkbookName);
var worksheetName = (string)context.Get(this.WorksheetName);
var rangeAddress = (string)context.Get(this.CellAddress);
var xlApp = ExcelBot.Shared.GetInstance();
var xlWb = ExcelBot.Shared.GetWorkbook(xlApp, workbookName);
var xlWs = ExcelBot.Shared.GetWorksheet(xlWb, worksheetName);
var rangeValue = xlWs.Range(rangeAddress).Value?.ToString() ?? string.Empty;
// outputs
context.Set(this.CellValue, rangeValue);
}
public override void Execute(ActivityContext context)
{
var query = ElementQuery.Get(this.Element);
var elements = WinContext.Shared.GetElementsFromQuery(query);
if (elements.Count() == 0)
{
throw new Exception("Element not found.");
}
if (elements.Count() > 1)
{
throw new Exception("Too many elements found.");
}
var e = elements.First() as WinElement;
var name = context.Get(this.PropertyName);
if (e.GetType().GetProperty(name, BindingFlags.Public | BindingFlags.Instance) is PropertyInfo pi)
{
context.Set(this.PropertyValue, pi.GetValue(e)?.ToString() ?? string.Empty);
}
else
{
throw new Exception(string.Format("Element property '{0}' not found.", name));
}
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
var range = context.Get(this.Cell);
var clearContentsOnly = context.Get(this.ClearContentsOnly, false);
if (clearContentsOnly)
{
ExcelBot.Shared.GetRange(wbName, wsName, range).ClearContents();
}
else
{
ExcelBot.Shared.GetRange(wbName, wsName, range).Clear();
}
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var wsName = context.Get(this.WorksheetName);
var range = context.Get(this.Cell);
var pasteType = context.Get(this.PasteValuesOnly, false);
if (pasteType)
{
ExcelBot.Shared.GetRange(wbName, wsName, range).PasteSpecial(XlPasteType.xlPasteValuesAndNumberFormats);
}
else
{
ExcelBot.Shared.GetRange(wbName, wsName, range).PasteSpecial();
}
}
public override void Execute(ActivityContext context)
{
// inputs
var workbookName = (string)context.Get(this.WorkbookName);
var worksheetName = (string)context.Get(this.WorksheetName);
var rowIndex = (int)context.Get(this.RowIndex);
var columnIndex = (int)context.Get(this.ColumnIndex);
var xlApp = ExcelBot.Shared.GetInstance();
var xlWb = ExcelBot.Shared.GetWorkbook(xlApp, workbookName);
var xlWs = ExcelBot.Shared.GetWorksheet(xlWb, worksheetName);
var cellValue = xlWs.Cells(rowIndex, columnIndex).Value?.ToString() ?? string.Empty;
// outputs
context.Set(this.CellValue, cellValue);
}
public override void Execute(ActivityContext context)
{
ClientContext clientContext = new ClientContext(context.Get(this.SiteUrl));
List list = clientContext.Web.Lists.GetByTitle(context.Get(this.ListTitle));
ListItem item = list.GetItemById(context.Get(this.ItemId));
clientContext.Load(item);
clientContext.ExecuteQuery();
item[context.Get(this.ColumnName)] = context.Get(this.ColumnValue);
item.Update();
clientContext.ExecuteQuery();
}
public override void Execute(ActivityContext context)
{
//TODO: Handle fields other than the Title field.
ClientContext clientContext = new ClientContext(context.Get(this.SiteUrl));
List list = clientContext.Web.Lists.GetByTitle(context.Get(this.ListTitle));
bool overwrite = context.Get(this.Overwrite, true);
FileCreationInformation fci = new FileCreationInformation();
fci.Content = System.IO.File.ReadAllBytes(context.Get(FilePath));
fci.Overwrite = overwrite;
clientContext.ExecuteQuery();
}
public override void Execute(ActivityContext context)
{
var query = ElementQuery.Get(this.Element);
if (query == null)
{
throw new Exception("Input 'Element' is required.");
}
var elements = WinContext.Shared.GetElementsFromQuery(query);
if (elements.Count() == 0)
{
throw new Exception("Element not found.");
}
if (elements.Count() > 1)
{
throw new Exception("Too many elements found.");
}
var text = context.Get(this.Text);
var e = elements.First() as WinElement;
e.Focus();
SendKeys.SendWait(text);
}
public override void Execute(ActivityContext context)
{
var from = context.Get(this.From, string.Empty);
var to = context.Get(this.To, string.Empty);
var cc = context.Get(this.Cc, string.Empty);
var bcc = context.Get(this.Bcc, string.Empty);
var subject = context.Get(this.Subject, string.Empty);
var body = context.Get(this.Body, string.Empty);
var attachment = context.Get(this.Attachment, string.Empty);
var isHtmlBody = context.Get(this.IsHtmlBody, false);
var isdraft = context.Get(this.IsDraft, false);
dynamic app = Activator.CreateInstance(Type.GetTypeFromProgID("Outlook.Application"));
var mailItem = app.CreateItem(0 /* OlItemType.olMailItem */);
if (from.ToString().Length > 0)
{
var fromAccount = app.Session.Accounts.Item(from.ToString());
if (fromAccount == null)
{
throw new Exception("Cannot find " + from + " account.");
}
mailItem.SendUsingAccount = fromAccount;
}
mailItem.To = to;
mailItem.CC = cc;
mailItem.BCC = bcc;
mailItem.Subject = subject;
if (isHtmlBody)
{
mailItem.HTMLBody = body;
}
else
{
mailItem.Body = body;
}
if (attachment.ToString().Length > 0)
{
mailItem.Attachments.Add(attachment.ToString(), 1 /* OlAttachmentType.olByValue */);
}
if (isdraft)
{
mailItem.Display();
}
else
{
mailItem.Send();
}
}
public override void Execute(ActivityContext context)
{
// inputs
var workbookName = (string)context.Get(this.WorkbookName);
var worksheetName = (string)context.Get(this.WorksheetName);
var cellAddress = (string)context.Get(this.CellAddress);
var cellValue = (string)context.Get(this.CellValue);
var xlApp = ExcelBot.Shared.GetInstance();
var xlWb = ExcelBot.Shared.GetWorkbook(xlApp, workbookName);
var xlWs = ExcelBot.Shared.GetWorksheet(xlWb, worksheetName);
xlWs.Range(cellAddress).Value = cellValue;
// outputs
//
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
var count = ExcelBot.Shared.GetWorkbookByName(wbName, true).Worksheets.Count;
context.Set(this.Count, count);
}
public override void Execute(ActivityContext context)
{
var e = context.GetElement(this.Element);
var text = context.Get(this.Text, string.Empty);
e.Focus();
SendKeys.SendWait(text);
}
public override void Execute(ActivityContext context)
{
// inputs
var workbookPath = context.Get(this.WorkbookPath);
var worksheetName = context.Get(this.WorksheetName);
var bot = ExcelBot.Shared;
var xlApp = bot.Get(workbookPath);
var xlWbs = xlApp.Workbooks;
var xlWb = xlWbs.Item[1];
var xlWss = xlWb.Worksheets;
var xlWs = xlWss.Add() as Worksheet;
xlWs.Name = worksheetName;
bot.Release(xlWss, xlWb, xlWbs);
// outputs
//
}
public override void Execute(ActivityContext context)
{
var value = context.Get(this.Value, string.Empty);
var e = context.GetElement(this.Element);
e.Focus();
e.Value = value;
}
public override void Execute(ActivityContext context)
{
// inputs
var workbookName = (string)context.Get(this.WorkbookName);
var saveChanges = (bool)context.Get(this.SaveChanges);
var xlApp = ExcelBot.Shared.GetInstance();
var xlWb = ExcelBot.Shared.GetWorkbook(xlApp, workbookName);
xlWb.Close(saveChanges);
if (xlApp.Workbooks.Count == 0)
{
ExcelBot.Shared.Dispose();
}
// outputs
//
}
public override void Execute(ActivityContext context)
{
var wbName = context.Get(this.WorkbookName);
ExcelBot.Shared.GetApp().Workbooks.Open(wbName);
if (ExcelBot.Shared.GetApp().Workbooks.Count == 0)
{
ExcelBot.Shared.Dispose();
}
}
public override void Execute(ActivityContext context)
{
var appPath = context.Get(this.AppPath);
var appArgs = context.Get(this.Arguments);
var p = Process.Start(appPath, appArgs);
while (p.MainWindowHandle == IntPtr.Zero)
{
try
{
p.WaitForInputIdle(1000);
}
catch (InvalidOperationException)
{
break;
}
p.Refresh();
}
}
public override void Execute(ActivityContext context)
{
ClientContext spContext = new ClientContext(context.Get(this.SiteUrl));
Web spWeb = spContext.Web;
ListCreationInformation lci = new ListCreationInformation();
lci.Title = context.Get(this.ListTitle);
lci.TemplateType = (int)ListTemplateType.DocumentLibrary;
List newList = spWeb.Lists.Add(lci);
try
{
spContext.ExecuteQuery();
}
catch
{
throw new NotImplementedException();
}
}
public override void Execute(ActivityContext context)
{
var filePath = context.Get(this.FilePath);
var fileInfo = new FileInfo(filePath);
context.Set(this.FileName, fileInfo.Name);
context.Set(this.FileExtension, fileInfo.Extension);
context.Set(this.FileSize, fileInfo.Length);
context.Set(this.CreationTime, fileInfo.CreationTime);
context.Set(this.LastAccessTime, fileInfo.LastAccessTime);
context.Set(this.LastWriteTime, fileInfo.LastWriteTime);
}
