typescript

Basics of my setup. Working in single workbook with multiple worksheets in a 365 environment tied in to a Power Automate setup on Windows. Workbook will need to be accessible by multiple people and online, hence use of Office Scripts rather than VBA. I'm a relatively advanced Excel user when it...

There are at least three ways to automate Excel: VBA, Office Scripts and Script Lab. This article will show how to use TypeScript and Script Lab to perform repetitive spreadsheet tasks. From the Internet: ************************************************************************* What is Script...

Typescript is the language of Excel scripts, available at certain Office 365 licenses. Unfortunately, my company chose to disable this feature, so at this time I cannot use it. However, we can write TS outside of Excel. This article shows how to output TS data to a text file that Excel can read...

Today I am presenting the gift-wrapping algorithm, which calculates the convex hull for a bidimensional set of points. You can read more about it on the link below. Here are the main features of the code: It will start from scratch and generate an aleatory array of coordinates. If you prefer...

This is my second TypeScript article. Today we will see how to use functions and deal with shapes and images. The example below is not exactly production code, rather an assortment of working bits that you can use as reference when developing your own projects. In a nutshell, it creates a...

Certain Excel 365 licenses offer Office scripts, which is an implementation of the TypeScript language to automate Excel, just like VBA does. I am planning a small series of articles focusing on relevant TS features and their application to the Excel object model; this first one will deal with...