Tag - excel

SharePoint ToolBox 119 Microsoft Script Lab and PowerShell Scripts

Script Lab, a Microsoft Garage Project

Script Lab is a tool for anyone who wants to learn about writing add-ins for Excel, 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:

  • Code in a pane beside your spreadsheet. IntelliSense shows suggestions while you type so you can easily discover and use the Office JavaScript objects and methods. And if you don’t want to start from scratch there are plenty of samples preinstalled with Script Lab. Your snippets can use any TypeScript features like the magical async/await and conveniences like arrow functions and template strings. But it’s not only script: your snippets can also use HTML, CSS, and references to external libraries and data on the web. Script Lab uses the Monaco editor, the same tech that powers VS Code, so it’s beautiful and lightweight.
  • Run the code in another pane beside the editor. Execution can include logic, API calls to Office, UI in the pane, and even output to a console. Every time you make a code change you can refresh the editor and run the new version in seconds.
  • Share your snippets through GitHub. If you create a snippet you’d like to share, you can use Script Lab to save it. Then send the link to someone else to try it and tweak it on their computer. The Import feature lets you load other people’s snippets. We think sharing will be especially useful for asking and answering questions about add-ins on Stack Overflow (http://stackoverflow.com/questions/tagged/office-js).

You can install Script Lab right now for free from the Office Store. It works for Excel, Word, and PowerPoint on Office 2013 and later, Office Online, and Office for Mac.

The source code is open to the community at https://github.com/OfficeDev/script-lab. We welcome your contributions to the tool and to our snippets repo. We’re excited to keep building Script Lab with your help!

Reporting Office 365 Admin Role Group Members

This script produces a report of the membership of Office 365 admin role groups. The report is output to CSV file.

This script relies on the AzureAD PowerShell module, which you can install from the PowerShell Gallery.

1. Download the script from the link above.
2. Run the script using the usage examples below. You will be prompted to authenticate to Azure AD if you are not already connected.

Parameters

  • ReportFile – You can provide a custom output file name. The file name you specify will be modified with the current date, for example MyReportFileName.csv will become MyReportFileName-ddMMyyyy.csv. If a file of the same name exists, a unique character string will also be appended to the file name.

SharePoint ToolBox #013 Microsoft Data Explorer for Excel Preview

Im SharePointPodcast 260 hatten wir mit Markus Raatz ausführlich über das Thema Big Data gesprochen und u.a. auch den Microsoft Data Explorer Preview erwähnt (ab 27:10 min), mit dem man komfortabel Daten aus den unterschiedlichsten Quellen in Excel importieren kann (mehr dazu in den u.g. Links).

Links zum Data Explorer Preview

SharePoint ToolBox 60

Colorschemedesigner

Kostenloses Webtool zur Erstellung von Farbpaletten inklusive HTML, CSS und mehr für Webdesign.

Starter Master Pages for SharePoint

Starter Master Pages for SharePoint are a clean, commented starting point for creating your own SharePoint branding. Updated for SharePoint 2103

SharePoint 2010 – Selected items export to excel

Out of the box export to excel feature allows to export the complete view, and not the selected items. In order to achieve the functionality of exporting only selected items to excel.