I am trying to read an excel file with the new Excel reader node. I have read the very same excel file with the old (deprecated) Excel reader node with success. However, the new version does not work with the same settings. Below is the settings from deprecated version (pic 1) and new version (pic 2). I would appretiate any ideas why it’s not working the same way?
Update.
I somehow made it work. Although the excel I am reading has no formulas in the cells, when I checked “Reevaluate formulas” under more options window, it worked just fine. Still no idea why this happens though.