New course! Every coder should learn Generative AI!
Try a free lesson1 Answer
0
It seems that Excel only supports VBA so you cannot use python there.
However, you can export .xls to .csv and apply the Pandas library, then open your result in Excel and turn it into .xls again.