Sometime it didn't produce the result I expect at the end

Help Studio
, ,
1

Hi,

Since I start using Studio, there’re some issues/situations I want to know the reason why it happened.
Most of the process I made are used for dealing with Excel.

  1. During the execution I created several DataTable and Sheet for checking and reuse which will be deleted at the end of process. Sometimes, it’ll be deleted, or delete the wrong sheet and leave the wrong result.

  2. Activity “Write Range” supposed to create the sheet automatically if the sheet is not exist, but I sometimes came out the errors that shows “The Range does not exist” if I use a new sheet name.

  3. Sometimes, It write some data repeatedly in to the excel lead our customers concern whether UiPath is reliable.

Please give me any solution or advise let me can solve these problems prevent it happen again and again.

If needed, I can send the Technical Ticket as well.

Thanks in advance.

2

@opas1216 - Can you please check you excel activity package and try to uninstall and install again.

Thanks

3

Hi @opas1216

I`m not an expert but i will try to help you.

  1. So, i didnt understand number 1 very well, could u try to give us more details about it? As far as i understand you only use these sheets as a “support” and all of them will be deleted in the end of the process. If i understand correctly why dont you try to use only DataTable as support, this could even save you some seconds in your process.

  2. I tried to replicate the error but i couldnt. Maybe it is some error with the version os the package. You could try to update.

  3. Check if you dont have this duplicated data in the DT that you are trying to write in cell, to be sure you could use Remove Duplicate Rows before writing the range. Also, make sure that you have no remaining data in the sheet, sometimes you are trying to overwrite the data but the new data table has less rows than the data already in excel.

Hope this helps!

Thanks!

2 Likes
4

Hi @sandipauti

I think it’s not because of the package even the version. It’s still can come up the correct result just sometimes it come out the wrong one. Otherwise I already tried to uninstall/reinstall for several times.

For example, I have a DataTable which include a lot of value inside(Double and Integer).
At the end of the process, the process will remove every decimal to be Integer .

However, sometimes it come out the result which didn’t convert from Double to Integer.(The process has made it convert from Double to Integer).

So I consider whether its because of memory or the issue/bug from UiPath itself.
My user usually get this thing happen that they have huge concern whether it’s reliable to invest for the further RPA Implementation.

I need to figure out the reason to persuade them and explain to my boss why this happen and how to prevent it in the further project.

Please help me solve this issue, its really confused me and my team.