I know how to use “Concatenate” node with multiple Excel readers, so that all spreadsheets are combined together, even if their structure is different. In case of having many such spreadsheet, manual definition of each Excel reader is painful and I would like to use “List Files/Folders” node instead. I know how to use “List Files/Folders” with “Table Row to Variable” loop and “Excel reader”, but this works only if all spreadsheets have exactly the same structure. So, I cannot use Excel reader in the loop, but I should use “Concatenate” node instead. However, I don’t know how to embed Concatenate node in a loop - is it even possible?
Hi @matasoft.
Please have a look at excel reader node documentation, because it can read a single or multiple files at the same time.
In Advanced tab, unmark “Fail if schema differ”
Br
3 Likes
But it cannot read multiple files having different structure, i.e. different schema (different number of columns). I have already tried that.
Please unmark “Fail if schema differ”
Br
2 Likes
Actually, I can’t, but I can switch-on “Support changing schemas”
Anyway, it seems it works now, but I had to modify in “Loop End” node:
1 Like
Ok. I see.
My idea works if eache file has only one sheet.
You have multiple sheets in each file and need to tic "Allow changing table specifications.
Good to see you have found a solution.
Br
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.