Excel
Bot Studio excel automation reference
bold cells
The bold cells block applies bold formatting to specified cells.
border cells
The border cells block adds borders to specified cells.
clear cells
The clear cells block clears values from specified cells.
close excel
The close excel block closes an open Excel workbook instance.
color cells
The color cells block applies background color to specified cells.
create sheet
The create sheet block adds a new worksheet to a workbook.
delete column
The delete column block removes a column from the worksheet.
delete row
The delete row block removes rows by cell reference or filter criteria.
delete sheet
The delete sheet block removes a worksheet from the workbook.
duplicate sheet
The duplicate sheet block copies a worksheet to the same or another workbook.
excel filter
The excel filter block filters rows based on column conditions.
find and replace
The find and replace block finds values across the sheet and replaces them.
find cell
The find cell block locates a value in the spreadsheet.
find maximum row or column
The find maximum row or column block returns the last used row or column index.
get sheets
The get sheets block lists worksheet names in a workbook.
hide column
The hide column block hides specified columns.
hide row
The hide row block hides specified rows.
hide sheet
The hide sheet block hides a worksheet tab.
insert column
The insert column block inserts new columns at a position.
insert row
The insert row block inserts new rows at a position.
read cells
The read cells block reads values from specified cells.
read formula
The read formula block reads formulas from specified cells.
refresh pivot
The refresh pivot block refreshes pivot tables on a worksheet.
rename sheet
The rename sheet block renames a worksheet.
show column
The show column block unhides hidden columns.
show row
The show row block unhides hidden rows.
show sheet
The show sheet block unhides a hidden worksheet.
write cells
The write cells block writes values to specified cells.
write formula
The write formula block writes an Excel formula to a cell.
csv to excel
The csv to excel block converts a CSV file to an Excel workbook.