I seem to have an issue with the Excel Reader.
I have multiple sheets in an Excel Workbook, which I am passing through in a loop as a flow variable.
When I happen to set the sheet name flow variable, the Excel Reader only reads the first sheet name. I also tried to use the index value as well, in which I generated index values before passing them through a loop, and still, the Excel Reader only reads the first sheet, regardless of what flow variables you set for it.
Any workaround for this?
try option “Select sheet with name”
for a productive workflow I tried to replace deprecated nodes and ran into errors. I made some tests and found out that the reason seems to be the Excel Reader in combination with flow variables.
I created a sample workflow based on one of the examples to discuss and clarify here:
05_Read_all_sheets_from_an_XLS_file_in_a_loop.knwf (30.3 KB)
I was unable to integrate my source excel file into workflow, therefore I upload it separately:
Mappe2.xlsx (10.2 KB)
In the results y…
@denzilsdn it could be this problem mentioned here:
@Geo what you could do is force the use of sheet_selection = “NAME” thru a Flow Variable in case of doubt. Maybe not the most elegant way but shout provide an additional layer of security.
And indeed under certain circumstances it seems to revert to the default value. Not able to reproduce it yet in a constant way. But might be worth looking into, @laaaarsi.
The workaround is to explicitly set the use of names with a flow variable like in the example.
@laaaarsi can weight in if there is any progress on the internal ticket AP-18133.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.