I have a sequence where I am using ReadPDF and then the Matches activity with Regex to great success.
The output is coming out as ItemNamesRaw an IEnumberable variable for the first Matches activity and as QtyRaw which is an IEnumrable variable for the second Matches activity on the same PDF.
Currently I just have: For Each Item in the Variable converted to string and writing a line to be sure that they are all being read correctly.
I would like to have them append columns in an excel spreadsheet for inventory purposes, (all items to column A and all Qtys to Column B for example) but I’m having trouble figuring out how to convert the IEnumerable into a DataTable as that’s what is required to append a range.
1. Should I be aiming towards using Append Range to do this?
2. Is there a more meaningful and maybe flexible way to extract and collect the information within the IEnumerable so that I can access this information in the best way possible?
I don’t recall learning something specifically already that I can think of using, so maybe this is further ahead in the Academy than I am, (I’m about 25%) but even being pointed in the right direction would be great.
As always thanks for all the help on these forums, it’s always quick and concise to get an answer and I’m loving the community here.