Quote:Can I open an excel spreadsheet via pythonyes, you can use a pagkage like openpyxl (popular, see: https://pypi.org/project/openpyxl/)
pandas is a better choice, but has a rather stiff learning curve (keep in mind, you will eventually want to switch).
will also work for your question 2