Excel - Cannot read range for cell with formula

I have an excel workbook. Cell A1 is a fixed value with today’s date and the rest of the cells are populated with a formula (=A1+1, =A2+1). The dates are not recognised by read range workbook because they are populated by a formula.

I want to store it into a datatable so that i can filter by date.

Can someone please advise ?

Hi @jhivesh.subron ,

I think we have to use excel application scope inside excel read range to retain formulas in excel.

Using workbook read range to read the Excel values into datatable. Workbook read range will not consider formulas I guess.

Please try and let us known thanks.

Yes, excel application scope works !

1 Like

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