How to get only calculated values from a formula driven column in an excel and save them into a list

I tried with:
Open Workbook ${CURDIR}${/}ExcelFile.xlsx data_only=True
in robotframework and also tried using custom python library to read just data and not formula.
Both of above two solution worked fine when working with a single sheet but when merged with the entire code where operations with multiple sheets and workbooks are involved(which are involved in other tasks), it is failing to collect the values when tried to save in a list. It is saving as “None” to the list for all the entries in the column.
Any suggestions would be great.

Hi, is it possible to isolate this problem into a quick code example you can paste here?