Hi, I think this is a bug, as my workbook write range does not work as intended for .xls file. It will clear all the cells in that row before writing it.
Here is a screenshot of my activities & i/o file:
Figure 1: Build DataTable Activity
Figure 2: Workbook Write Range Activity
Figure 3: Input .xls file
Figure 4: Output .xls file
I want to write them while retaining the others. Hope UiPath could fix this. Thanks
Studio: Community Edition, v2022.4.3
Dependency: UiPath.Excel.Activities v2.12.3
Do you mean you want to append the row to the Excel file at the end ?
No, I want to write from E2 to G2, but it clears the other cells at Row 2. But this only happens for .xls file while I’ve tested for .xlsx file & turned out the result is not the same; where it won’t clear the other cells.
Well first read the excel file and the using the assign activity at the particular position and then you write the range activity to write the data into excel.
In this case we can use Write cell activity with the help of counter variable…
This will write the data in to particular position…
Hi @Achal_Sharma & @THIRU_NANI,
Thanks for the suggestion. Yes, there’s other way to do that which requires more steps. I actually try to report a bug (this is my first time too). I just want UiPath to know if this is a bug, I would like for them to fix it.
Did you try mentioning range in Write Range Activity and use ?
Yes, I have tried & I got the same result. However, using Excel Write Range works fine.
You need to use the exact range which you were saying in the above thread.
That should help.
I’m sorry, I mean, it doesn’t work for Workbook Write Range, even if I specify the range. For Excel Write Range, it works fine either it is specified or not.
How come, it’s weird both works in the same way.
Did you tried with .xls and .xlsx files with Workbook Write Range activity?
Also did you tried the same in Excel write range with both the files? With the same files.
Yes, I’ve tried for both format. Different output, where it works fine for .xlsx.
As I can see in the screenshot you are using only the starting cell as address in the Write Range ?
Hi, I’ve tried using starting cell & specifying range. Turned out to have similar output.
Thanks for reporting @azeem_rosli, we will look into it.
Quick requrst, if possible. Please attach a zip file of the dummy project that reproduces the issue for you.
Thank you again for reporting @azeem_rosli, the bug has been added to our tracking system and will be adressed in a future release.