Several months ago the Excel folk within Microsoft asked users whether they'd like to have Python as an alternative scripting language in Office. Support for that was overwhelming, but nothing more was said on the matter since then. I guess this is Microsoft's answer.
Several months ago the Excel folk within Microsoft asked users whether they'd like to have Python as an alternative scripting language in Office. Support for that was overwhelming, but nothing more was said on the matter since then. I guess this is Microsoft's answer.
Ironically, I rarely create spreadsheets at all any more, because most of the time I can solve a problem in a more simple and maintainable way by writing a quick Python script to process the data. That way the data isn't all mixed together with invisible processing logic, and the data and logic are better suited for version control. The data can also stay in a more open and future-proof format like CSV or JSON.
Sometimes I still use a spreadsheet to load the final results so I can quickly view them in a grap
Excel (Score:5, Interesting)
Several months ago the Excel folk within Microsoft asked users whether they'd like to have Python as an alternative scripting language in Office. Support for that was overwhelming, but nothing more was said on the matter since then. I guess this is Microsoft's answer.
Re: (Score:5, Insightful)
Several months ago the Excel folk within Microsoft asked users whether they'd like to have Python as an alternative scripting language in Office. Support for that was overwhelming, but nothing more was said on the matter since then. I guess this is Microsoft's answer.
Ironically, I rarely create spreadsheets at all any more, because most of the time I can solve a problem in a more simple and maintainable way by writing a quick Python script to process the data. That way the data isn't all mixed together with invisible processing logic, and the data and logic are better suited for version control. The data can also stay in a more open and future-proof format like CSV or JSON.
Sometimes I still use a spreadsheet to load the final results so I can quickly view them in a grap
Re:Excel (Score:2)
Same here; I use AWK to process the data and upload them to Excel for the Graphical views;