MS Office

Studio Pro Activities > MS Office

MS Word

ActivityDefinition
Read Word fileReads the content of a Word file
Write Word fileOverwrites the content of a Word document
Append to Word fileAppends data to a Word document
Replace words in templateReplace words in a Word file with the desired values

MS Excel

ActivityDefinition
Read Excel FileRead the contents of an Excel table
Write Excel FileWrite specified values to a specified range in an Excel file
Append row to Excel fileAdd a row to the end of an Excel sheet
Insert/Delete RowsInsert or delete a row in an existing Excel document
Read Excel Range‌Get the value of the range from the Excel file
Write Excel RangeWrite specified values to a specified range in an Excel file
Read Excel RowGet a particular row value from the Excel file
Update Excel RowUpdates particular row values in the Excel file
Read Excel CellReads the value of a specified cell in an Excel document
Update Excel CellUpdates the content of specified cells in an Excel document
Execute macroExecute a .vbs macro in the selected Excel file
Insert/Delete ColumnsInsert or delete a column in an existing Excel document
Read columnRead data from a selected column in an Excel document and save it to a variable
Append columnInsert a column at the end of the selected Excel document
Update columnOverwrite data in a certain column of an Excel document
Sort rangeSort the range of data in the Excel file by column
Duplicate SheetCreate an exact copy of a worksheet in Excel
Remove SheetDelete a worksheet from the Excel workbook
Clear RangeRemove the contents from a specified range of cells
Rename SheetChange the name of a worksheet in Excel
Copy/Paste RangeDuplicate and transfer data between ranges in Excel
Format CellsAdjust the appearance and formatting of selected cells
Get Cell FormulaRetrieve the formula used in a specific cell
Locate CellFind the position of a particular cell within a worksheet
Remove Duplicate RowsDelete duplicate rows from a dataset in Excel
Autofill FormulaAutomatically extend a formula across a range of cells
Format Data Type CellsSet the data format for selected cells in Excel

MS Outlook

ActivityDefinition
Read emailsRead emails received in the Outlook mail service
Send emailSend an email using the Outlook mail service

Office 365

ActivityDefinition
Read emailsRead emails stored in your Microsoft account
Send emailSends an email using a Microsoft account


Did this page help you?