Metaflow - Standalone Excel Automation

Standalone Excel Automation

Metaflow referentie: Code

Open

Optie	Waarde	Type veld
Path	Path to the spreadsheet file	source

Create

Add worksheet

Optie	Waarde	Type veld
Activate sheet	Determines whether to activate worksheet after creation	True/ false

Add worksheet with name

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst
Activate sheet	Determines whether to activate worksheet after creation	True / false

Copy worksheet and rename

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst
New Name	New Name of worksheet	Tekst

Copy worksheet

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst

Worksheet exists

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst

Activate Worksheet

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst

Activate Worksheet by Index

Optie	Waarde	Type veld
Index	Index of worksheet to activate	Tekst

Rename worksheet

Optie	Waarde	Type veld
Name	Name of worksheet	Tekst
New Name	New Name of worksheet	Tekst

Rename worksheet by Index

Optie	Waarde	Type veld
Index	Index of worksheet to rename	Tekst
New Name	New Name of worksheet	Tekst

Delete worksheet by Index

Optie	Waarde	Type veld
Index	Index of worksheet to delete	Tekst

Delete worksheet

Optie	Waarde	Type veld
Index	Name of worksheet to delete	Tekst

Hide worksheet by Index

Optie	Waarde	Type veld
Index	Index of worksheet to hide	Tekst

Hide worksheet

Optie	Waarde	Type veld
Index	Name of worksheet to hide	Tekst

Show worksheet by Index

Optie	Waarde	Type veld
Index	Index of worksheet to display	Tekst

Show worksheet

Optie	Waarde	Type veld
Index	Name of worksheet to display	Tekst

Set text value

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Value	New cell value	Tekst

Set generic value

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Value	New cell value	Tekst

Set formula

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Value	New cell formula. Text of the formula should be provided in English US.	Tekst

Get formula

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Result	Return value from function	Tekst

Get Value

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Result	Return value from function	Tekst

Clean Value

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst

Get Active Value

Optie	Waarde	Type veld
Result	Return value from function	Tekst

Get active row

Optie	Waarde	Type veld
Result	Return value from function	Tekst

Get active column

Optie	Waarde	Type veld
Result	Return value from function	Tekst

Set active cell

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst

Set cell format

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Cell format	Type of cell format	Numeric / string / formula / boolean / blank

Get last used column

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Result	Return value from function	Tekst

Get last used row

Optie	Waarde	Type veld
Result	Return value from function	Tekst

Get defined table

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
Result	Return value from function	Tekst

Get table

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Result	Return value from function	Tekst

Clean table

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst

Available colors

Optie	Waarde	Type veld
Result	Return value from function	Tekst

Format cell background color

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Color	Cell color	dropdown

Format cells background color

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
Color	Cell color	dropdown

Format cell border

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
style	Border style	dropdown

Format cells border

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
style	Border style	dropdown

Format cell font size

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Size	Font size of cell	Tekst

Format cells font size

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
Size	Font size of cell	dropdown

Format cell font color

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Color	Font color	dropdown

Format cells font color

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
Color	Font color	dropdown

Autofit columns

Format column

Optie	Waarde	Type veld
Column index	Index of column. Cell indexing starts at 0,0	Tekst
Width	Column width	Tekst

Format columns

Optie	Waarde	Type veld
First column	First column index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst
Width	Column width	Tekst

Autofit rows

Format row

Optie	Waarde	Type veld
Row index	Index of row. Cell indexing starts at 0,0	Tekst
Height	Row width	Tekst

Format rows

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Height	Row width	Tekst

Merge

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
First column	First column index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst

Save

Optie	Waarde	Type veld
Directory path	Path to directory where file should be saved	Source
File name	Name of the file	Tekst

Save as XLS

Optie	Waarde	Type veld
Directory path	Path to directory where file should be saved	Source
File name	Name of the file	Tekst

Save as XLSX

Optie	Waarde	Type veld
Directory path	Path to directory where file should be saved	Source
File name	Name of the file	Tekst

Hide rows

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst

Hide row

Optie	Waarde	Type veld
Row index	index of row. Cell indexing starts at 0,0	Tekst

Hide columns

Optie	Waarde	Type veld
First column	First column index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst

Hide column

Optie	Waarde	Type veld
Column index	column index. Cell indexing starts at 0,0	Tekst

Show rows

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst

Show row

Optie	Waarde	Type veld
Row index	row index. Cell indexing starts at 0,0	Tekst

Show columns

Optie	Waarde	Type veld
First column	First column index. Cell indexing starts at 0,0	Tekst
Last column	Last column index. Cell indexing starts at 0,0	Tekst

Show column

Optie	Waarde	Type veld
Column index	column index. Cell indexing starts at 0,0	Tekst

Delete row

Optie	Waarde	Type veld
Row index	Row index. Cell indexing starts at 0,0	Tekst

Delete rows

Optie	Waarde	Type veld
First row	First row index. Cell indexing starts at 0,0	Tekst
Last row	Last row index. Cell indexing starts at 0,0	Tekst

Close