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