Hi
My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.
Discussion posts and replies are publicly visible
Please post node configurations and expression code. That iteration you mention, is that MNI or a foreach?
This excel_data is the data subset which is the data from excel sheet. And i am able to parse this data subset and i can extract the date and update type (working and non working days).
This foreach loop . In this i am trying to read the each row in the excel sheet. And i am parsing it to the expression rule and MNI is also enabled in the import appian calendar smart service. Also this rule works fine for just the first row It updates the first row in the calendar but it doesnt update the next rows.