How do we get the data from excel per sheet ? . I wanted to get the data from sheet1 and sheet2 . I tried using excel workflow and then loop throught the sheet but does not seem to work any idea guys ?
I wanted to get data Subject column from sheet 1 and Subject column from sheet2SampleExcelSheet.xlsx (9.4 KB)
Can you explain further what you tried when you say “I tried using excel workflow and then loop throught the sheet but does not seem to work” because that is what I would recommend doing. The below list of activities is the order to do it in and assumes that each sheet has the same datatable structure. I’ll be putting it all into a datatable i’ll call FinalTable
Excel Application Scope
Get Workbook sheets // save as list(of string) called Sheets
For each sht in Sheets (TypeArgument = string)
Read Range // save as datatable called tempTable and the variable scope set to the for each loop
For each row in tempTable
Invoke Method (TargetObject = FinalTable; MethodName = ImportRow; Parameters: Direction = in, Type = datarow Value = row)
Now after the above code you have everything into one datatable called FinalTable
What I wrote above are all uipath activities along with applicable properties - try putting it into studio yourself. Let me know if you have any specific questions
