If anybody from DataNitro is lurking, I have a question: what's the advantage of using DataNitro over Win32com + Python?
here's one example of an optimization: if you're using a basic Win32com script, it'll freeze Excel while it's executing. DataNitro doesn't do this, so you can turn a spreadsheet into an interactive dashboard just by using a while loop. it'd take a lot of time to get that working properly using Win32com.