RPA.Excel.Files library keywords

Append Rows To Worksheet

Append values to the end of the worksheet.

Arguments

Argument	Default value	Description
content		Rows of values to append
name	None	Name of worksheet to append to
header	False	Set rows according to existing header row
start	None	Start 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
path		None	Default save path for workbook
fmt		xlsx	Format 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	Default value	Description
name		Name of new worksheet
content	None	Optional content for worksheet
exist_ok	False	If False, raise an error if name is already in use
header	False	If 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
name		None	Name 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	Default value	Description
row		Index of row to write
column		Name or index of column
path
scale	1.0	Scale of image
name	None	Name 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
path			path to Excel file

param path:	path to Excel file

Read Worksheet

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

Arguments

Argument	Default value	Description
name	None	Name of worksheet to read
header	False	If True, use the first row of the worksheet as headers for the rest of the rows.
start	None

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	Default value	Description
name	None	Name of worksheet to read
header	False	If True, use the first row of the worksheet as headers for the rest of the rows.
trim	True	Remove all empty rows from the end of the worksheet
start	None	Row 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
name		None	Name 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_name			Current name of worksheet
dst_name			Future 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
path		None	Path 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
value			Index or name of worksheet

param value:	Index or name of worksheet

Set Worksheet Value

Set a cell value in the given worksheet.

Arguments

Argument	Default value	Description
row		Index of row to write, e.g. 3
column		Name or index of column, e.g. C or 7
value		New value of cell
name	None	Name 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