@bcorrea Thanks for your quick reply!
It’s part of my university projects so the structure of excel is not defined.
For the time being, I mainly want to learn the pattern of “matching” to excel files.
I was going to make a different structure of excels - for instance:
In type A data like name, address, mail etc would be in rows, and this would be a header of final excel,
In type B data like product name, product id, price, quantity etc would be in columns
The final/combined excel would look like a sort of invoice.
However, I know that this way I will be more difficult so, for now, we can assume that in the type A excel there will be headers/columns names of datatable and in type B there will be records of datatable.
Till now I did the following steps:
- created variable “folderlist” and assigned to it Directory.GetFiles(folderpath,"*.xlsx")
- added activity: for each item in folderlist with read and append inside. (like below)
but this way it merges all spreadsheets from folder into one (and what I need is one excel with result for pair of each A and B file)