I want to extract the data from each sheet in a different data table. However, it is unknown that how many workbook sheets are available in a workbook… it can be 2,10… or more…
I can get the name of worksheets using WorkbookName.GetSheets or the count. But I am not sure how should I dynamically add/create the number of datatables in UiPath.
Is there any leads?