Is there a way to use ''write cell'' in a for loop instead of using it multiple times?

Help Studio
, ,
1

Hello!

I’m trying to add multiple values with formulas to an Excel sheet. Right now I have 4 write cells, all with different values, formulas and ranges. This works, but of course I’m looking for an alternative because having multiple write cells doesn’t seem very efficient to me.

I assume(?) you can use a for loop for this, but I’m honestly a bit lost on how to go about it… any help would be greatly appreciated!! Thank you!

2

I think it will be better if you build logic in UiPath to get the values instead of using the excel formulas. This way of processing is way faster then using the formulas and write cell.

Pleas share Sample/dummy input and output with us so that we can guide better.

3

Could you give me an example of what you mean by building in the logic instead of using the formulas? I’m not sure what kind of sample you need, but hopefully I can make it a bit more clear with the following info.

Right now I’m using a multiple assign activity to store the calculations that I want done. One of them is:

CDbl(CurrentRow(“price_new”)) - CDbl(CurrentRow(“price_old”))

This is stored in a variable, let’s name it

priceDifference

In one of the write cells I use this variable to calculate the difference in price with values that are already existing in the Excel file. I have 3 more write cells that pretty much do the same, just different calculations. Like I said, I don’t think this is a very nice solution but I’m lost as to what else to do.

Thank you again!

4

In your case, you can read the excel file into datatable say dt_Input
and update the datatable according to the business rules and write that table back into excel file.
If you give a sample excel file before processing and after processing that will help us to give you better solution/s

5

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