Another option would be to use Hops to connect to an external Cpython interpreter running pandas, if you are already comfortable with that? You say you want to work dynamically - I think you need to close the excel file before reading with pandas so that might not be suitable for you.