Welcome to the office-scripts-excel
repository! This collection contains various scripts designed for use in an Excel environment with Office Scripts (TypeScript).
├── name
├── name.ts
└── name.osts
.ts
file: This file contains the raw TypeScript code of the script..osts
file: This file is ready to be imported directly into Excel.
There are two methods to integrate these scripts into your Excel environment:
- Open Excel.
- Go to the
Automate
tab. - Select
New Script
. - Give your script a name.
- Copy and paste the script content from the
.ts
file provided in this repository. - Click
Save Script
.
- Download the
.osts
file from this repository. - Copy the file into a OneDrive or SharePoint folder (the file must be stored in the cloud).
- Open Excel.
- Go to the
Automate
tab. - Select
All scripts
. - Click on
View more scripts
. - Choose the
.osts
file to import it.
By following these methods, you can easily integrate and use the scripts provided in this repository to enhance your Excel automation tasks.
If you have any scripts you'd like to contribute or improvements to suggest, feel free to create a pull request or open an issue!
"Sit back and relish in the extra time you've just unlocked!"