Append Rows To Worksheet

Append values to the end of the worksheet.

Arguments

Argument Type Default value Description
contentRows of values to append
nameNoneName of worksheet to append to
headerFalseSet rows according to existing header row
startNoneStart of data, NOTE: Only required when headers is True
param content:Rows of values to append
param name:Name of worksheet to append to
param header:Set rows according to existing header row
param start:Start of data, NOTE: Only required when headers is True

Close Workbook

Close the active workbook.

Create Workbook

Create and open a new Excel workbook.

Arguments

Argument Type Default value Description
pathNoneDefault save path for workbook
fmtxlsxFormat of workbook, i.e. xlsx or xls
param path:Default save path for workbook
param fmt:Format of workbook, i.e. xlsx or xls

Create Worksheet

Create a new worksheet in the current workbook.

Arguments

Argument Type Default value Description
nameName of new worksheet
contentNoneOptional content for worksheet
exist_okFalseIf False, raise an error if name is already in use
headerFalseIf content is provided, write headers to worksheet
param name:Name of new worksheet
param content:Optional content for worksheet
param exist_ok:If False, raise an error if name is already in use
param header:If content is provided, write headers to worksheet

Find Empty Row

Find the first empty row after existing content.

Arguments

Argument Type Default value Description
nameNoneName of worksheet
param name:Name of worksheet

Get Active Worksheet

Get the name of the worksheet which is currently active.

Insert Image To Worksheet

Insert an image into the given cell.

Arguments

Argument Type Default value Description
rowIndex of row to write
columnName or index of column
path
scale1.0Scale of image
nameNoneName of worksheet
param row:Index of row to write
param column:Name or index of column
param image:Path to image file
param scale:Scale of image
param name:Name of worksheet

List Worksheets

List all names of worksheets in the given workbook.

Open Workbook

Open an existing Excel workbook.

Arguments

Argument Type Default value Description
pathpath to Excel file
param path:path to Excel file

Read Worksheet

Read the content of a worksheet into a list of dictionaries.

Arguments

Argument Type Default value Description
nameNoneName of worksheet to read
headerFalseIf True, use the first row of the worksheet as headers for the rest of the rows.
startNone

Each key in the dictionary will be either values from the header row, or Excel-style column letters.

param name:Name of worksheet to read
param header:If True, use the first row of the worksheet as headers for the rest of the rows.

Read Worksheet As Table

Read the content of a worksheet into a Table container. Allows sorting/filtering/manipulating using the RPA.Tables library.

Arguments

Argument Type Default value Description
nameNoneName of worksheet to read
headerFalseIf True, use the first row of the worksheet as headers for the rest of the rows.
trimTrueRemove all empty rows from the end of the worksheet
startNoneRow index to start reading data from (1-indexed)

Read the content of a worksheet into a Table container. Allows sorting/filtering/manipulating using the RPA.Tables library.

param name:Name of worksheet to read
param header:If True, use the first row of the worksheet as headers for the rest of the rows.
param trim:Remove all empty rows from the end of the worksheet
param start:Row index to start reading data from (1-indexed)

Remove Worksheet

Remove a worksheet from the active workbook.

Arguments

Argument Type Default value Description
nameNoneName of worksheet to remove
param name:Name of worksheet to remove

Rename Worksheet

Rename an existing worksheet in the active workbook.

Arguments

Argument Type Default value Description
src_nameCurrent name of worksheet
dst_nameFuture name of worksheet
param src_name:Current name of worksheet
param dst_name:Future name of worksheet

Save Workbook

Save the active workbook.

Arguments

Argument Type Default value Description
pathNonePath to save to. If not given, uses path given when opened or created.
param path:Path to save to. If not given, uses path given when opened or created.

Set Active Worksheet

Set the active worksheet.

Arguments

Argument Type Default value Description
valueIndex or name of worksheet
param value:Index or name of worksheet

Set Worksheet Value

Set a cell value in the given worksheet.

Arguments

Argument Type Default value Description
rowIndex of row to write, e.g. 3
columnName or index of column, e.g. C or 7
valueNew value of cell
nameNoneName of worksheet
param row:Index of row to write, e.g. 3
param column:Name or index of column, e.g. C or 7
param value:New value of cell
param name:Name of worksheet

Worksheet Exists

Return True if worksheet with given name is in workbook.

Arguments

Argument Type Default value Description
name