Hi,

When reading from excel can we alse read the formula which a cell has been allocated and then apply that formula in other steps?

Hi,

When reading from excel can we alse read the formula which a cell has been allocated and then apply that formula in other steps?

Yes, we can apply the formulae on excel data using Process studio’s various Steps, but we’ve to read the formula from excel manually.

So you mean to say

a sheet has data with formula I will read the data using steps and apply the formula on data and then write the data in excel back?

but will the formula be preserved in excel after writing the data?

Yes, right. Need one change in this, If you require to cross check the calculations performed using PS Steps then, don’t write output in original excel which you get as input, instead use another one.