Excel Activity Find First/Last Data Row error

Hi together,

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??

image

image

Kind regards
Hendrik

HI @hendrik.berger

I think you need to pass variables in output too

Have a look on the documentation too!

Regards
Gokul

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

image

Regards
Gokul

Hi @Gokul001,

thanks for your help, now it works.

Kind regards
Hendrik

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? :slight_smile:

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.