Experiment with the Office JavaScript API without ever leaving Excel, Outlook, Word, or PowerPoint! Get Script Lab in Excel, Word, and PowerPoint, or Script Lab for Outlook, free from Microsoft AppSource.
Note: Script Lab was rewritten from the ground up in 2018 on a brand-new technology stack, including React and Fabric React. For the older version of Script Lab 2017, see more below.
Wouldn't it be crazy if you could launch Excel, click to open a small code window, and then instantly start writing and executing JavaScript that interacts with your spreadsheet?
Script lab is a tool for anyone who wants to learn about writing Office Add-ins for Excel, Outlook, Word, or PowerPoint. The focus is the Office JavaScript API, which is the technology you need for building Office Add-ins that run across platforms. Maybe you're an experienced Office developer and you want to quickly prototype a feature for your add-in. Or maybe you've never tried writing code for Office and you just want to play with a sample and tweak it to learn more. Either way, Script Lab is for you.
Script Lab has three main features:
Script Lab works in Office 2013 or later on Windows, Office on the web, or Office on Mac.
You can get Script Lab right now for free from Microsoft AppSource! It works for Excel, Word, and PowerPoint.
If you're interested in developing for Outlook, you can get Script Lab for Outlook, also free from AppSource.
Script Lab is a Microsoft Garage project that began at a hackathon. You can read the story of the original Script Lab creation on the Garage website.
Here's a 1-minute teaser video to give you a taste:
The easiest way to try Script Lab is in Excel with the tutorial workbook that walks you through the tool in a few steps. You can get it here: script-lab-tutorial.xlsx
Alternatively, you can start from scratch and get Script Lab in Excel, Word, or PowerPoint.
This 10-minute demo explains how to use the main features:
Script Lab is built around sharing. If someone gives you a URL to a GitHub GIST, simply open Script Lab, use the hamburger menu at the top left to see the menu, and choose "Import" category (either on the left or top, depending on the available screen space). Then, enter the URL of the GIST, and click the "Import" button at the bottom of the screen. In just these few clicks, you will be able to view and run someone else's snippet!
Conversely, to share your snippet with someone, choose the "Share" menu within a particular snippet. You can share as a public or private GitHub Gist, or you can copy the entire snippet metadata to the clipboard, and share it from there.
To report a bug, create a new issue. Please provide as much detail as you can: tell us the operating system, the Office build number, and your browser (if you're using Office on the web).
If you have a suggestion for a feature, please feel free to file it under "issues" as well, and we will tag it appropriately. The more detail, the better! We also gladly accept pull requests... (see more at CONTRIBUTING.md).
Finally, if you have a question, please ask it on https://stackoverflow.com instead. Tag your questions with office-js
and scriptlab
.
Script Lab was rewritten from scratch in 2018. Though its visual design remains similar to the 2017 version, its technology stack was overhauled to use React and Fabric React. Among the improvements are keyboard accessibility, a much faster runner, and user-configurable settings.
If you encounter issues or need one of the few features that haven't been ported over yet, you can -- for the time being -- switch to the 2017 version of Script Lab. To do so:
The original repo of the 2017 version, now in a mostly-archival state, can be found at https://github.com/OfficeDev/script-lab-2017.
Office 2013 has several limitations compared to more recent versions.
First, there are far fewer supported objects and methods in the JavaScript API for Office 2013. As a result, many snippets that work on later versions of Office will not run in Office 2013. In the Samples menu we have included certain samples specifically designed to use only capabilities that are available in Office 2013. Those samples are marked (2013) in the sample title.
Second, Office 2013 (and Office 2016 RTM, if you don't have a Microsoft 365 subscription) does not support ribbon buttons for Script Lab. As a result, there's a different way to access the Code and Run functions:
There are a bunch of ways you can contribute to Script Lab:
Finally, if you want to contribute code (bug fixes, features, localization, etc.), please see CONTRIBUTING.md to get you up and running with a local copy of Script Lab -- and then send us a pull request.
Leave a star-rating and (optionally) a review blurb for Script Lab on the Office Store review page.
Of course, we'd prefer that if you have issues you report them on GitHub instead, but you're free to leave any review comments you wish.
Branch | Status | Runner | Server | Storybook |
---|---|---|---|---|
master | script-lab-react-alpha | script-lab-react-runner-alpha | script-lab-react-server-alpha | |
beta | script-lab-react-beta | script-lab-react-runner-beta | script-lab-react-server-beta | |
production | script-lab-react | script-lab-react-runner | script-lab-react-server |
This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。