Capture data in excel

Help Studio
1

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

2

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.