Some concerns on Python support on Excel

[tonyqus]

I'm reading this post.
https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439

I see some dangerous usage of Excel. dataframe can be huge. If Excel users starts loading data by dataframe into Excel, it can be a nightmare for any Excel file read/write library.

[Bykiev]

I don't think it makes any sense to read such Excel files programmatically. Also all Python executions will be in the Cloud, it's not the best decision for companies. So, it'll be not widely used.

[tonyqus]

Yeah, I did see this feature needs Azure support. But depends on how they handle the data of the dataframe. It's possible that they put a cache on local Excel, which will be the tough part.

[tonyqus]

I opened an inquiry issue for Microsoft: microsoft/python-in-excel#16