Python in Excel – Available Now
Microsoft has launched Python in Excel for Microsoft 365 Business and Enterprise users, enabling advanced analytics with popular libraries, a Copilot feature for code generation, and enhanced security measures.
Read original article
Microsoft has announced the general availability of Python in Excel for Windows users of Microsoft 365 Business and Enterprise. This integration, developed in partnership with Anaconda, allows users to combine Python's powerful analytics capabilities with Excel's flexibility without any setup. Users can now utilize popular Python libraries such as pandas, Matplotlib, and NLTK directly within Excel workbooks. The feature supports advanced analytics, including predictive modeling and data visualization, and simplifies complex data handling. Additionally, a new Copilot feature enables users to generate Python code using natural language prompts, enhancing accessibility for those unfamiliar with coding. Security measures ensure that Python code runs in isolated containers on the Microsoft Cloud, protecting user data. Python in Excel is available to users with qualifying Microsoft 365 subscriptions, with options for enhanced performance through an add-on license. Microsoft encourages user feedback to continue improving the feature.
- Python in Excel is now available for Microsoft 365 Business and Enterprise users on Windows.
- Users can leverage popular Python libraries for advanced analytics and data visualization.
- The new Copilot feature allows for natural language prompts to generate Python code.
- Security measures ensure data protection by running Python code in isolated containers.
- Feedback from users is encouraged to enhance the functionality of Python in Excel.
Related
Microsoft365 apps now support OpenDocument Format 1.4 (LibreOffice Format)
Microsoft 365 apps now support OpenDocument Format 1.4, enhancing Word, Excel, and PowerPoint. ODF 1.4 brings new features like table support in shapes and improved writing modes. Users can give feedback for further improvements.
Show HN: Briefer – multiplayer notebooks with schedules, SQL, and built-in LLMs
Briefer Notebooks launch on July 23, 2024, offering cloud-based notebooks supporting SQL and Python. Features include organizing, customizing, restoring, block types, AI assistance, scheduling, versioning, collaboration, dashboards, and access control.
Microsoft Remote Desktop will be renamed to Windows App
Microsoft's Windows App will be generally available this fall for Windows, Web, iOS, and macOS, offering secure access to Windows environments and advanced security features, with an Android preview later this year.
Python Developer Survey: 55% use Linux, 6% use Python 2
The 7th annual Python Developers Survey revealed 85% of over 25,000 respondents use Python as their primary language, with 73% on recent versions and 37% contributing to open-source projects.
Microsoft 365 Copilot Wave 2: Pages, Python in Excel, and Agents
Microsoft 365 Copilot Wave 2 introduces collaborative features like Copilot Pages, Python support in Excel, and enhancements in PowerPoint, Teams, Outlook, and Word, totaling over 700 updates this year.
15 commentsFor local python in a spreadsheet, LibrePythonista allows running IPython code in a LibreOffice spreadsheet
When you get very complicated flows, of one cell pointed to another cell, it becomes a massive mess. It's hard to debug and there's no way to "linearize" the flow into something more legible, and even harder to log everything. I hope Python in Excel figures out how to get over those hurdles
So with a little bit of effort this has already been a thing for 2 decades.
Not entirely sure how you move from plain win32 to DCOM, and it's probably a bit more difficult than WSH, but it should be doable.
This is disappointing. A much easier way to 'keep your data private' would be to run it locally. Surely a bundled Python interpreter run inside a sandbox that prevents network access would be just as secure, and cheaper for Microsoft since they don't have to run any Azure resources to support it.
If you've ever written a spreadsheet of meaningful complexity, you've probably been forced into a disastrous mess of nested IF statements (or helper columns).
Python is soooo much easier to read than the built-in formulas.
I'm excited to try this out!
Nope, not only there is the security issue, regardless of what is promised, good luck editing those Excel files in flights, or train travels.
Related
Microsoft365 apps now support OpenDocument Format 1.4 (LibreOffice Format)
Microsoft 365 apps now support OpenDocument Format 1.4, enhancing Word, Excel, and PowerPoint. ODF 1.4 brings new features like table support in shapes and improved writing modes. Users can give feedback for further improvements.
Show HN: Briefer – multiplayer notebooks with schedules, SQL, and built-in LLMs
Briefer Notebooks launch on July 23, 2024, offering cloud-based notebooks supporting SQL and Python. Features include organizing, customizing, restoring, block types, AI assistance, scheduling, versioning, collaboration, dashboards, and access control.
Microsoft Remote Desktop will be renamed to Windows App
Microsoft's Windows App will be generally available this fall for Windows, Web, iOS, and macOS, offering secure access to Windows environments and advanced security features, with an Android preview later this year.
Python Developer Survey: 55% use Linux, 6% use Python 2
The 7th annual Python Developers Survey revealed 85% of over 25,000 respondents use Python as their primary language, with 73% on recent versions and 37% contributing to open-source projects.
Microsoft 365 Copilot Wave 2: Pages, Python in Excel, and Agents
Microsoft 365 Copilot Wave 2 introduces collaborative features like Copilot Pages, Python support in Excel, and enhancements in PowerPoint, Teams, Outlook, and Word, totaling over 700 updates this year.