Hi
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.
Thanks
1 Like
Thank you sir it’s working…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.