[source-file] Importing excels does not resolve formulas, seems to ignore reader_options

[muutech]

Connector Name

source-file

Connector Version

0.3.12

What step the error happened?

During the sync

Relevant information

We are importing a normal .xlsx file and when imported we see in rows things like =E23+E24 instead of the number. Rollback to 0.2.31 fixes the issue. Seeing the code it seems when chunk processing was introduced reader_options are not passed to the final call to the reader, so by default the workbook reader uses data_only=False, https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html#openpyxl.reader.excel.load_workbook

Relevant log output

No response

Contribute

• Yes, I want to contribute