Compatible with web version Excel, operating automation script

close up

news

　Microsoft has announced on the 27th (local time) that the script function "Office Scripts" has been implemented in the web version of Excel.

　This feature is available in a commercial user or a license for educational institutions (such as Office 365 E3 or E5) that can access the Microsoft 365 desktop app.If you are these users, a menu "automation" has been added to the Excel menu bar.

　The script is recorded simply by pressing "Record Operation" in this automation menu and performing a series of operations, and no programming knowledge is required.If you want to customize the script, you can edit it directly with the TypeScript -based editor.

　If you want to execute the recorded script according to the schedule, you can use Power Automate to set flows and scheduling.