Python and Excel | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 8

Python and Excel

I heard a news several months ago. Is this an old news? Microsoft is considering to add Python to Excel as an official scripting language. Currently, it could be possible for Python to operate an Excel workbook by installing the module; OpenPyXL, xlwings, etc. On the other hand, Microsoft Excel has been inseparably linked to VBA for many years. I think "Excel with Python" is a good news particularly for non-programmers.(like me?) This may be unimportant for professionals. What do you think about it? rights and wrongs, realizability, influence, etc. If you know a recent progress or fact about it, please provide here. (I'm not really good at English conversation. But I can read & catch the vibe in English almost as well as in my mother language. In some sense, I might have merely wanted to make this question place.) This is not an essential topic. Welcome your expansion or remaking to another related topic. ===references=== Python as an Excel scripting language: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10549005-python-as-an-excel-scripting-language Questionnaire page: https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR7tUuWqOwSJFpBE5ZLhdkgtUMkhZWlkxRjhDRklXSjNTVkNSWkE2WlNQMS4u

24th May 2018, 3:58 PM
sumito_hz
sumito_hz - avatar
5 Answers
+ 7
I can't wait to see that working by default. So far, there is the xlwings project that enables it.
24th May 2018, 7:56 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 3
Kuba Siekierzynski, seamiki, Thank you for your information.😄
24th May 2018, 10:30 PM
sumito_hz
sumito_hz - avatar
+ 1
didnt they announce that they are adding javascript to excel early this month?
24th May 2018, 4:17 PM
Markus Kaleton
Markus Kaleton - avatar
+ 1
I see. I find the article just now. Thanks!
24th May 2018, 4:44 PM
sumito_hz
sumito_hz - avatar
+ 1
Markus Kaleton is right: No python support announced. support for js is available as an addon for developers at the moment: it should allow to call custom js functions as a formula and the spreadsheet data would be handled by the js engine instead of excel. Makes sense with the whole cloud services switch Microsoft is investing into.
24th May 2018, 8:46 PM
seamiki
seamiki - avatar