Explanation

Office Scripts is Microsoft’s automation technology for Excel, particularly useful with Excel for the web and Microsoft 365. It allows you to automate repetitive Excel tasks using TypeScript-based scripts.

Common Uses

  • Format worksheets
  • Clean data
  • Create reports
  • Apply formulas
  • Sort/filter data
  • Automate repetitive tasks
  • Work with Power Automate

Example

A simple Office Script can access the workbook and format a range:

function main(workbook: ExcelScript.Workbook) {

  const sheet = workbook.getWorksheet(“Sales”);

  const range = sheet.getRange(“A1:H1”);

  range.getFormat().getFont().setBold(true);

}

Key Point

VBA is traditionally desktop-oriented, while Office Scripts is designed particularly for modern Microsoft 365 and web-based automation workflows.

Practice

Create an Office Script that formats the first row of a Sales worksheet as a report heading.

PreviousNext