There has been an issue being faced in the Excel Acitivites of StudioX
I have multiple files from a folder and I need data to be read from each folder and appended it to the another sheet(master sheet)
The issue that I am facing is that the data gets pasted randomly on a cell in the master sheet creating an issue to actually paste the data in the best possible way.
Can someone help me with a workaround?
Soluton is:
You don’t use copy/paste to work with Excel. You use the Excel activities. Have you done the free online training from the UiPath web site? It covers these things.
I am not using the copy paste and I am using the read and write/Append from the excel activities pack.
Yes, I have gone through the training in the UIPath Academy. I am in the learning phase as of now
I have done the same thing as mentioned, Please can you find the screen shots below and correct me if I am wrong somewhere. This is done on the StudioX platform
I have no clue why do I have to pass a template without which it fails to actually do its operations.
Then I write the data and click on the append checkbox
What I see that the data is read but pasted randomly on the master sheet. I have no clue why it takes random cell and paste it and then go ahead take another random cell and paste it again
Can you please guide where I am going wrong here. Also, I am in the learning stage of UIPath
Please try to uncheck the Template file and see. Also in order to check the data getting copied from each excel, you can use output Data table activity as below.
I see that there is no option for Output Data Table
It seems like it is not a part of the studioX.
I have seen StudioX having limited features, and I am trying to use it as a Business User and not a RPA developer.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
