-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathMain.xaml
More file actions
399 lines (399 loc) · 30.9 KB
/
Copy pathMain.xaml
File metadata and controls
399 lines (399 loc) · 30.9 KB
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
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
<Activity mc:Ignorable="sap sap2010" x:Class="Main" VisualBasic.Settings="{x:Null}" sap2010:WorkflowViewState.IdRef="ActivityBuilder_1" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:s="clr-namespace:System;assembly=System.Private.CoreLib" 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=System.Private.CoreLib" xmlns:sco="clr-namespace:System.Collections.ObjectModel;assembly=System.Private.CoreLib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data.Common" xmlns:str="clr-namespace:System.Text.RegularExpressions;assembly=System.Text.RegularExpressions" xmlns:ue="clr-namespace:UiPath.Excel;assembly=UiPath.Excel.Activities" xmlns:ueab="clr-namespace:UiPath.Excel.Activities.Business;assembly=UiPath.Excel.Activities" xmlns:uga="clr-namespace:UiPath.GSuite.Activities;assembly=UiPath.GSuite.Activities" xmlns:ugage="clr-namespace:UiPath.GSuite.Activities.Gmail.Enums;assembly=UiPath.GSuite.Activities" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:upap="clr-namespace:UiPath.PDF.Activities.PDF;assembly=UiPath.PDF.Activities" xmlns:upr="clr-namespace:UiPath.Platform.ResourceHandling;assembly=UiPath.Platform" xmlns:usau="clr-namespace:UiPath.Shared.Activities.Utils;assembly=UiPath.GSuite.Activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<TextExpression.NamespacesForImplementation>
<sco:Collection x:TypeArguments="x:String">
<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.Collections.ObjectModel</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.Net.Mail</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>System.Windows.Markup</x:String>
<x:String>GlobalVariablesNamespace</x:String>
<x:String>GlobalConstantsNamespace</x:String>
<x:String>System.Reflection</x:String>
<x:String>System.Linq.Expressions</x:String>
<x:String>System.Runtime.Serialization</x:String>
<x:String>System.ComponentModel</x:String>
<x:String>System.Xml.Serialization</x:String>
<x:String>UiPath.DataTableUtilities</x:String>
<x:String>UiPath.PDF.Activities.PDF</x:String>
<x:String>UiPath.Platform.ResourceHandling</x:String>
<x:String>UiPath.PDF.Activities</x:String>
<x:String>System.Numerics</x:String>
<x:String>System.Text.RegularExpressions</x:String>
<x:String>UiPath.Excel</x:String>
<x:String>UiPath.Excel.Activities.Business</x:String>
<x:String>System.Security</x:String>
<x:String>UiPath.Excel.Model</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Excel.Enums</x:String>
<x:String>UiPath.Shared.Activities.Utils</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Files.Enums</x:String>
<x:String>UiPath.MicrosoftOffice365.Files.Models</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Files.Models</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Excel</x:String>
<x:String>UiPath.Shared.Activities</x:String>
<x:String>UiPath.Shared.Activities.ConnectionService.Contracts</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Contracts</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Files.Contracts</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities</x:String>
<x:String>Newtonsoft.Json</x:String>
<x:String>UiPath.GSuite.Activities.Gmail.Enums</x:String>
<x:String>UiPath.GSuite.Activities</x:String>
<x:String>DocumentFormat.OpenXml.Office2010.Excel</x:String>
<x:String>DocumentFormat.OpenXml</x:String>
<x:String>UiPath.Platform</x:String>
<x:String>Microsoft.VisualBasic.CompilerServices</x:String>
<x:String>Microsoft</x:String>
<x:String>Microsoft.Win32.SafeHandles</x:String>
<x:String>System.Net</x:String>
<x:String>System.Globalization</x:String>
<x:String>System.Configuration.Assemblies</x:String>
<x:String>System.CodeDom.Compiler</x:String>
<x:String>System.Buffers</x:String>
<x:String>System.Buffers.Text</x:String>
<x:String>System.Buffers.Binary</x:String>
<x:String>System.Threading</x:String>
<x:String>System.Threading.Tasks</x:String>
<x:String>System.Threading.Tasks.Sources</x:String>
<x:String>System.Text</x:String>
<x:String>System.Text.Unicode</x:String>
<x:String>System.Security.Principal</x:String>
<x:String>System.Security.Permissions</x:String>
<x:String>System.Security.Cryptography</x:String>
<x:String>System.Runtime</x:String>
<x:String>System.Runtime.Remoting</x:String>
<x:String>System.Runtime.ExceptionServices</x:String>
<x:String>System.Runtime.ConstrainedExecution</x:String>
<x:String>System.Runtime.Versioning</x:String>
<x:String>System.Runtime.Loader</x:String>
<x:String>System.Runtime.Intrinsics</x:String>
<x:String>System.Runtime.Intrinsics.Wasm</x:String>
<x:String>System.Runtime.Intrinsics.Arm</x:String>
<x:String>System.Runtime.Intrinsics.X86</x:String>
<x:String>System.Runtime.InteropServices</x:String>
<x:String>System.Runtime.InteropServices.ObjectiveC</x:String>
<x:String>System.Runtime.InteropServices.Marshalling</x:String>
<x:String>System.Runtime.InteropServices.ComTypes</x:String>
<x:String>System.Runtime.CompilerServices</x:String>
<x:String>System.Resources</x:String>
<x:String>System.Reflection.Metadata</x:String>
<x:String>System.Reflection.Emit</x:String>
<x:String>System.IO.Enumeration</x:String>
<x:String>System.Diagnostics.SymbolStore</x:String>
<x:String>System.Diagnostics.Contracts</x:String>
<x:String>System.Diagnostics.CodeAnalysis</x:String>
<x:String>System.Diagnostics.Tracing</x:String>
<x:String>System.Collections.Concurrent</x:String>
<x:String>Internal</x:String>
<x:String>System.CodeDom</x:String>
<x:String>Microsoft.CSharp</x:String>
<x:String>System.Linq.Expressions.Interpreter</x:String>
<x:String>System.Dynamic</x:String>
<x:String>System.ComponentModel.Design.Serialization</x:String>
<x:String>System.Security.Authentication.ExtendedProtection</x:String>
<x:String>System.Timers</x:String>
<x:String>System.ComponentModel.Design</x:String>
<x:String>System.Xml.Schema</x:String>
<x:String>System.Xml.Xsl</x:String>
<x:String>System.Xml.Xsl.Runtime</x:String>
<x:String>System.Xml.XPath</x:String>
<x:String>System.Xml.Resolvers</x:String>
<x:String>Microsoft.CodeAnalysis</x:String>
<x:String>Microsoft.CodeAnalysis.VisualBasic</x:String>
<x:String>Microsoft.CodeAnalysis.VisualBasic.Syntax</x:String>
<x:String>Microsoft.VisualBasic.FileIO</x:String>
<x:String>System.Security.Authentication</x:String>
<x:String>System.Net.Cache</x:String>
<x:String>System.Net.NetworkInformation</x:String>
<x:String>System.Net.Security</x:String>
<x:String>System.Net.Sockets</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Mail.Models</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Mail.Enums</x:String>
<x:String>UiPath.MicrosoftOffice365.Activities.Mail</x:String>
</sco:Collection>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<sco:Collection x:TypeArguments="AssemblyReference">
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>System.ComponentModel.TypeConverter</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System.Data.Common</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Drawing.Common</AssemblyReference>
<AssemblyReference>System.Drawing.Primitives</AssemblyReference>
<AssemblyReference>System.Linq</AssemblyReference>
<AssemblyReference>System.Net.Mail</AssemblyReference>
<AssemblyReference>System.ObjectModel</AssemblyReference>
<AssemblyReference>System.Private.CoreLib</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>UiPath.Studio.Constants</AssemblyReference>
<AssemblyReference>System.Reflection.DispatchProxy</AssemblyReference>
<AssemblyReference>System.Reflection.TypeExtensions</AssemblyReference>
<AssemblyReference>System.Reflection.Metadata</AssemblyReference>
<AssemblyReference>UiPath.Workflow</AssemblyReference>
<AssemblyReference>System.Console</AssemblyReference>
<AssemblyReference>System.Security.Permissions</AssemblyReference>
<AssemblyReference>System.Configuration.ConfigurationManager</AssemblyReference>
<AssemblyReference>System.ComponentModel</AssemblyReference>
<AssemblyReference>System.Memory</AssemblyReference>
<AssemblyReference>System.Private.Uri</AssemblyReference>
<AssemblyReference>System.Private.ServiceModel</AssemblyReference>
<AssemblyReference>System.Collections</AssemblyReference>
<AssemblyReference>System.Collections.NonGeneric</AssemblyReference>
<AssemblyReference>System.Linq.Expressions</AssemblyReference>
<AssemblyReference>System.Private.DataContractSerialization</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Formatters</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Primitives</AssemblyReference>
<AssemblyReference>System.IO.FileSystem.Watcher</AssemblyReference>
<AssemblyReference>System.IO.Packaging</AssemblyReference>
<AssemblyReference>System.IO.FileSystem.AccessControl</AssemblyReference>
<AssemblyReference>System.IO.FileSystem.DriveInfo</AssemblyReference>
<AssemblyReference>System.Linq.Async</AssemblyReference>
<AssemblyReference>System.ComponentModel.EventBasedAsync</AssemblyReference>
<AssemblyReference>System.ComponentModel.Primitives</AssemblyReference>
<AssemblyReference>System.Private.Xml</AssemblyReference>
<AssemblyReference>UiPath.PDF.Activities</AssemblyReference>
<AssemblyReference>UiPath.Platform</AssemblyReference>
<AssemblyReference>System.Runtime.Numerics</AssemblyReference>
<AssemblyReference>System.Text.RegularExpressions</AssemblyReference>
<AssemblyReference>System.Collections.Immutable</AssemblyReference>
<AssemblyReference>System.Linq.Parallel</AssemblyReference>
<AssemblyReference>System.Linq.Queryable</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities.Design</AssemblyReference>
<AssemblyReference>NPOI.Core</AssemblyReference>
<AssemblyReference>System.Data.SqlClient</AssemblyReference>
<AssemblyReference>System.Runtime.InteropServices</AssemblyReference>
<AssemblyReference>UiPath.MicrosoftOffice365.Activities</AssemblyReference>
<AssemblyReference>UiPath.MicrosoftOffice365</AssemblyReference>
<AssemblyReference>System.Memory.Data</AssemblyReference>
<AssemblyReference>Newtonsoft.Json</AssemblyReference>
<AssemblyReference>UiPath.GSuite.Activities</AssemblyReference>
<AssemblyReference>DocumentFormat.OpenXml</AssemblyReference>
<AssemblyReference>DocumentFormat.OpenXml.Framework</AssemblyReference>
<AssemblyReference>UiPath.CodedWorkflows</AssemblyReference>
<AssemblyReference>System.Linq.Async.Queryable</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic.Forms</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic.Core</AssemblyReference>
<AssemblyReference>Microsoft.VisualStudio.Validation</AssemblyReference>
<AssemblyReference>System.Security.Cryptography</AssemblyReference>
<AssemblyReference>System.Security.Principal.Windows</AssemblyReference>
<AssemblyReference>System.Diagnostics.Process</AssemblyReference>
<AssemblyReference>System.IO.MemoryMappedFiles</AssemblyReference>
<AssemblyReference>Microsoft.Win32.Registry</AssemblyReference>
<AssemblyReference>System.IO.Pipes</AssemblyReference>
<AssemblyReference>System.Net.Primitives</AssemblyReference>
<AssemblyReference>System.Net.HttpListener</AssemblyReference>
<AssemblyReference>System.Net.WebProxy</AssemblyReference>
<AssemblyReference>System.Net.NameResolution</AssemblyReference>
<AssemblyReference>System.Net.WebHeaderCollection</AssemblyReference>
<AssemblyReference>System.Net.WebClient</AssemblyReference>
<AssemblyReference>System.Net.Requests</AssemblyReference>
<AssemblyReference>System.Net.ServicePoint</AssemblyReference>
<AssemblyReference>System.CodeDom</AssemblyReference>
<AssemblyReference>System.Threading.AccessControl</AssemblyReference>
<AssemblyReference>System.Threading</AssemblyReference>
<AssemblyReference>UiPath.PDF</AssemblyReference>
<AssemblyReference>System.Threading.Tasks.Parallel</AssemblyReference>
<AssemblyReference>System.Text.Encoding.CodePages</AssemblyReference>
<AssemblyReference>System.Text.Encodings.Web</AssemblyReference>
<AssemblyReference>System.Security.Claims</AssemblyReference>
<AssemblyReference>System.Security.Cryptography.Pkcs</AssemblyReference>
<AssemblyReference>System.Security.Cryptography.ProtectedData</AssemblyReference>
<AssemblyReference>System.Windows.Forms.Design</AssemblyReference>
<AssemblyReference>System.Runtime.CompilerServices.VisualC</AssemblyReference>
<AssemblyReference>System.Windows.Forms</AssemblyReference>
<AssemblyReference>System.Resources.Writer</AssemblyReference>
<AssemblyReference>System.Reflection.MetadataLoadContext</AssemblyReference>
<AssemblyReference>Microsoft.PowerShell.Commands.Diagnostics</AssemblyReference>
<AssemblyReference>System.Diagnostics.FileVersionInfo</AssemblyReference>
<AssemblyReference>System.Diagnostics.PerformanceCounter</AssemblyReference>
<AssemblyReference>System.Diagnostics.DiagnosticSource</AssemblyReference>
<AssemblyReference>System.Diagnostics.TraceSource</AssemblyReference>
<AssemblyReference>System.Diagnostics.EventLog</AssemblyReference>
<AssemblyReference>System.Diagnostics.TextWriterTraceListener</AssemblyReference>
<AssemblyReference>System.Diagnostics.StackTrace</AssemblyReference>
<AssemblyReference>System.Collections.Concurrent</AssemblyReference>
<AssemblyReference>System.Net.Security</AssemblyReference>
<AssemblyReference>System.Private.Xml.Linq</AssemblyReference>
<AssemblyReference>System.Xml.XPath.XDocument</AssemblyReference>
<AssemblyReference>Microsoft.CodeAnalysis.VisualBasic</AssemblyReference>
<AssemblyReference>Microsoft.CodeAnalysis.Features</AssemblyReference>
<AssemblyReference>System.Net.NetworkInformation</AssemblyReference>
<AssemblyReference>System.Net.Ping</AssemblyReference>
<AssemblyReference>System.Net.Sockets</AssemblyReference>
</sco:Collection>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="Main Sequence" sap:VirtualizedContainerService.HintSize="897.2,3144.8" sap2010:WorkflowViewState.IdRef="Sequence_2">
<Sequence.Variables>
<Variable x:TypeArguments="s:String[]" Name="pdfFiles" />
<Variable x:TypeArguments="x:String" Name="invoiceFolder" />
<Variable x:TypeArguments="x:Int32" Name="index">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:String x:Key="SourceIdRef">ForEach`1_4</x:String>
<x:String x:Key="SourcePropertyName">CurrentIndex</x:String>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</Variable>
<Variable x:TypeArguments="scg:IEnumerable(str:Match)" Name="result">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:String x:Key="SourceIdRef">Matches_1</x:String>
<x:String x:Key="SourcePropertyName">Result</x:String>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</Variable>
<Variable x:TypeArguments="sd:DataTable" Name="invoiceDataTable" />
</Sequence.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>
<Assign sap:VirtualizedContainerService.HintSize="486.4,174.4" sap2010:WorkflowViewState.IdRef="Assign_1">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[invoiceFolder]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">[Environment.CurrentDirectory + "\Data\Input"]</InArgument>
</Assign.Value>
</Assign>
<Assign sap:VirtualizedContainerService.HintSize="486.4,174.4" sap2010:WorkflowViewState.IdRef="Assign_2">
<Assign.To>
<OutArgument x:TypeArguments="s:String[]">[pdfFiles]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="s:String[]">[Directory.GetFiles(invoiceFolder,"*.pdf")]</InArgument>
</Assign.Value>
</Assign>
<ui:BuildDataTable DataTable="[invoiceDataTable]" DisplayName="Build Data Table" sap:VirtualizedContainerService.HintSize="486.4,92" sap2010:WorkflowViewState.IdRef="BuildDataTable_1" TableInfo="<NewDataSet>
 <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="TableName" msdata:UseCurrentLocale="true">
 <xs:complexType>
 <xs:choice minOccurs="0" maxOccurs="unbounded">
 <xs:element name="TableName">
 <xs:complexType>
 <xs:sequence>
 <xs:element name="Invoice_x0020_Number" msdata:Caption="" minOccurs="0">
 <xs:simpleType>
 <xs:restriction base="xs:string">
 <xs:maxLength value="100" />
 </xs:restriction>
 </xs:simpleType>
 </xs:element>
 <xs:element name="Vendor" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="Date" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="Amount" msdata:Caption="" type="xs:string" minOccurs="0" />
 </xs:sequence>
 </xs:complexType>
 </xs:element>
 </xs:choice>
 </xs:complexType>
 </xs:element>
 </xs:schema>
</NewDataSet>" />
<ui:ForEach x:TypeArguments="x:String" CurrentIndex="[index]" DisplayName="For Each currentFile" sap:VirtualizedContainerService.HintSize="486.4,1372.8" sap2010:WorkflowViewState.IdRef="ForEach`1_4" Values="[pdfFiles]">
<ui:ForEach.Body>
<ActivityAction x:TypeArguments="x:String">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="x:String" Name="currentText" />
</ActivityAction.Argument>
<Sequence DisplayName="Body" sap:VirtualizedContainerService.HintSize="449.6,1242.4" sap2010:WorkflowViewState.IdRef="Sequence_4">
<Sequence.Variables>
<Variable x:TypeArguments="sd:DataTable" Name="variable1" />
<Variable x:TypeArguments="x:String" Name="InvDate" />
<Variable x:TypeArguments="x:String" Name="Vendor" />
<Variable x:TypeArguments="x:String" Name="invoiceText" />
<Variable x:TypeArguments="x:String" Name="invoiceNumber" />
<Variable x:TypeArguments="x:String" Name="Amount" />
</Sequence.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>
<ui:ReadPDFText PreserveFormatting="{x:Null}" ResourceFile="{x:Null}" DisplayName="Read PDF Text" FileName="[pdfFiles(index)]" sap:VirtualizedContainerService.HintSize="416,123.2" sap2010:WorkflowViewState.IdRef="ReadPDFText_1" Range="All" Text="[invoiceText]">
<ui:ReadPDFText.Item>
<upap:ItemArgument x:TypeArguments="upr:IResource" ResourceFile="{x:Null}" FileName="[pdfFiles(index)]" />
</ui:ReadPDFText.Item>
</ui:ReadPDFText>
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="416,122.4" sap2010:WorkflowViewState.IdRef="WriteLine_3" Text="[invoiceText]" />
<ui:Matches BuilderPattern="(?:INV-)+" DisplayName="invoiceNumber" FirstMatch="[invoiceNumber]" sap:VirtualizedContainerService.HintSize="416,92" sap2010:WorkflowViewState.IdRef="Matches_1" Input="[invoiceText]" IsBuilderTabModified="True" Model="[{"Index":0,"OperationID":"LIT","OperationName":"Literal","OperationValue":"INV-","QuantifierFirstValue":"+","QuantifierID":"OOM","QuantifierName":"At least one (1 or more)","QuantifierSecondValue":null}]" Pattern="INV-\d+" RegexOption="IgnoreCase, Compiled" Result="[result]" />
<ui:Matches BuilderPattern="(?:Amount:)+" DisplayName="Amount" FirstMatch="[Amount]" sap:VirtualizedContainerService.HintSize="416,92" sap2010:WorkflowViewState.IdRef="Matches_2" Input="[invoiceText]" IsBuilderTabModified="True" Model="[{"Index":0,"OperationID":"LIT","OperationName":"Literal","OperationValue":"Amount:","QuantifierFirstValue":"+","QuantifierID":"OOM","QuantifierName":"At least one (1 or more)","QuantifierSecondValue":null}]" Pattern="\s*(\d+)" RegexOption="IgnoreCase, Compiled" />
<ui:Matches DisplayName="Vendor" FirstMatch="[Vendor]" sap:VirtualizedContainerService.HintSize="416,92" sap2010:WorkflowViewState.IdRef="Matches_3" Input="[invoiceText]" IsBuilderTabModified="False" Pattern=":\s*(.*)" RegexOption="IgnoreCase, Compiled" />
<ui:Matches DisplayName="InvDate" FirstMatch="[InvDate]" sap:VirtualizedContainerService.HintSize="416,92" sap2010:WorkflowViewState.IdRef="Matches_4" Input="[invoiceText]" IsBuilderTabModified="False" Pattern="\s*([0-9]{4}-[0-9]{2}-[0-9]{2})" RegexOption="IgnoreCase, Compiled" />
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="416,122.4" sap2010:WorkflowViewState.IdRef="WriteLine_2" Text="["Invoice: " + invoiceNumber + 
" | Amount: " + Amount +
" | Vendor: " + Vendor +
" | Date: " + InvDate]" />
<ui:OutputDataTable Text="{x:Null}" DataTable="[invoiceDataTable]" DisplayName="Output Data Table as Text" sap:VirtualizedContainerService.HintSize="416,112.8" sap2010:WorkflowViewState.IdRef="OutputDataTable_1" />
<ui:AddDataRow DataRow="{x:Null}" ArrayRow="[{invoiceNumber,Vendor,InvDate,Amount}]" DataTable="[invoiceDataTable]" DisplayName="Add Data Row" sap:VirtualizedContainerService.HintSize="416,220" sap2010:WorkflowViewState.IdRef="AddDataRow_3" />
<WriteLine DisplayName="Write Line" sap:VirtualizedContainerService.HintSize="416,113.6" sap2010:WorkflowViewState.IdRef="WriteLine_4" Text="[invoiceDataTable.Rows.Count.ToString()]" />
</Sequence>
</ActivityAction>
</ui:ForEach.Body>
</ui:ForEach>
<ueab:ExcelProcessScopeX DisplayAlerts="{x:Null}" ExistingProcessAction="{x:Null}" FileConflictResolution="{x:Null}" LaunchMethod="{x:Null}" LaunchTimeout="{x:Null}" MacroSettings="{x:Null}" ProcessMode="{x:Null}" ShowExcelWindow="{x:Null}" DisplayName="Excel Process Scope" sap:VirtualizedContainerService.HintSize="486.4,1308" sap2010:WorkflowViewState.IdRef="ExcelProcessScopeX_1">
<ueab:ExcelProcessScopeX.Body>
<ActivityAction x:TypeArguments="ui:IExcelProcess">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="ui:IExcelProcess" Name="ExcelProcessScopeTag" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="484.8,1238.4" sap2010:WorkflowViewState.IdRef="Sequence_7">
<Sequence.Variables>
<Variable x:TypeArguments="upr:IResource" Name="attachmentsList" />
<Variable x:TypeArguments="x:String" Name="excelFilePath" />
</Sequence.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 DisplayName="Use Excel File" sap:VirtualizedContainerService.HintSize="451.2,500" sap2010:WorkflowViewState.IdRef="ExcelApplicationCard_2" ResizeWindow="None" WorkbookPath="Reports\InvoiceReport.xlsx">
<ueab:ExcelApplicationCard.Body>
<ActivityAction x:TypeArguments="ue:IWorkbookQuickHandle">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="ue:IWorkbookQuickHandle" Name="Excel" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="449.6,272" sap2010:WorkflowViewState.IdRef="Sequence_8">
<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:WriteRangeX Append="True" Destination="[Excel.Sheet("Reports")]" DisplayName="Write DataTable to Excel" ExcludeHeaders="True" sap:VirtualizedContainerService.HintSize="416,212" sap2010:WorkflowViewState.IdRef="WriteRangeX_1" IgnoreEmptySource="False" Source="[invoiceDataTable]" />
</Sequence>
</ActivityAction>
</ueab:ExcelApplicationCard.Body>
</ueab:ExcelApplicationCard>
<Assign sap:VirtualizedContainerService.HintSize="451.2,174.4" sap2010:WorkflowViewState.IdRef="Assign_3">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[excelFilePath]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">["C:\Users\devel\OneDrive\Documents\UiPath\InvoiceProcessingAutomation\Reports\InvoiceReport.xlsx"]</InArgument>
</Assign.Value>
</Assign>
<uga:SendEmailConnections ArgumentAttachmentPaths="{x:Null}" ArgumentAttachments="{x:Null}" Attachments="{x:Null}" ConnectionAccountName="{x:Null}" AttachmentInputMode="UseExisting" AttachmentPaths="{x:Null}" AuthScopesInvalid="False" Bcc="{x:Null}" Body="[string.Format("<P><SPAN>&quot;</SPAN><SPAN>Hi,

Please find attached the consolidated invoice report generated from today&#39;s PDF invoices.

Regards,
Automation Bot</SPAN><SPAN>&quot;</SPAN></P>")]" Cc="{x:Null}" ConnectionId="b76a741d-2180-49f1-ae10-5d4e68f46c07" ContinueOnError="{x:Null}" DisplayName="Send Email" sap:VirtualizedContainerService.HintSize="334.4,480.79999999999995" sap2010:WorkflowViewState.IdRef="SendEmailConnections_3" Importance="Normal" InputType="HTML" ReplyTo="{x:Null}" SaveAsDraft="True" SingleAttachment="{x:Null}" Subject="Consolidated Invoice Report" TextBody="{x:Null}" To="[New String(){"developer.neethu@gmail.com"}]" UseConnectionService="True">
<uga:SendEmailConnections.AttachmentsBackup>
<usau:BackupSlot x:TypeArguments="ugage:AttachmentInputMode" StoredValue="UseExisting">
<usau:BackupSlot.BackupValues>
<scg:Dictionary x:TypeArguments="ugage:AttachmentInputMode, scg:List(x:Object)" />
</usau:BackupSlot.BackupValues>
</usau:BackupSlot>
</uga:SendEmailConnections.AttachmentsBackup>
<uga:SendEmailConnections.InputTypeBackup>
<usau:BackupSlot x:TypeArguments="ugage:BodyInputType" StoredValue="HTML">
<usau:BackupSlot.BackupValues>
<scg:Dictionary x:TypeArguments="ugage:BodyInputType, scg:List(x:Object)" />
</usau:BackupSlot.BackupValues>
</usau:BackupSlot>
</uga:SendEmailConnections.InputTypeBackup>
</uga:SendEmailConnections>
</Sequence>
</ActivityAction>
</ueab:ExcelProcessScopeX.Body>
</ueab:ExcelProcessScopeX>
</Sequence>
</Activity>