Read Excel/CSV from Git library

pietvoerman Registered Posts: 1 ✭✭✭

Situation: I am building on an existing Python code base where an Excel file with several sheets was used as a settings file. Excel is mainly used because of ease of use for experts who must set the settings. This Excel is stored in Git (I know that we shouldn't store data in Git). The idea is that the Excel is updated and that I can read in the settings from each of the sheets using a Python recipe to use in modelling. I can upload each of the sheets separately by importing the Excel manually but then there is no automated connection with the Excel.

Question: Can I read in Excel (or CSV/text) from 'Library' which I have imported from Git?

If not, does anybody have a workaround in mind where I can update the Excel (while being under version control) and access the contents in Python recipes?

Thanks in advance!

Operating system used: Windows


Setup Info
      Help me…