This site requires JavaScript to be enabled
IE BUMPER

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

Using Tbox Excel Modules to read in and manipulate data

We will create a brief example test case to show how to use the new Tbox Excel Modules.


Situation

Being able to bring in excel contents to Tosca, and manupulate them like a table while using constraints, a new feature for Tosca 12.1!

 

Solution

We can buffer and use constraints on specific cells that contain header/column attributes, just like a regular Tbox table in Tosca.

In this example, we will guide you through using the new Tbox Excel Modules for Tosca Commander 12.1+.  The new modules will be used to refence your excel sheet exactly like a modern Tbox Table. Something previously not possible with older versions of Tosca.

 

1)  First we will need to create a new project and import the standard modules.  In here you'll notice the new Tbox Excel modules are located at Tbox Standard Modules -> Tbox XEngines -> Excel.

 

2)  Next, we will drag the Tbox Open Excel Workbook module to our test case.  In it, we will enter the location of our workbook in the path variable and the Workbook Name will become an instance of that open workbook for use in the following steps.

 

 

3)  Drag the Tbox Define Excel Range module into the test case.  The Workbook Name will be brought from step #2 above, the Worksheet Name is the name of worksheet in the excel file.   In our case, Sheet1.  The Range Name will be a variable used by Tosca Commander for future steps and is up to your discretion.   The Data Range is the cell range on the test sheet that we would like to read.  It uses the cell letter and number, in our case A1 to Z1000.  There is no real limit on size here but the larger the area the more processing and memory that will be required.

 

 

4)  Add to your Test case Tbox Excel Range Manipulation, we will use the range name setup in the previous step  - "R1".  Next, we can use the Data Table attribute to manipulate the excel data like any other table in Tosca.  In our case, we wish to find the name of a product, set it as a contraint, and then return it's value from the excel sheet into our buffer called "Test_ExcelBuffer".  

 

 

5)  Running our test steps we retrieve the correct value from the Excel File, and our buffer is now set to "Value3".

 


 

I hope you can see the potential power of this.  With the conversion to Tbox modules, we now have a control over Excel that was previously either very difficult and even impossible in certain circumstances.

 

[opt.] Reference

For more table steering ideas, please reference the subject of Table Steering from our support site.

2 0

Ragunath Govindaraju

Created: 2019-06-25 11:19:10

It was very useful !!

Thanks much

0 0

Tamir Maksudovski

Created: 2019-09-05 20:41:14

Hey Jason,

 

Where can I download these new modules and add to my project?

 

Thanks, 

Tamir

0 0

Paul Revilla

Created: 2019-09-06 03:44:09

Hello,

Can these new modules be downloaded? If so, can you please post the link.

This would make our automation more efficient.

Thanks

Paul

 

3 0

Philipp Dessovic

Created: 2019-09-10 22:14:05

These modules are part of the installation since Tosca 12.1. They are parts of the standard modules subset in "C:\Tosca_Projects\ToscaCommander\Standard.tsu" and are not working in older Tosca versions.

Nikita Illarionov

2019-12-11 12:48:14 , Updates: 2, Last Update: 2019-12-11 16:04:41

It does not come automatically, though.

0 0

Sourajeet Lahiri

Created: 2019-11-26 13:06:52

How to use the Buffer variable in our Test Step ?

0 0

sachin Pawar

Created: 2019-12-09 07:07:26

Thanks for sharing it.

0 0

Pradeep Chauhan

Created: 2020-03-21 16:44:46

Is this forum also for Tricentis RPA Studio ?

Somehow I am unable to open a simple excel workbook using the Open Excel Workbook module. The bot shows a passed result. I am really frustated by the limited functionalities in the tricentis rpa tool. Anywhere I google for solution I am getting solutions for UiPath. Any help or is this a wrong community?

Attachments
IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial