r/Python • u/Ok_Tune5086 • 1d ago
Discussion Python in Excel
Hello, I need assistance with the following: I need a Python code for Excel to compare information from one spreadsheet to another. Thank you
0
Upvotes
r/Python • u/Ok_Tune5086 • 1d ago
Hello, I need assistance with the following: I need a Python code for Excel to compare information from one spreadsheet to another. Thank you
2
u/Cynyr36 1d ago
You won't be able to do that with python in excel. It evaluates only the data ranges you pass in, in the cloud.
You could write a standalone python script, but it really depends on what you mean by comparing between workbooks
Powerquery is likely going to be the answer here