Excel Activity Find First/Last Data Row error

[hendrik.berger]

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

Kind regards
Hendrik

[Gokul001 (Gokul Balaji)]

HI @hendrik.berger

I think you need to pass variables in output too

Have a look on the documentation too!

Find First/Last Data Row

Regards
Gokul

[Gokul001 (Gokul Balaji)]

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

Regards
Gokul

[hendrik.berger]

Hi @Gokul001,

thanks for your help, now it works.

Kind regards
Hendrik

[loginerror (Maciej Kuźmicz)]

Any chance you could share a sample dummy project zip that reproduces this issue?

[MikeC (Mike)]

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.