Capture data in excel

In excel we have different sheet name and also contain some data in every sheet need to capture in which column and row data is available

Hi @Zuber_Shaikh1,

  1. Use read range activity to read the sheet and store it in the data table.
  2. Using if condition you can check dt_YourTable.Rows.Count>0 → this condition will give you if the data table has rows or not.

→ Use get sheets activity to iterate through each sheet in the excel.