script-lab | Create , run and share your code directly from Office

by OfficeDev TypeScript Version: Current License: MIT

X-Ray Key Features Code Snippets Community Discussions(4)Vulnerabilities Install Support

kandi X-RAY | script-lab Summary

script-lab is a TypeScript library. script-lab has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

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.

Support

Quality

Security

License

Reuse

Support

script-lab has a low active ecosystem.

It has 596 star(s) with 132 fork(s). There are 53 watchers for this library.

It had no major release in the last 6 months.

There are 143 open issues and 342 have been closed. On average issues are closed in 120 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of script-lab is current.

Quality

script-lab has 0 bugs and 0 code smells.

Security

script-lab has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

script-lab code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

script-lab is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

script-lab releases are not available. You will need to build from source code and install.

Installation instructions are available. Examples and code snippets are not available.

It has 4701 lines of code, 0 functions and 261 files.

It has low code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of script-lab

Get all kandi verified functions for this library.

script-lab Key Features

No Key Features are available at this moment for script-lab.

script-lab Examples and Code Snippets

No Code Snippets are available at this moment for script-lab.

Community Discussions

Trending Discussions on script-lab

Can Office-JS trigger a VBA Workbook or Worksheet Event Procedure?

Cannot create snippet and view samples in script-lab in MS-Excel Office365

Issue Badges for closed/opened to display on GitHub Markdown files

`context.document.body.insertOoxml` breaks documents, crashes word

QUESTION

Can Office-JS trigger a VBA Workbook or Worksheet Event Procedure?

Asked 2019-Sep-19 at 04:05

I'm trying to see if there is a way to do something in Office-JS that would trigger an event procedure to run in Excel VBA, but it looks like VBA events are disabled during the execution of the JavaScript code.

Let's say for example that I have a workbook with a worksheet named "Sheet1" and in that sheet module I have the following code:

...

ANSWER

Answered 2019-Sep-18 at 23:49

The change event does not run but the selectionchange event does, so you could use that to trigger your code: populate a specific cell and then select it

Source https://stackoverflow.com/questions/58001786

QUESTION

Cannot create snippet and view samples in script-lab in MS-Excel Office365

Asked 2018-Jun-26 at 01:50

Problem: Below are the images to understand the behavior of Script-Lab on my machine. It happens across all office products that I tested For e.g. Excel, Word or PowerPoint. So, I can't create new snippet and can not see the samples.

Environment: I am using registered Microsoft Office 365 ProPlus version 1708 (Build 8431.2215) on Windows 10 Operating system (desktop) and default browser is Internet Explorer (11.1029.15063.0). The installation appeared successful. I didn't faced any error during installation. The Script Lab menu is appearing just fine but not working eventually.

More info: Interestingly, I can view, edit and run the snippets saved on GitHub gist but I can't create my own or view samples due to this error (see screenshot below)

Screenshots: #1: When I create a new snippet, it says that it can't import the snippet.

#2: When I click on samples to view existing samples, it says that there aren't any samples available for this host yet.

...

ANSWER

Answered 2018-Jun-26 at 01:48

Below are the proven valid scenarios for the Script-Lab to behave in undesired manner as happened in my case above. I am adding the solution, if anyone encounter it again, please follow the steps below.

Identify the problem : In the background, when script-lab opens it tries to access github content. So, if you

do not have internet connection, or
have firewall protecting github url (specifically, raw.githubusercontent.com)

then neither Snippets nor Samples will be loaded in the script-lab. So, make sure you can open the links below

https://raw.githubusercontent.com/OfficeDev/office-js-snippets/deploy-prod/playlists/excel.yaml

https://raw.githubusercontent.com/OfficeDev/office-js-snippets/deploy-prod/samples/excel/01-basics/basic-api-call.yaml

In my case, organization is blocking the urls containing raw as I could otherwise access every other link on github.

Solution: If for any reason, you can't still access these URLs, then as a workaround, you can access all the samples from https://github.com/OfficeDev/office-js-snippets/tree/master/samples/excel and then choose one and copy-paste the entire YAML. Eg.., for the default sample, just paste in the following into the "import" textbox or you can use import facility to use the YAML links at this location.

Feedback : If you happen to be a script-lab developer, I believe these samples can be the part of Excel add-in, proving more useful for offline users of various organisations.

Source: Resolved on Github.

Source https://stackoverflow.com/questions/50502279

QUESTION

Issue Badges for closed/opened to display on GitHub Markdown files

Asked 2017-Aug-14 at 05:10

I have a markdown page on GitHub where I am referencing a number of issues. It would be really handy if there was a way to include an image/icon that would display the issue status (closed or opened) from within that Markdown file, just like people do with the Travis "Build passing" badge.

I am envisioning something like:

Is there any way to do such a thing? And maybe even display labels, in addition to the status (open/closed)?

...

ANSWER

Answered 2017-Aug-14 at 05:10

This isn't fully supported yet:

this was requested in github/markup issue 965
this was implemented (for total of issues only) in badges/shields PR 1020

Maybe the badges/shields will implement a badge for a given issue.

Source https://stackoverflow.com/questions/45664856

QUESTION

`context.document.body.insertOoxml` breaks documents, crashes word

Asked 2017-May-11 at 17:14

I know this is not a question, but I was sent here by Rick Kirkham from here, and apparently asking on SO is the way to file bugs for Microsoft products :-p

When I use insertOoxml with the 'replace' parameter, Word will insert extra content at the end. For example, when using the following code in Script Lab, with a new, empty word document:

...

ANSWER

Answered 2017-May-11 at 17:14

I verified with the newer build that Word does not crash, but an extra empty paragraph is indeed added. This bug was resolved yesterday and the fix will be available in the next month. Thanks!

Source https://stackoverflow.com/questions/43857750

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install script-lab

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 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.

Support

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.

Find more information at: