I have a problem with the new excel activity called “Find First /Last Data Row”, this activities is used in an Excel Scope in Use Excel File, both variables are System.int32. unfortunately I get the following error message but I couldn’t find a solution, I know that there are many user ways to find the first and last row but I would like to use this activity.
Has anybody an idea what the problem could be solved??
I think you need to pass variables in output too
Have a look on the documentation too!
I think so there is a bug in the Find First/Last Data Row Activity.
Just you need to enter/Create the variable in the Properties panel instead of Designer panel.
For the First and Last Row Index
While entering the variable in the Designer panel it is not updating in the properties.
Kindly look into this bug @loginerror and i hope so this will fixed in the latest version
thanks for your help, now it works.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Any chance you could share a sample dummy project zip that reproduces this issue?
I can confirm this solution worked for me also, creating the vars in property panel rather than the designer.
Note I didnt have to pass vars in output also as suggested above.