Python for Excel
de Boardflare
Run Python code locally in Excel for free.
Run Python code as a function to power your formulas and LAMBDA functions, which is not possible with Excel's native PY(). For example: =BOARDFLARE.RUNPY("arg1 + 2", arg1) will add 2 to the argument (arg1) passed to the function.
This enables you to build custom functions using Python without building a custom Excel add-in. This was originally conceived as an internal tool for prototyping custom functions based on Python, and we decided to publish it as a free add-in.
Benefits
✅ Use Python as a function in formulas and LAMBDAs.
🆓 Free add-in, no Office 365 license required.
🌐 Works in Excel for web as well as desktop.
☁️ Runtime has network access for API calls (need CORS).
📦 Import custom packages (pure Python only).
🔒 Runs locally, so no data is shared outside Excel.
➡️ Code can be loaded from a URL (e.g. GitHub).
🚀 Performance is only limited by your CPU.
This is a work in progress and is intentionally very minimalist. See our Python for Excel documentation for details.
Capacidades da aplicação
- Pode ler e efetuar alterações ao seu documento
- Pode enviar dados através da Internet