How to convert multiple excel sheets to individual excel files

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

Hi @adarsh_kotagiri

Please try these steps,

  1. 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).

  2. After excel application scope use for each activity and give output as colSheets

  3. Inside for each use read range and store the data in datatable.

  4. Use write range and give file path (dynamic) and your datatable.

Thanks

1 Like

Thank you sir it’s working…:+1::+1:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.