![Sudhi Ramamurthy](/img/default-banner.jpg)
- Видео 19
- Просмотров 133 373
Sudhi Ramamurthy
США
Добавлен 23 июл 2007
Find recording of projects and scenarios to automate your day to day tasks using Office Scripts for Excel.
Office Scripts: Top 5 tips to improve your scripting skills in Excel
Checkout this page for full description and source & Excel sample file used in the video:
github.com/sumurthy/officescripts-projects/tree/main/Top%205%20Tips
github.com/sumurthy/officescripts-projects/tree/main/Top%205%20Tips
Просмотров: 5 637
Видео
Office Scripts: Run Scripts for all Excel files in a folder using Power Automate
Просмотров 8 тыс.3 года назад
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...
Office Scripts: Introduction to the make-up of a script
Просмотров 16 тыс.3 года назад
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...
Office Scripts: Add Row at End of Worksheet
Просмотров 7 тыс.3 года назад
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
API Call from Office Scripts
Просмотров 5 тыс.3 года назад
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
Office Scripts: Update large Excel range in performant way
Просмотров 4,8 тыс.3 года назад
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
Excel Office Scripts: Using XLSM Macro Files in Run Script action
Просмотров 17 тыс.3 года назад
See github.com/sumurthy/officescripts-projects/blob/main/Excel and Power Automate/Using Excel Macro Files.MD
Excel Office Scripts: Application basics and environment
Просмотров 3,2 тыс.3 года назад
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
Excel Office Scripts: Range read and write in perf optimized way (small data)
Просмотров 2,4 тыс.3 года назад
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
Excel Office Scripts: Range basics
Просмотров 10 тыс.3 года назад
Checkout this page for code samples used: github.com/sumurthy/officescripts-projects/edit/main/Range Basics
Excel Office Scripts: Move Rows Across Tables and Manage Filters
Просмотров 10 тыс.3 года назад
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
Excel Office Scripts: Combine Excel tables into a master table
Просмотров 8 тыс.3 года назад
For source code and input files, check out this link: github.com/sumurthy/officescripts-projects/tree/main/Copy Tables to Master Table
Excel Office Scripts: Add comments to Excel Cells
Просмотров 1,5 тыс.3 года назад
For source code and input files, check out this link: github.com/sumurthy/officescripts-projects/tree/main/Add Excel Comments
Excel Office Scripts: Clear Hyperlinks from Excel Cells
Просмотров 5773 года назад
For source code and input Excel file, checkout: github.com/sumurthy/officescripts-projects/tree/main/Remove Hyperlinks from Excel Cells
Excel Office Scripts: Use Filter on Table and get Visible Range as Objects
Просмотров 6 тыс.3 года назад
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
Просмотров 8 тыс.3 года назад
Excel Office Scripts: Calculate, create Chart, get Chart & Table image, Email
Excel Office Scripts: Manage calculate mode, calculate
Просмотров 1,6 тыс.3 года назад
Excel Office Scripts: Manage calculate mode, calculate
Excel Office Scripts: Send Teams meeting invite based on Excel table data
Просмотров 7 тыс.3 года назад
Excel Office Scripts: Send Teams meeting invite based on Excel table data
Excel Office Scripts: Cross reference Multiple Excel Files
Просмотров 12 тыс.3 года назад
Excel Office Scripts: Cross reference Multiple Excel Files