Identify the Excel Sheet is Empty


#1

What is the use case

Check whether the excel sheet is empty or not.

How do you see a solution for the use case?

use read cell activity to get the value “A1”
If its is empty you can assume sheet is empty
if not empty you have the data.

Read the excel sheet and store it in a datatable dt.
Then use OutputDataTable Activity and store dt in stra
Then check by using stra fields is “Column1 Column1”
you can identify the sheet is empty

Instead of this idea any other idea to know the excel sheet is empty or not

Scope: ______________

  • Custom Activity
  • Reusable Component

Regards,
Arivu