Видео

Check out the source code of this project and other projects at this site: github.com/sumurthy/officescripts-projects/tree/main/Run Scripts for All Excel Files in Folder (Note - use table.getRowCount() API instead of the one I'm showing in the video to check the number of actual data rows in the table) Chapters 0:00 Introduction 1:50 Use Recorder to capture actions 3:00 Edit script 8:48 Setup P...

See here for more details and additional samples: github.com/sumurthy/officescripts-projects/tree/main/Getting Started#gentle-introduction-to-script Content: 0:00 Introduction to scripts 13:57 Switch to the Excel web app and access Office Scripts (Automate tab) 14:48 Start a new script - introduction to `main` function 15:28 Getter methods 19:06 Method chaining 21:49 Checking for `undefined` ty...

Checkout the description here: github.com/sumurthy/officescripts-projects/blob/main/Range Basics/README.MD Content 0:00 Introduction 0:55 Start scripting 6:40 Move logic to a function

Web page: github.com/sumurthy/officescripts-projects/blob/main/API Calls/README.MD Content 0:00 Intro 2:40 Scenario and API reference 5:16 Scripting 15:55 Results and conclusion

Checkout this page for script source: github.com/sumurthy/officescripts-projects/tree/main/Performance Contents 0:00 Intro 2:32 main() function 4:44 Update range in chunks function 11:57 Core logic - compute range address and update 17:00 Smaller range update (in one go) 18:05 See it in action

See github.com/sumurthy/officescripts-projects/blob/main/Excel and Power Automate/Using Excel Macro Files.MD

Checkout the document referred in the video: github.com/sumurthy/officescripts-projects/blob/main/Getting Started/README.MD Contents 0:00 Intro 0:25 Access and availability 2:15 Core features 4:44 Code editor features 10:15 Editor short-cuts

If the range/data you are dealing with is quite large (say 100K cells), you may need to use advanced techniques like breaking-up your read/writes into multiple chunks. This video is really for small-mid size data setup. For large dataset, refer to github.com/sumurthy/officescripts-projects/tree/main/Performance

Checkout this page for code samples used: github.com/sumurthy/officescripts-projects/edit/main/Range Basics

This video shows how to moves certain rows that meet a criteria from one Excel table (source) into a another table (target) on another worksheet using (1) plain values based selection and (2) using column filter all using Office Scripts. Source code, input Excel files and much more at: github.com/sumurthy/officescripts-projects/tree/main/Move Rows Across Tables

For source code and input files, check out this link: github.com/sumurthy/officescripts-projects/tree/main/Copy Tables to Master Table

For source code and input files, check out this link: github.com/sumurthy/officescripts-projects/tree/main/Add Excel Comments

For source code and input Excel file, checkout: github.com/sumurthy/officescripts-projects/tree/main/Remove Hyperlinks from Excel Cells

For source code and input files, checkout this link: github.com/sumurthy/officescripts-projects/tree/main/Filter Table Get Visible Range as Object Array

Excel Office Scripts: Calculate, create Chart, get Chart & Table image, Email

Excel Office Scripts: Manage calculate mode, calculate

Excel Office Scripts: Send Teams meeting invite based on Excel table data

Excel Office Scripts: Cross reference Multiple Excel Files