Microsoft has an Excel Suggestion Box subsite at the customer engagement website uservoice. So users can make any suggestions and from time to time a Microsoft project lead will join the discussion about certain suggestions. This has happened when someone suggested Python as an Excel scripting language. This has higher votes than any other suggestion (currently past 4000).
The Microsoft Project lead is Ashvini Sharma, Lead Program Manager, Microsoft Excel and he is requesting that users fill out a survey on this topic.
The comments thread throws up some recommendations about Python technologies already available, here is a list (in arrival sequence)
- Pandas
- pyxll - Python in Excel
- xlwings - Python For Excel. Free & Open Source.
- NumPy
- SciPy
- IronPython
- Python in Excel - DataNitro
- Creating Excel files with Python and XlsxWriter — XlsxWriter Documentation
- openpyxl - A Python library to read_write Excel 2010 xlsx_xlsm files — openpyxl 2.4.9 documentation
- B. Nikolic ExPy - Integration of Python with Microsoft Excel
- xlrd 1.1.0 - Library for developers to extract data from Microsoft Excel (tm) spreadsheet files
- xlwt - This is a library for developers to use to generate spreadsheet files compatible with Microsoft Excel versions 95 to 2003.
- SymPy - is a Python library for symbolic mathematics.
- Excel plug-ins for Anaconda
- XLLoop - Excel User-Define Functions in Java, Javascript, Ruby, Python, Erlang
- excelpython - GitHub - ericremoreynolds - An open source, easy to use interface for calling Python code from Excel
- Dirigible, the Pythonic spreadsheet in your browser
- SolverStudio for Excel _ An integrated environment for optimisation using modelling languages within Excel
- Python is Now the Most Popular Introductory Teaching Language at Top U.S. Universities
Important technical points worth echoing
- Handle OLEVariants with high performance - compiled C# code can be slower than interpreted VBA code because of VBA's affinity to OLEVariant and C#'s boxing and unboxing issues.
R is also spoken of. Increasing I see job adverts with VBA, Python and R together. Here is a (shorter) list of R resources
- Microsoft R Open - The Enhanced R Distribution . MRAN
- Machine Learning Server Overview – Python and R Data Analysis - Microsoft
- Microsoft's R Strategy - ZDNet
- Getting started with R Tools for Visual Studio
- R: Windows Component Services Integrating R and Excel on the COM Layer - Thomas Baier
- Using COM facilities in R - Duncan Temple Lang
- Embedding R in Applications on Windows
- Statconn - Download the latest version here
- Using R.NET in Excel
And the Javascript advocates pitched in, some links
Miscellany
No comments:
Post a Comment