A comprehensive comparison between Excel’s new native regex functions (REGEXTEST, REGEXEXTRACT, REGEXREPLACE) and Python’s powerful re module.
Access the full power of scipy.stats in Excel with our new Python-powered statistical functions, offering comprehensive distribution support and advanced analytics.
We’ve launched a new repository of Python functions that can be used directly in Excel via our add-in or as standalone web apps.
Explore how AI-powered functions like AI_ASK, AI_EXTRACT, and AI_FORMAT are revolutionizing spreadsheet workflows by enabling natural language interaction and intelligent data processing.
Introducing a major update to our Python for Excel add-in: a new Monaco-based code editor with syntax highlighting, function management, and integrated testing.
Perform approximate string matching in Excel using the NLTK library and Python, enabling powerful fuzzy search capabilities beyond exact matches.
Integrate Azure AI Language service with Excel to perform advanced aspect-based sentiment analysis on customer reviews and text data.
Learn about the new BOARDFLARE.RUNPY function and how we’ve aligned our API with Microsoft’s Python in Excel for better code compatibility.
An in-depth review of Microsoft’s native Python in Excel feature, exploring its strengths, weaknesses, and available alternatives like Boardflare.
Overview of the new native TRANSLATE and DETECTLANGUAGE functions in Excel and how they compare to alternative solutions.
Bring Google Sheets’ translation capabilities to Excel with our local machine learning implementation that ensures data privacy.
A guide on implementing background processing in Google Apps Script using the inline web worker pattern to keep your extension’s UI responsive.