You can now use Python in Microsoft Excel

If you’ve been feeling constrained by Microsoft Excel’s methods for manipulating data, you’re in luck—Python can now be used within your spreadsheets. The inclusion of the popular programming language went live earlier this week, with the feature available as a public preview. According to Microsoft, this integration is completely native within Excel; you won’t need to run any setup for it to work. (However, you will need to be part of the Microsoft 365 Insider program to access preview features in Office apps.) You type Python code directly into cells using the new =PY() function, which then gets executed in the cloud. The results are displayed in the worksheet. In the examples shown by Microsoft, common actions like creating pivot tables and charts will be possible using Python. Microsoft’s partnership with Anaconda, a Python repository that contains popular libraries like Matplotlib, pandas, and scikit-learn, should also enable more advanced visualizations. https://wus-streaming-video-rt-microsoft-com.akamaized.net/b0fdb8c9-a6ea-498d-a20e-a1e1edcc224d/ab0de05b-079e-41db-9c10-7bce9dbb_6750.mp4 Microsoft’s teaser video for Python in Excel. The only potential limitation is that everything runs in the cloud—you won’t have any access to local installations of Python, including any customizations you may have set up. This is in part for security purposes; Microsoft says Python in Excel is secured through use of isolated containers, with the code running in a... Continue reading at 'PC World'

[ PC World | 2023-08-24 20:21:37 UTC ]

Other news stories related to: "You can now use Python in Microsoft Excel"


The Week in Libraries: New Reader Survey Urges Publishers, Libraries to Bridge Their Data Gap

Among the stories making news this week: veteran bookseller and library advocate Tim Coates releases a reader-focused survey; more drama over Drag Queen Storytimes; and what to expect from all the talk of antitrust action in the tech sector. Continue reading at Publishers Weekly

[ Publishers Weekly | 2019-06-14 04:00:00 UTC ]
More news stories like this


Translated Books Gain Visibility in Libraries

The Global Literature in Libraries Initiative takes translations to the ALA Annual Conference and administers a YA prize. Continue reading at Publishers Weekly

[ Publishers Weekly | 2019-06-14 04:00:00 UTC ]
More news stories like this


Trapeze reveals five new signings on official launch day

Trapeze, one of Orion's newest imprints, has announced five new acquisitions to coincide with the official launch of the imprint, among them The Brexit Survival Activity Book, and a new book by Dan The Diamond Minecart. Continue reading at The Bookseller

[ The Bookseller | 2016-10-07 00:00:00 UTC ]
More news stories like this


Amazon launches Kindle tablet and e-reader in China

After remaining quiet on the hardware front for years, Amazon.com's China business has finally brought the company's Kindle tablet and Kindle e-reader to the country. On Friday, both the Kindle Fire HD and Kindle Paperwhite went on sale through the company's site in the country. The Kindle... Continue reading at PC World

[ PC World | 2013-06-07 00:00:00 UTC ]
More news stories like this


Horrible Histories hits 10,000 benchmark

Written By: Caroline Horn Publication Date: Fri, 19/08/2011 - 08:45 Around 10,000 people have signed up to Scholastic's Horrible Histories virtual world since its official launch last week and the beta testing period over the summer. Publisher Scholastic intends to develop further "Horribles"... Continue reading at The Bookseller

[ The Bookseller | 2011-08-18 00:00:00 UTC ]
More news stories like this


Gardners Hive will look to apps post launch

Written By: Lisa Campbell Publication Date: Wed, 06/04/2011 - 09:13 Gardners will look to create a mobile phone app for Hive after its official launch. The book wholesaler has been working with e-consultancy firm Tangent One to build the Hive website, which will sell books directly to... Continue reading at The Bookseller

[ The Bookseller | 2011-04-06 00:00:00 UTC ]
More news stories like this