Hi everyone, i have observed my header on my excel inputs (example: name, address,telephone) are on the row. Is there anyway to put in as column?
Example row ABC to become column ABC.
Hi everyone, i have observed my header on my excel inputs (example: name, address,telephone) are on the row. Is there anyway to put in as column?
Example row ABC to become column ABC.
Please put the sample input sample and output
Your query is quite confusing could you be more specific. If possible share us the Input and expected output file.
→ You can use the Copy\Paste range activity
→ Give the range in the Source where you want to copy the data and give the range in the destination where you want to paste the data.
→ In the what to copy field Select the All option in the first dropdown and select the Include header.
→ Check the Transpose value to make the rows as headers and headers as rows, It will transpose the data.
Check the below image for better understanding,
Hope it helps!!
Hi Mkankatala
The screenshot is from UiPath or require to do from excel
The above screenshot is from the UiPath studio only. That was the activity screenshot.
→ Use the Excel process scope activity inside of it insert the Use excel file activity and give the path of the excel file.
→ Inside use excel file activity insert the copy/paste range activity and do what I said at the above post.
If you need any additional inputs, happy to help here… @James_Yakupt
Hope you understand!!
Hi Mahesh
Base on my UiPath, i do not have tje excel processing. Appreciate it if you could guide me.
Install UiPath.Excel.Activities
package from package manager to get this activity and work on excel files.
Thanks,
Ashok
Regards