RPA.Excel.Application library keywords

Add New Sheet

Add new worksheet to workbook. Workbook is created by default if it does not exist.

Arguments

Argument	Type	Default value
sheetname	str	null
tabname	str, None	None
create_workbook	bool	True

Add new worksheet to workbook. Workbook is created by default if it does not exist.

param sheetname:
	name for sheet
param tabname:	name for tab (deprecated)
param create_workbook:
	create workbook if True, defaults to True
raises ValueError:
	error is raised if workbook does not exist and create_workbook is False

Add New Workbook

Adds new workbook for Excel application

Close Document

Close the active document (if open).

Arguments

Argument	Type	Default value	Description
save_changes	bool	False

Export As Pdf

Export Excel as PDF file

Arguments

Argument	Type	Default value	Description
pdf_filename	str	null
excel_filename	str, None	None

If Excel filename is not given, the currently open workbook will be exported as PDF.

param pdf_filename:
	PDF filename to save
param excel_filename:
	Excel filename to open

Find First Available Cell

Find first available free cell

Arguments

Argument	Type	Default value
worksheet	Any, None	None
row	int	1
column	int	1

param worksheet:
	worksheet to handle, defaults to active worksheet if None
param row:	starting row for search, defaults to 1
param column:	starting column for search, defaults to 1
return:	tuple (row, column) or (None, None) if not found

Find First Available Row

Find first available free row

Arguments

Argument	Type	Default value
worksheet	Any, None	None
row	int	1
column	int	1

param worksheet:
	worksheet to handle, defaults to active worksheet if None
param row:	starting row for search, defaults to 1
param column:	starting column for search, defaults to 1
return:	row or None

Open Application

Open the Excel application.

Arguments

Argument	Type	Default value	Description
visible	bool	False
display_alerts	bool	False

param display_alerts:
param visible:	show window after opening
	show alert popups

Open Workbook

Open Excel by filename

Arguments

Argument	Type	Default value	Description
filename	str	null

By default sets active worksheet to sheet number 1

param filename:	path to filename

Quit Application

Quit the application.

Arguments

Argument	Type	Default value	Description
save_changes	bool	False

Read From Cells

Read value from cell.

Arguments

Argument	Type	Default value
worksheet	Any, None	None
row	int, None	None
column	int, None	None

param worksheet:
	worksheet to handle, defaults to active worksheet if None
param row:	target row, defaults to None
param column:	target row, defaults to None
raises ValueError:
	if cell is not given

Run Macro

Run Excel macro with given name

Arguments

Argument	Type	Default value	Description
macro_name	str	null
args	Any	null

param macro_name:
	macro to run
param *args:	System Message: WARNING/2 (`<string>`, line 4); backlink Inline emphasis start-string without end-string. arguments to pass to macro

Save Excel

Saves Excel file

Save Excel As

Save Excel with name if workbook is open

Arguments

Argument	Type	Default value
filename	str	null
autofit	bool	False
file_format		None

param file_format:
param filename:	where to save file
param autofit:	autofit cell widths if True, defaults to False
	format of file

Note: Changing the file extension for the path does not affect the actual format. To use an older format, use the file_format argument with one of the following values:

https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat

Examples:

*** Tasks ***
# Save workbook in modern format
Save excel as    orders.xlsx

# Save workbook in Excel 97 format (format from above URL)
Save excel as    legacy.xls   file_format=${56}

Set Active Worksheet

Set active worksheet by either its sheet number or name

Arguments

Argument	Type	Default value	Description
sheetname	str, None	None
sheetnumber	int, None	None

param sheetname:
	name of Excel sheet, defaults to None
param sheetnumber:
	index of Excel sheet, defaults to None

Write To Cells

Write value, number_format and/or formula into cell.

Arguments

Argument	Type	Default value
worksheet	Any, None	None
row	int, None	None
column	int, None	None
value	str, None	None
number_format	str, None	None
formula	str, None	None

param worksheet:
	worksheet to handle, defaults to active worksheet if None
param row:	target row, defaults to None
param column:	target row, defaults to None
param value:	possible value to set, defaults to None
param number_format:
	possible number format to set, defaults to None
param formula:	possible format to set, defaults to None
raises ValueError:
	if cell is not given