The pandas library offers the possibility to read, edit and change data from Excel workbooks using Python.

Microsoft is bringing popular programming language Python to Excel. A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.