/
Main.xaml
292 lines (292 loc) · 31.2 KB
/
Main.xaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
<Activity mc:Ignorable="sap sap2010" x:Class="Main" mva:VisualBasic.Settings="{x:Null}" sap:VirtualizedContainerService.HintSize="594.4,4824" sap2010:WorkflowViewState.IdRef="ActivityBuilder_1" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=mscorlib" xmlns:uasb="clr-namespace:UiPath.Activities.System.Binding;assembly=UiPath.System.Activities" xmlns:ue="clr-namespace:UiPath.Excel;assembly=UiPath.Excel.Activities" xmlns:ueab="clr-namespace:UiPath.Excel.Activities.Business;assembly=UiPath.Excel.Activities" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:uix="http://schemas.uipath.com/workflow/activities/uix" xmlns:um="clr-namespace:UiPath.Mail;assembly=UiPath.Mail.Activities" xmlns:umab="clr-namespace:UiPath.Mail.Activities.Business;assembly=UiPath.Mail.Activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<TextExpression.NamespacesForImplementation>
<scg:List x:TypeArguments="x:String" Capacity="48">
<x:String>System.Activities</x:String>
<x:String>System.Activities.Statements</x:String>
<x:String>System.Activities.Expressions</x:String>
<x:String>System.Activities.Validation</x:String>
<x:String>System.Activities.XamlIntegration</x:String>
<x:String>Microsoft.VisualBasic</x:String>
<x:String>Microsoft.VisualBasic.Activities</x:String>
<x:String>System</x:String>
<x:String>System.Collections</x:String>
<x:String>System.Collections.Generic</x:String>
<x:String>System.Data</x:String>
<x:String>System.Diagnostics</x:String>
<x:String>System.Drawing</x:String>
<x:String>System.IO</x:String>
<x:String>System.Linq</x:String>
<x:String>System.Security</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Activities.System.Binding</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>UiPath.Excel</x:String>
<x:String>UiPath.Word</x:String>
<x:String>System.Windows.Markup</x:String>
<x:String>UiPath.Mail</x:String>
<x:String>System.Xml.Serialization</x:String>
<x:String>UiPath.UIAutomationNext.Enums</x:String>
</scg:List>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<scg:List x:TypeArguments="AssemblyReference" Capacity="38">
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
<AssemblyReference>UiPath.Word.Activities</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>System.ValueTuple</AssemblyReference>
<AssemblyReference>System.ServiceModel</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
<AssemblyReference>UiPath.Mail.Activities</AssemblyReference>
<AssemblyReference>UiPath.Mail</AssemblyReference>
<AssemblyReference>UiPath.OmniPage.Activities.Design</AssemblyReference>
<AssemblyReference>UiPath.Word</AssemblyReference>
<AssemblyReference>UiPath.UIAutomationNext</AssemblyReference>
</scg:List>
</TextExpression.ReferencesForImplementation>
<ueab:SequenceX sap:VirtualizedContainerService.HintSize="604.8,4759.2" sap2010:WorkflowViewState.IdRef="SequenceX_1">
<ueab:SequenceX.Variables>
<Variable x:TypeArguments="ue:IWorkbookQuickHandle" Default="[new WorkbookQuickHandle(workbookPath:="Project_Notebook.xlsx",visible:=True,autoSave:=True,createNew:=True,readOnly:=False,isWorkspace:=True)]" Name="Notes" />
<Variable x:TypeArguments="uasb:BindingsRepository" Default="[new UiPath.Activities.System.Binding.BindingsRepository()]" Name="Saved" />
</ueab:SequenceX.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ueab:ExcelApplicationCard Password="{x:Null}" sap2010:Annotation.AnnotationText="With the help of this resource, we indicate the robot which Exce file to use." DisplayName="Use Excel File" sap:VirtualizedContainerService.HintSize="561.6,4668" sap2010:WorkflowViewState.IdRef="ExcelApplicationCard_1" WorkbookPath="Report.xlsx">
<ueab:ExcelApplicationCard.Body>
<ActivityAction x:TypeArguments="ue:IWorkbookQuickHandle">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="ue:IWorkbookQuickHandle" Name="TemplateReport" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="543.2,4404" sap2010:WorkflowViewState.IdRef="Sequence_1">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:ReadCsvFile Encoding="{x:Null}" sap2010:Annotation.AnnotationText="This activity, read a .CSV file, and copies the content in the Report excel file" DataTable="[TemplateReport.Sheet("Report").DataTableOutValue]" Delimitator="Comma" DisplayName="Read CSV" FilePath="Product Export.csv" sap:VirtualizedContainerService.HintSize="500,200" sap2010:WorkflowViewState.IdRef="ReadCsvFile_1">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ui:ReadCsvFile>
<ueab:WriteCellX sap2010:Annotation.AnnotationText="Here we add a new header. Since it's the last column and tehre are no written columns following, we don't need to use the "Insert Culumn" action." Cell="[TemplateReport.Sheet("Report").Cell("F1")]" DisplayName="Write Cell" sap:VirtualizedContainerService.HintSize="500,225.6" sap2010:WorkflowViewState.IdRef="WriteCellX_1" Value="[string.Format("Total Sales USD")]">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:WriteCellX>
<uix:NApplicationCard OpenMode="{x:Null}" sap2010:Annotation.AnnotationText="With this activity we tell the robot which browser to use, and what page to open." CloseMode="Always" DisplayName="Use Browser Chrome: currency TO USD - Google Search" sap:VirtualizedContainerService.HintSize="500,1134.4" sap2010:WorkflowViewState.IdRef="NApplicationCard_1">
<uix:NApplicationCard.Body>
<ActivityAction x:TypeArguments="x:Object">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="x:Object" Name="WSSessionData" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="461.6,885.6" sap2010:WorkflowViewState.IdRef="Sequence_3">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ueab:ExcelForEachRow sap2010:Annotation.AnnotationText="We go through all the rows from the Converter sheet. Because we need to use the row data to search and retrieve information from the browser, the activity sits inside the Use Browser resource." DisplayName="Excel For Each Row" EmptyRowBehavior="Stop" HasHeaders="False" sap:VirtualizedContainerService.HintSize="418.4,794.4" sap2010:WorkflowViewState.IdRef="ExcelForEachRow_1" Range="[TemplateReport.Table("Converter")]" SaveAfterEachRow="False">
<ueab:ExcelForEachRow.Body>
<ActivityAction x:TypeArguments="ue:CurrentRowQuickHandle, x:Int32">
<ActivityAction.Argument1>
<DelegateInArgument x:TypeArguments="ue:CurrentRowQuickHandle" Name="CurrentRow" />
</ActivityAction.Argument1>
<ActivityAction.Argument2>
<DelegateInArgument x:TypeArguments="x:Int32" Name="CurrentIndex" />
</ActivityAction.Argument2>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="400,548.8" sap2010:WorkflowViewState.IdRef="Sequence_2">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<uix:NTypeInto ClickBeforeMode="{x:Null}" DelayBetweenKeys="{x:Null}" EmptyFieldMode="{x:Null}" ActivateBefore="True" sap2010:Annotation.AnnotationText="We type into the Goole search bar data from the Excel file." DisplayName="Type Into 'INPUT'" sap:VirtualizedContainerService.HintSize="356.8,212" sap2010:WorkflowViewState.IdRef="NTypeInto_1" Text="[string.Format("{0} To USD{1}", CurrentRow.ByField("Currency"), "[k(enter)]".ToString().ToString)]">
<uix:NTypeInto.Target>
<uix:TargetAnchorable DesignTimeRectangle="189, 105, 533, 34" ElementType="InputBox" FriendlyName="'INPUT'" FullSelectorArgument="<html app='chrome.exe' title='currency TO USD - Google Search' /><webctrl name='q' tag='INPUT' type='text' />" FuzzySelectorArgument="<html app='chrome.exe' title='currency TO USD - Google Search' /><webctrl name='q' tag='INPUT' type='text' aaname='Search' />" ImageBase64="iVBORw0KGgoAAAANSUhEUgAAAhkAAAAmCAYAAABpqYnaAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAOESURBVHhe7dpbbqMwAAXQ2Up3V2l2U2Uj6T7abVTqJpgAJuAHNmTqUdU5R+IjiWNj8nFvSH4NAAAdKBkAQBdKBgDQhZIBAHShZAAAXSgZAEAXSgYA0IWSAQB0oWQAAF0oGQBAF0oGANCFkgEAdKFkRD6H6++n4empflzew/Dg7SUdcxnewmtV75fb2Ofh+hEeR8K5vCQzTe9J1kvHfFyH53RMOJ5fP8MgAOhLyah6Gy7VYJ5ff/p9vVWC1efr8xToaRnJnCwZ87zp+DBuew6hZOTrh/NNSwkAdKBkVNVKxs6dhkW1QASnSsb8uHguaanYLRk3tdcA4AtlJWP5Fp7fXi+H3PRTwf1b9Dzm8rrerh/DbJrz5TqH5vj8PTjDN+vlSO4IzCF8Gd6SnwiygEx/Hljm2QnUeY9HftKolIxmiWiUkNGpklErPIlGkYg/MwDoIyoZ838LtuG7DbbjJSMNzqW4xO8NBWMTwtn6S7nYBOLemG2grudUCvoD4X+3H+zTnhpB3RxzqmQse1/2VtEoGcdLFgA8blMy5kDdC6Yl9A6VjCTAS6FWDrok1EshnATotH6lMGTrNAI4tl8y4n2XNcP8ZMkY3YvG5sj20trjtK6SAUBfa8moBt7oeMlIx0xhGwVyOUBHUWkohWEUoPsl4C4J3GbwR75fyVjN57aWjc06SgYA30BSMmrB06FkRCG5OU6WjN0wDdbi0gru1H7JyPeUa445UDKqBWoxzbMZ2ygZ54oWADzm293JiBwsGc0gXuZpfcPPVOY/eL2qe5zOZ2+Og3ubJGs19hndLQKATtaS0QzgUmiG506XjLScLJL3N0tG6ZxKwh2Pl8J8VbWgb6zdLCGjcF6la54WkOp8yXWrfZbNzxkAvsbmj58h+KMQjoM0fX2+7X577oGSsQTsNqSz2/jNknEzjYlDM5vnZj73eL221t2EsIdkb8t1ORLk89i0POTX5jZy/izS6zFKr9NukSjNCwB9RCVjtATk/SgG3fraNP6hkjEKoXc/kgA9UjJG4bndeUaFMtLWKhmze4GprV8Tzm177K2ZfT7jkZaG7HqsR2svAPBVspLxU83hfDL8AYCH/Sclo3yHBQDo58eXjMf+iwEA/K3/5ucSAODfUjIAgC6UDACgCyUDAOhCyQAAulAyAIAulAwAoAslAwDoQskAALpQMgCALpQMAKCDYfgDROlLZ2B5b8QAAAAASUVORK5CYII=" InformativeScreenshot="ff792095504bae0fd3dc5e7939e259e0.png" SearchSteps="Selector, FuzzySelector, Image" />
</uix:NTypeInto.Target>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</uix:NTypeInto>
<uix:NGetText sap2010:Annotation.AnnotationText="We retrieve the exchange rate from the Google Results page." DisplayName="Get Text 'Afghan AfghaniAlbanian'" sap:VirtualizedContainerService.HintSize="356.8,205.6" sap2010:WorkflowViewState.IdRef="NGetText_1">
<uix:NGetText.Target>
<uix:TargetAnchorable DesignTimeRectangle="206, 468, 143, 38" ElementType="InputBox" FriendlyName="'INPUT'" FullSelectorArgument="<html app='chrome.exe' title='JPY To USD - Google Search' /><webctrl tableRow='3' tag='INPUT' type='number' />" FuzzySelectorArgument="<html app='chrome.exe' title='JPY To USD - Google Search' /><webctrl aaname='' tag='INPUT' type='number' />" InformativeScreenshot="90a7d20ca5465a9bdc135fa4422cd29e.png" SearchSteps="Selector, FuzzySelector">
<uix:TargetAnchorable.Anchors>
<scg:List x:TypeArguments="uix:ITarget" Capacity="4">
<uix:Target DesignTimeRectangle="360, 467, 146, 40" FriendlyName="'Afghan AfghaniAlbanian'" FullSelectorArgument="<html app='chrome.exe' title='JPY To USD - Google Search' /><webctrl parentid='knowledge-currency__updatable-data-column' tag='TABLE' /><webctrl tableCol='3' tableRow='3' tag='TD' />" FuzzySelectorArgument="<html app='chrome.exe' title='JPY To USD - Google Search' /><webctrl parentid='knowledge-currency__updatable-data-column' tag='TABLE' /><webctrl type='' aaname='' tag='TD' check:text='Afghan AfghaniAlbanian LekAlgerian DinarAngolan KwanzaArgentine PesoArmenian DramAruban' />" ImageBase64="iVBORw0KGgoAAAANSUhEUgAAAJYAAAAsCAYAAACHUEHxAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAOkSURBVHhe7ZxZahtBEIZzFAd0MYEOkJe85F3MVYx9gRDICYR8hSzgCPQUY5M4tpXOVHdPT1X1MovVliH/Bw0aTS+lqm96JgTPGwNABSAWqALEAlXIivXz5tZc7/bm6/cf5su3azS00MgJcoMcyRGJ9fD4aAfd3N6Zw+Gv/xaAmF+/760r5IwmEos63v958EcAlHl6OlhnNEIs2tpopwJgCrRz6duiEIvMw+0PzEHvWkIseigDYA7aHSEWPfEDMAftDsQCRwFigSpALFAFiAWqALFAFSAWqALEAlWoINaVWb9dmPXGHwZy38dsm4U5a6780Xz2lytztrww8f9cOez5NqbQjrDm0dhdmCWPbXKMe3O+XJjlJf16/vllePViDclRojTWSdWYrT8mhNC2sCtzvnOHRab0HUtyTpfDcXJBrCK1xEruiraYXrZXKVbL6LXmifXx02fz7v2HYqM+Q5xMLFfYxl2BtvXJCkXfNP0tIAjir1rf5Dougd1862bajtXD11BxRd+P6MsFtmL057IXWlYgnd9cPgpiqRj0BVaSa4xUxGnF0oXwEgSxWuSuk0pQP4fs6xOeEaubKyRX99OFJclZHx5jOY64wCE3dlxGbr1+IJ4v5MNeiN2YXL9UDPE6KbnGSkWceMfqrxRejKxYiUJQ32SSW2SBC9h5vWAZWSRurXRfVTgiSOnHjY5pQKyoD89B7rNCyCjhck2RiqggVu5HHEEsfmvkzfZNCK12mUG8YHYOXTR/zq25Msv2N6bF8jtl1LoLwuUnfJ+LL5Kmg/1Omw9+oY0Ty+Y3rN/+loxYBAk1VSri5cRSiZollp0j91wUr5vfsag4A0UbiFcci74uDiF4FrdelCsiJxbfYaI+OZnYZz0mt84zqSCWL6gK1haCFXmWWCJZhCyMW1ftDEmx/BpKUjFeJVzEb8+x+FVfGTMfy8S1uBiTEiYL7sb3eVP5ELc1fo599rF3a7o86HWeTxWxCFckCto3VWAuD8GLIc51RQwS+OR2jc1BuES5tm7/1anX5ZRj9GLSPGEH6/tthTyqbwuPQwjM56Gm4g/ofr71F1WHzIeWNhKrReRoo2U/DtXEAv83EAtUAWKBKkAsUAWIBaoAsUAVIBaoAsQCVSiKhT+xB3Mp/ok9XgoC5lJ8KQheYwTmMPgaI4LMw4vXwFhGvXiNwKsiwVgmvSqyg7Y2GkQPZfTEj4bWNXKC3NC3P05WLACeA8QCVYBYoALG/AN4bvFCQ1mpZQAAAABJRU5ErkJggg==" SearchSteps="Selector, FuzzySelector, Image, TextFindAll" Text="Afghan AfghaniAlbanian LekAlgerian DinarAngolan KwanzaArgentine PesoArmenian DramAruban" TextMethod="AttributeText" TextSelector="<webctrl type='' tag='TD' />" />
</scg:List>
</uix:TargetAnchorable.Anchors>
</uix:TargetAnchorable>
</uix:NGetText.Target>
<uix:NGetText.Text>
<OutArgument x:TypeArguments="ue:ExcelValue">[CurrentRow.ByField("Conversion")]</OutArgument>
</uix:NGetText.Text>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</uix:NGetText>
</Sequence>
</ActivityAction>
</ueab:ExcelForEachRow.Body>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:ExcelForEachRow>
</Sequence>
</ActivityAction>
</uix:NApplicationCard.Body>
<uix:NApplicationCard.TargetApp>
<uix:TargetApp BrowserType="Chrome" IconBase64="iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAARHSURBVFhHvZddbBRVFMf7YrAq+OSbD6Kgb0qUUh60xq9VtA8k1EJrH1CsGIM+GLUmBA0kFi0WSMCHLcVCTMO2GmjFCiUFpH60sUjMEtIGLaAWama32w92dt2vOf7PndPd3M7sdmobf8k/M/fec8//zJ07s7NFXrEsawlUnclkmqEBaAxKisLS14yYKo6VafMHyR5A4hYoTh5BbAw6iLnLJc3cQZ7bkKQRSttp5w7mpqBdKKRY0noDE+7HxEuSZ94gVxA5l0n6wiDwYUwIyVyN9I0RMls/p4l33qDwi8+R4VtNxjOlFF7no/G3XyfzcBOlR/6UaB3kNHBYITbuyJU7zNOj12ly+/tkPL2KjKdKCgsxkx++p+bMhIvIuxIYuB0BjmWPn+qi0Atl7mYFFCp/nP45e0qy5IAH3w7nnsBAo8RkMY8cck3uVVMN2yWTDrwaxNYGFfGjpu12vnK3pKxIbRVFD+yj+DdHKd51DOf7KfJatRYztbueyLIkmw68UtqtQEeLjCl4s4Wef0xLyBqrWUuJ8/0S5SQx0EfhDeV0c/+n0pMfeDYrc5zfiYb2konufdNhPr7lZbKmpiQiP5YZlbPCwNPEKizm5a+WPoUVG6ZU9yKarLsna86PXGYiIhELB7zX8/I3S1uRuVpPqZ5blMx9d1FozUqKnzwuowsLvP1cwIC0FelffNkCWImjS4lSKRldWODdzwWMSVuR6r1bKyB9sUpG3Hnyo6hnnb2kXwi8DS4gKW1F6vQirYDM79tkxB03o3xq/VGz4gIS/2sBLecSMstmuoCwtBWOWxDcICPuuBnlU3u/YwXULdA34YVntQJGeh+kZGbum/CKkXEUcG7QsQfUJpzxGH6cNT/etZQeDayljuEeGfVOoC/pKGB0Qn81w9vPLyJtm1uxqxTrKab6jkdoZWCdkq/jFQrHxyVidm7GLarYa2rmG/0xGc0B70ouYAkq0Ub39O3Imk+rpvtdmkjM/ipO4iet7khcM2e1Oe+/icMd6vcAjYN2t82NqEFlX73kKKL8683Ue/28RDm5PH6NNnUGYDipmfNqxBKO5W9S5gxWYTk6tB1y4lqvo4BpVXz7FjVeaKH2yyfoy99O0mfBVnq1ZyuVBCrUeOmhOnrik7+yBXw/pH/XwisJz/vE3gadu2Q8yxdDnQ5zrypp3Uhlu392PPsMvHaKbQ7082f4RTskR/cfP+B21LiaFFJpWyUdCHZKlhzw+BWHW8VWB8uyDAH89aoxaoZo6097aFWbvcSzafOZD2gwMiyzcyD33zjcK3buIGCFWxEMb87Dg8doy3c7aE1nLa1ur1RX6uvYRLWnt6m9MBS5ItE6bI4LfEhsCiMrEZS58wa5eNkLX/lMUEQxJjZA//ljAHP5j+tOnLrfcy/IavA/Yn5xeIJjoSbM1R+1+YBki6H1SOyH+iEDSoj4nPv8iKlEDfYbblaKiv4FoeF/NqqvoEMAAAAASUVORK5CYII=" InformativeScreenshot="cc1eadce2e148f011671c9d79559ab6e.png" Selector="<html app='chrome.exe' title='currency TO USD - Google Search'/>" Url="https://www.google.com/search?safe=off&rlz=1C1CHBF_enRO876RO876&sxsrf=ALeKk03Cw5BfvH0f0LjgaGIT2liHtlXtMA%3A1586444182736&ei=ljePXqLFLPLErgSLkbrADA&q=currency+TO+USD&oq=currency+TO+USD&gs_lcp=CgZwc3ktYWIQAzIGCAAQBxAeMgYIABAHEB4yBggAEAcQHjIGCAAQBxAeMgYIABAHEB4yBggAEAcQHjIGCAAQBxAeMgYIABAHEB4yBggAEAcQHjIGCAAQBxAeOgQIABBHOggIABAHEAoQHkoSCBcSDjgtMTI2Zzk3Zzc0ZzkwSg0IGBIJOC0xZzFnN2cxUMotWJA5YLY7aAFwAngAgAF7iAH9BpIBAzYuM5gBAKABAaoBB2d3cy13aXo&sclient=psy-ab&ved=0ahUKEwii6N6PzdvoAhVyoosKHYuIDsgQ4dUDCAw&uact=5" />
</uix:NApplicationCard.TargetApp>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</uix:NApplicationCard>
<ueab:ExcelForEachRow sap2010:Annotation.AnnotationText="Just as before, we go through all the rows from a specific sheet" DisplayName="Excel For Each Row" EmptyRowBehavior="Stop" HasHeaders="True" sap:VirtualizedContainerService.HintSize="500,896.8" sap2010:WorkflowViewState.IdRef="ExcelForEachRow_2" Range="[TemplateReport.Sheet("Report")]" SaveAfterEachRow="False">
<ueab:ExcelForEachRow.Body>
<ActivityAction x:TypeArguments="ue:CurrentRowQuickHandle, x:Int32">
<ActivityAction.Argument1>
<DelegateInArgument x:TypeArguments="ue:CurrentRowQuickHandle" Name="CurrentRow" />
</ActivityAction.Argument1>
<ActivityAction.Argument2>
<DelegateInArgument x:TypeArguments="x:Int32" Name="CurrentIndex" />
</ActivityAction.Argument2>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="461.6,680" sap2010:WorkflowViewState.IdRef="Sequence_4">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ueab:VLookupX sap2010:Annotation.AnnotationText="For each row, we perform a VLookup. The VLookup activity works just as the Excel VLookup formula.
" ColumnIndex="[2]" DisplayName="VLookup" ExactMatch="True" sap:VirtualizedContainerService.HintSize="418.4,323.2" sap2010:WorkflowViewState.IdRef="VLookupX_1" Label="[CurrentRow.ByField("Currency")]" SourceRange="[TemplateReport.Table("Converter")]">
<ueab:VLookupX.Value>
<OutArgument x:TypeArguments="ue:ExcelValue">[Saved.Values(Of ExcelValue)("Value from VLookup")]</OutArgument>
</ueab:VLookupX.Value>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:VLookupX>
<ueab:WriteCellX sap2010:Annotation.AnnotationText="We write with this activity a basic math formula in a specific cell. Because this action is inside the For Each Row, the formula will be added to all the cells from the column." Cell="[CurrentRow.ByField("Total Sales USD")]" DisplayName="Write Cell" sap:VirtualizedContainerService.HintSize="418.4,225.6" sap2010:WorkflowViewState.IdRef="WriteCellX_3" Value="[string.Format("={0}*{1}*{2}", CurrentRow.ByField("Quantity"), CurrentRow.ByField("Price"), Saved.Values(Of ExcelValue)("Value from VLookup"))]">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:WriteCellX>
</Sequence>
</ActivityAction>
</ueab:ExcelForEachRow.Body>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:ExcelForEachRow>
<ueab:CreatePivotTableX sap2010:Annotation.AnnotationText="The create Pivot Table activity works just as the Create Pivot option from Excel." DestinationRange="[TemplateReport.Sheet("Pivot")]" DisplayName="Create Pivot Table" sap:VirtualizedContainerService.HintSize="500,428.8" sap2010:WorkflowViewState.IdRef="CreatePivotTableX_2" Range="[TemplateReport.Sheet("Report").Range("A:F")]" TableName="Countries Sales Overview" ValuesMode="Columns">
<ueab:CreatePivotTableX.Body>
<ActivityAction>
<Sequence DisplayName="Do" sap2010:WorkflowViewState.IdRef="Sequence_6">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ueab:PivotTableFieldX DisplayName="Pivot Field" FieldName="Location" Function="Sum" sap:VirtualizedContainerService.HintSize="382.4,63.2" sap2010:WorkflowViewState.IdRef="PivotTableFieldX_3" Type="Row" />
<ueab:PivotTableFieldX DisplayName="Pivot Field" FieldName="Total Sales USD" Function="Sum" sap:VirtualizedContainerService.HintSize="382.4,63.2" sap2010:WorkflowViewState.IdRef="PivotTableFieldX_4" Type="Value" />
</Sequence>
</ActivityAction>
</ueab:CreatePivotTableX.Body>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:CreatePivotTableX>
<ui:GetFileInfoX sap2010:Annotation.AnnotationText="This activity gets the file's information and we will use it later to create a copy of the document and rename it." DisplayName="Get File Info" FilePath="Report.xlsx" sap:VirtualizedContainerService.HintSize="500,179.2" sap2010:WorkflowViewState.IdRef="GetFileInfoX_1" Output="[Saved.Values(Of FileInfo)("TemplateInformation")]">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ui:GetFileInfoX>
<ui:CopyFile ContinueOnError="{x:Null}" sap2010:Annotation.AnnotationText="We create a copy of the document and rename it adding the date to the file's name." Destination="[string.Format("Reports\{0}{1}", Notes.Sheet("Date").Cell("YYYYMMDD"), Saved.Values(Of FileInfo)("TemplateInformation").Name)]" DisplayName="Copy File" sap:VirtualizedContainerService.HintSize="500,204.8" sap2010:WorkflowViewState.IdRef="CopyFile_1" Overwrite="True" Path="[Saved.Values(Of FileInfo)("TemplateInformation").FullName]">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ui:CopyFile>
<umab:OutlookApplicationCard Account="{x:Null}" sap2010:Annotation.AnnotationText="We use this resource to indicate which Outlook account to send an email from. Because we will insert data from the Excel file, it sits inside the Use Excel File resource." DisplayName="Use Outlook Account" sap:VirtualizedContainerService.HintSize="500,763.2" sap2010:WorkflowViewState.IdRef="OutlookApplicationCard_1">
<umab:OutlookApplicationCard.Body>
<ActivityAction x:TypeArguments="um:IMailQuickHandle">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="um:IMailQuickHandle" Name="Outlook" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="461.6,520.8" sap2010:WorkflowViewState.IdRef="Sequence_7">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<umab:SendMailX Bcc="{x:Null}" Cc="{x:Null}" Account="[Outlook]" sap2010:Annotation.AnnotationText="This activity send an email with attachments." Body="[string.Format("Total sales for today are {0} USD.", TemplateReport.Sheet("Pivot").Cell("B8"))]" DisplayName="Send Outlook Email" sap:VirtualizedContainerService.HintSize="418.4,429.6" sap2010:WorkflowViewState.IdRef="SendMailX_1" IsDraft="False" MaxBodyDocumentSizeMB="2" Subject="[string.Format("Total Sales For {0}", Notes.Sheet("Date").Cell("YYYYMMDD"))]" To="sam.barnes@uipath.com">
<umab:SendMailX.Files>
<scg:List x:TypeArguments="InArgument(x:String)" Capacity="4">
<InArgument x:TypeArguments="x:String">[string.Format("Reports\{0}{1}", Notes.Sheet("Date").Cell("YYYYMMDD"), Saved.Values(Of FileInfo)("TemplateInformation").Name)]</InArgument>
</scg:List>
</umab:SendMailX.Files>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</umab:SendMailX>
</Sequence>
</ActivityAction>
</umab:OutlookApplicationCard.Body>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</umab:OutlookApplicationCard>
</Sequence>
</ActivityAction>
</ueab:ExcelApplicationCard.Body>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</ueab:ExcelApplicationCard>
</ueab:SequenceX>
</Activity>