This site requires JavaScript to be enabled


Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

How to verify or edit content in Excel sheets

This article contains a basic example of how data in Excel sheets can be verified or edited.


You would like to verify some data in your Excel sheet or modify the Excel sheet. This article will walk you through all the steps necessary to create an Excel file in a specified location, add some data, save it and then verify the data in it.


1) Import the standard Excel Modules

2) Make sure Microsoft® Excel 2003 or Microsoft® Excel 2007 is installed on your machine

3) Make sure the path "C:\Temp\" exists on your machine - create the "Temp" folder if it doesn't exist yet


1) To create the Excel sheet, the Module "Excel Open Workbook" is used:

The Workbook ID you specify in this TestStep allows Tosca to differentiate between different Excel sheets if multiple ones are opened during the execution. This ID can be chosen arbitrarily.

If you run this TestStep, a new Excel file called "Example.xlsx" will be created. Please note that this TestStep will load the Excel file programmatically, but no Excel GUI instance will be visibly opened. 


2) Now that the Excel file is loaded, the next step is to insert some data. This can be done using "Excel Range Manipulation":

The usual classic table steering is used to manipulate the Excel sheet.

If multiple workbooks are open, Tosca will modify the one that was last opened or the one that was last set as the active workbook using "Excel Set Active Workbook".


3) We would now like to verify the value we just inserted:


4) In order for th changes we just made to take effect, the Excel file must be saved. "Excel Close Workbook" is used:

Notice how the workbook ID specified in step 1) is used to tell Tosca which workbook to close.


If you execute the complete TestCase with those 4 TestSteps, a new Excel file will be created in "C:\Temp\" with the text "This is row 2, column 1." in it.

2 0

Prachur Saxena

Created: 2017-12-21 12:45:44

Hi Kirsten ,

Thanks for sharing the solution to reading excel. I need your help in finding this Excel Module which you have mentioned in your article as it is not available under Standard modules or exchange portal .

or Can you please share your subset in that case.


Kerstin Kohout

2017-12-27 09:19:25

Hi Prachur,
you can download a subset containing the Excel Modules here:

1 0

Prachur Saxena

Created: 2018-01-03 13:50:44

Hi Kerstin,

I visited your link and couldn't find the subset. I'm attaching the screenshot for your reference. I have no idea why I can't see the subset. If this item\subset link has some settings because of which I'm unable to view this , please make changes to it accordingly.


Prachur Saxena

0 0

jq NA

Created: 2018-01-16 15:48:22

There is no excel modules in link : help to check and update the link!!!

0 0

Michael Juada

Created: 2018-06-11 10:51:46

Hi Kerstin

I'm having an error while trying to run Excel open workbook File not Found ToscaSettings.Dll




0 0

Rupali shinde

Created: 2018-09-06 05:16:47

Hi Kerstin,

I am trying to buffer value from excel. to do this i am mentioning buffer name in value but i am getting error 'Cancelled by user'. Please let me know how to buffer values from excel.




0 0

Karlo Angelo Imbat

Created: 2019-03-06 09:10:20

How to remove entire row in an excel sheet?

0 0

Carlos Franco

Created: 2019-03-22 15:59:47

How can I add data in the first empty row?


0 0

Samuel Nittala

Created: 2019-07-09 06:59:01

Upvote : Awaiting someone to answer the questions above.

0 0

Bindu Sekhar

Created: 2019-07-12 13:14:07

how to add multiple rows in csv file

David Hämmerle

2019-07-15 15:31:49

Hello Bindu!

You could use a nested loop to enter data cell-by-cell. In that case I recommend using the TBox Excel Engine released with Tosca 12.2 as the performance is much better than the legacy Excel Engine:

Alternatively you could use the file system operations module from Aidpack with Operation = Append to add new data to an existing file.

Best regards,


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial