Excel Automation: Finding the first free row or column in an Excel file

Automation Studio
,
1

Hi,

I need to identify the first free row or column within an excel. Is there any way to achieve it within Automation studio?

2

Hi,

Try iterating in excel loop in a try catch block. for the value in context perform any string operation say ToLower. When it will hit an empty row it will throw exception which will move the code to catch block in which you can write the row number which is having empty string

Regards,
Amit