Which is best - Python or vba in excel

Question

can we manipulate data in excel using python

Answer 1

Try this:
www.xlwings.org

Answer 2

It would be VERY NICE if python was used as the macro language in excel.
It is better than VBA, no doubt!

That said, there are ways you can access the excel data from Python:

https://www.datacamp.com/community/tutorials/python-excel-tutorial

Answer 3

Use the openpyxl Module.

Answer 4

try also pandas