Power Automate Office Scripts Basics - Revision history

Lsokolowski1 at 09:25, 28 August 2025

2025-08-28T09:25:48Z

← Older revision		Revision as of 09:25, 28 August 2025
Line 2:		Line 2:


	~~<slideshow style="nobleprog" headingmark="⌘" incmark="…" scaled="true" font="Trebuchet MS" >~~
	;title: Power Automate Office Scripts Basics		;title: Power Automate Office Scripts Basics
	;author: Lukasz Sokolowski		;author: Lukasz Sokolowski
	~~</slideshow>~~

Lsokolowski1: /* Exercises */

2024-12-12T12:26:22Z

Exercises

← Older revision		Revision as of 12:26, 12 December 2024
Line 359:		Line 359:
	#** add new script and call JSONed data from it (-'		#** add new script and call JSONed data from it (-'
	#*** HINT: use link from the top of this presu (-8		#*** HINT: use link from the top of this presu (-8
	#** Count '''how many empty rows''' are there in the ~~worksheet~~?		#** Count '''how many empty rows''' are there in the current working area?
	# Create another workbook in Excel Online		# Create another workbook in Excel Online
	#* use '''Simple service invoice'''		#* use '''Simple service invoice'''

Lsokolowski1: /* Exercises */

2024-12-12T11:41:18Z

Exercises

← Older revision		Revision as of 11:41, 12 December 2024
Line 359:		Line 359:
	#** add new script and call JSONed data from it (-'		#** add new script and call JSONed data from it (-'
	#*** HINT: use link from the top of this presu (-8		#*** HINT: use link from the top of this presu (-8
			#** Count '''how many empty rows''' are there in the worksheet?
	# Create another workbook in Excel Online		# Create another workbook in Excel Online
	#* use '''Simple service invoice'''		#* use '''Simple service invoice'''

Lsokolowski1: /* Exercises Con't */

2024-12-12T06:50:21Z

Exercises Con't

← Older revision		Revision as of 06:50, 12 December 2024
Line 392:		Line 392:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	# Get Data from outside (of a table) <syntaxhighlight lang="ts">		# Get Data from outside (of a table) <syntaxhighlight lang="ts" class="mw-collapsible mw-collapsed">
	function main(workbook: ExcelScript.Workbook) {		function main(workbook: ExcelScript.Workbook) {
	let ws = workbook.getWorksheet("TableData");		let ws = workbook.getWorksheet("TableData");
Line 419:		Line 419:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	# Get CSV <syntaxhighlight lang="ts">		# Get CSV <syntaxhighlight lang="ts" class="mw-collapsible mw-collapsed">
	function main(workbook: ExcelScript.Workbook, csv: string) {		function main(workbook: ExcelScript.Workbook, csv: string) {
	let tab: schema[] = [];		let tab: schema[] = [];
Line 458:		Line 458:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	# Regexps <syntaxhighlight lang="ts">		# Regexps <syntaxhighlight lang="ts" class="mw-collapsible mw-collapsed">
	function main (workbook: ExcelScript.Workbook, inputString: string,rgex: string,flag: string) {		function main (workbook: ExcelScript.Workbook, inputString: string,rgex: string,flag: string) {
	let regEx = new RegExp(rgex, flag);		let regEx = new RegExp(rgex, flag);
Line 471:		Line 471:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	# Sort Array <syntaxhighlight lang="ts">		# Sort Array <syntaxhighlight lang="ts" class="mw-collapsible mw-collapsed">
	function main(workbook: ExcelScript.Workbook, direct:string, sortType: string, data: schema[]) {		function main(workbook: ExcelScript.Workbook, direct:string, sortType: string, data: schema[]) {
	let sortArray: schema[] = [];		let sortArray: schema[] = [];

Lsokolowski1: /* Exercises Con't */

2024-12-12T06:49:35Z

Exercises Con't

← Older revision		Revision as of 06:49, 12 December 2024
Line 369:		Line 369:

	== Exercises Con't ==		== Exercises Con't ==
	# Write data <syntaxhighlight lang="ts">		# Write data <syntaxhighlight lang="ts" class="mw-collapsible mw-collapsed">
	function main(workbook: ExcelScript.Workbook, param: tab[]) {		function main(workbook: ExcelScript.Workbook, param: tab[]) {
	let wb = workbook.getWorksheet("Sheet1");		let wb = workbook.getWorksheet("Sheet1");

Lsokolowski1: /* Exercises Con't */

2024-12-12T06:48:36Z

Exercises Con't

@@ Line 420: / Line 420: @@
 </syntaxhighlight>
 # Get CSV <syntaxhighlight lang="ts">
 </syntaxhighlight>

Lsokolowski1: /* Exercises Con't */

2024-12-12T06:45:35Z

Exercises Con't

@@ Line 369: / Line 369: @@
 == Exercises Con't ==
-# Write data<syntaxhighlight lang="ts">
+# Write data <syntaxhighlight lang="ts">
 function main(workbook: ExcelScript.Workbook, param: tab[]) {
      let wb = workbook.getWorksheet("Sheet1");
@@ Line 392: / Line 392: @@
+}
 </syntaxhighlight>

Lsokolowski1: /* Exercises Con't */

2024-12-12T06:42:54Z

Exercises Con't

← Older revision		Revision as of 06:42, 12 December 2024
Line 369:		Line 369:

	== Exercises Con't ==		== Exercises Con't ==
	# Write data		# Write data<syntaxhighlight lang="ts">
	<syntaxhighlight lang="ts">
	function main(workbook: ExcelScript.Workbook, param: tab[]) {		function main(workbook: ExcelScript.Workbook, param: tab[]) {
	let wb = workbook.getWorksheet("Sheet1");		let wb = workbook.getWorksheet("Sheet1");

Lsokolowski1: /* Exercises */

2024-12-12T06:42:40Z

Exercises

@@ Line 357: / Line 357: @@
 # Create workbook in Excel Online
 #* use '''Simple list''' template
-#** todo
+#** add new script and call JSONed data from it (-'
 # Create another workbook in Excel Online
 #* use '''Simple service invoice'''
@@ Line 366: / Line 367: @@
 #* use this template with Copilot:
 #** "Copy all rows from an Excel file to another excel file with a click of a button"

Lsokolowski1: /* Exercises */

2024-12-12T06:35:52Z

Exercises

← Older revision		Revision as of 06:35, 12 December 2024
Line 357:		Line 357:
	# Create workbook in Excel Online		# Create workbook in Excel Online
	#* use '''Simple list''' template		#* use '''Simple list''' template
			#** todo
	# Create another workbook in Excel Online		# Create another workbook in Excel Online
	#* use '''Simple service invoice'''		#* use '''Simple service invoice'''