This site requires JavaScript to be enabled
IE BUMPER

Logo

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
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
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).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
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.


Situation

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.

Prerequisites

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

Solution

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.

Thanks.

Kerstin Kohout

2017-12-27 09:19:25

Hi Prachur,
you can download a subset containing the Excel Modules here:
https://support.tricentis.com/community/downloads.do?number=DOW0005341

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.

Thanks,

Prachur Saxena

0 0

jq NA

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

There is no excel modules in link :https://support.tricentis.com/community/downloads.do?number=DOW0005341.Please 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.

 

Thanks,

Rupali

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?

 

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial