I am able get all sheets out of an excel file and combine them but does anybody know how to extract data from specific cells across multiple sheets in the same excel file. The data contained in the sheets is not the same apart from these two specific cells in the sheets, so I cant combine them and then extract the columns.
I have tried this and should have noted this in the post. Sorry about that. I have a sheet reader and then a Table Row to Variable Loop Start, with the Excel reader pointing to the path variable and selecting cell B 1 to 1. Finally I have a Loop end. When I run this it just returns the cell from the very first sheet over and over again.
Yes the addition was that sometimes there seems to be a bug (AP-18133) where just setting a dummy name and giving a name via Flow Variable is not enough because of a yet unfixed bug that would reset or ignore these setting under certain conditions. So the idea was to also force the “sheet_selection” thru a variable which would otherwise not be necessary.
Thank you for your very detailed and well illustrated solutions.