This is a StudioX question.
I have an Excel file.
How check if a file is blank or not using StudioX activities ?
Hi,
I assume you are talking about the excel with empty rows.
For this we can use below steps to find out whether the excel file having rows with data or empty.
-
Use excel File activity and enter your excel file path.
-
Use read range activity to read the data into data table by saving it using Save for later activity.
-
Now use if condition and select the save for later and select the data table you specified there in child property you could see the row count.
-
If RowCount>0 the excel have rows and if it is not excel is empty.
i hope it will helpful for your requirement. thanks.
Hey,
@kirankumar.mahanthi1 very good explained what you should do.
Please take an example:
condition inside ‘if’ activity should looks like:
Excel.Sheet(“Sheet1”).RowCount > 0
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.