Having trouble with the Switch Case activity

Hi,

We need to use ReadCell activity instead of ReadCellFormula activity because ReadCellFormula returns empty if there is no formula (even there is data).
Then you need to change type of isEmpty from String to GenericValue, (and might be modift from isEmpty to isEmpty.ToString

In addition initial value of counter should be 1.

Regards,

2 Likes