Hi.
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?
ipazin
April 6, 2022, 6:57am
2
Hello @denzilsdn ,
try option “Select sheet with name”
Hello,
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:
[image]
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…
Br,
3 Likes
@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.
[image]
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 .
[image]
The workaround is to explicitly set the use of names with a flow variable like in the example.
Maybe @laaaarsi can weight in if there is any progress on the internal ticket AP-18133 .
system
April 13, 2022, 7:28am
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
