Here I am new to the UIPATH , i have one excel file consisting of 10 excel sheets , here i am trying to convert this 10 excel sheets to 10 individual excel files
Thanks in advance
Please try these steps,
Use excel application scope and give your excel file path ,inside the excel application scope give get workbook sheets activity and assign an output variable (collSheets).
After excel application scope use for each activity and give output as colSheets
Inside for each use read range and store the data in datatable.
Use write range and give file path (dynamic) and your datatable.
Thank you sir it’s working…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.