Hi,

I am reading an excel fine that contains formulas. Then I use filter wizard to filter some rows according to some column elements. Then I write the dataTable in an other excel file. But formulas are not kept (only results are displayed). Is there a way to keep formulas by using the filter wizard ?

Kind regards

Fine

yah usually when we read the excel with read range we will be getting only the value

while we can get the formulaes used in a excel and pass that to another excel with write cell activity

and to get the formulae we can use READ CELL FORMULA activity

Cheers @HibaBee

Good evening HIbaBee,

This may may not be the most elegant solution, but I believe it will fulfill your needs.

Are you able to add a column to your Excel table that contains a formula that will automatically calculate the range of the cell that youâ€™d like to get the formula from?

For example, if the formula you want to read is in cell A2 and new columnâ€™s formula is in B2, the formula in B2 would be:

=â€śAâ€ť&ROW()

This way, once your datatable is filtered, youâ€™ll still be able to use the â€śRead Cell Formulaâ€ť activity suggested by @Palaniyappan to loop through your results and get the formula from each cell in the first column.