Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Tricentis Tosca: Working with Excel Engine

Name: Tricentis Tosca: Working with Excel Engine
Rating: 4.3 (6 reviews)

Begineer to Advanced Course

Created byPrachur Saxena

Last updated 2/2023

English

What you'll learn

You will -
- Learn about Tosca Excel Modules
- Learn about module attributes for each excel module.
- Understand the Tosca Excel Model
- Learn about usage of Tosca excel modules
- Understand some basic operations examples read,write,append,buffer etc..
- Practice with simple and advanced examples
- Understand Libraries,Reusable TestStep Blocks, While Loops,Repetition, & much more
- Be able to complete a project along the learning curve of the course.
- Understand how to Troubleshoot issues or common traps
- find some additional lessons in Bonus lectures and utilise same in your project completion

Course content

11 sections • 67 lectures • 3h 20m total length

Introduction to course4:29
Introduction to Instructor and Course Curriculum.

Post Installation Check for Files and Directories8:09
Learn to verify the Excel engine post installation in Tricentis Tosca, check license components, review prerequisites for Excel usage, and understand migration file checks and permissions.
Setting Up The Excel Engine7:44
Understanding Excel Object Model5:16
Explore the Excel object model and how Tosca commander navigates workbooks, charts, and worksheets through collection objects, and set the active workbook and sheet in a context sensitive environment.
Quiz For Section 2
Download Initial Subset0:06
Please download this initial subset with the help of which you can create your excel related test cases and can create the project in the end.
Guide For You: Shortcut for Creation Of Test cases folder structure0:07

Open Workbook Module5:55
What does Open WorkBook Module do? How to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Range Manipulation4:29
What does Range Manipulation Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Close Workbook1:26
What does Close Workbook Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Get Active Excel Application1:57
What does Get Active Excel Application Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Create Range3:31
What does Create Range Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Set Active Workbook2:09
What does Set Active WorkBook Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Set Header2:01
What does Set Header module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Set Active Range2:00
What does Set Active Range Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?
Set Active Worksheet2:30
What does Set Active Worksheet Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Download Resource For Simple Examples Part 10:05
Please download and save this file on your PC. And in your test case, please use the same path where this file resides.
Simple Examples Intro0:59
Learn to understand and build simple examples by following the shown structure, then work through each case to learn by doing, avoiding range-based examples.
Buffer A Cell Value4:14
Buffer a single cell value in Tosca’s Excel engine by reading from the existing workbook’s data sheet, then run the test to verify the value is buffered.
Buffer An Entire Row Content3:41
Buffer an Entire Column Content2:30
Buffer an entire column in Tricentis Tosca's Excel engine by marking the column, manipulating the range, and storing values by color, then close the workbook and verify the results.
Buffer number of rows in an excel sheet3:40
Buffer the number of rows in an excel sheet using the used range without specifying a range, and learn why four used rows may return five for test cases.
Buffer number of columns in an excel sheet1:59
Buffer the number of columns in an Excel sheet by using a buffer action without specifying a range, returning the column count from the worksheet.

Download Resource For Simple Examples Part 20:05
Please download and save this file on your PC. And in your test case, please use the same path where this file resides.
Buffer a Cell Value3:40
How to buffer a Excel cell value?
Buffer an Entire Row Content1:55
How to buffer entire Excel row?
Buffer an Entire Column Content2:01
How to buffer entire Excel column?
Buffer number of columns in an excel sheet2:06
How to get count of used excel columns?
Buffer number of rows in an excel sheet2:41
How to get count of used excel rows?
Guide For You: Creating Library of Reusable TestStep Blocks0:07
How to create resuable teststep block? and use it in your excel test cases.

Creating New Excel File3:48
How to create new excel file on local drive?
Write Column Names to New Excel5:47
How to write columns names or header to external Excel file?
Write to A Cell in New Excel1:50
How to write cell value to external Excel file?
Write values in A Row in New Excel3:34
How to write rows to external Excel file?
Changing Column Name in the Existing Excel2:33
How to write and change columns names to external Excel file containing header?
Rewriting Columns in Existing Excel4:51
How to write columns names to external Excel file and replacing existing ones?
Add New Sheet to Existing Excel And An Assignment\Self Assessment2:02
How to add new sheet to external Excel file?

Write Content to Specific Cell in Existing Excel2:31
How to write values to a specific cell of external Excel file?
Filling Row values Vertically in Existing Excel6:18
How to write values vertically or column-wise to the external Excel file?
2- Assignments\Self Assessments2:21
This is your first assignment.
Guide For You: CALC operations discussion0:07
CALC concept discussion with usage and implementation.
Download Resource For Calc Example0:03
Apply CALC on Row Value for Further Use3:53
Applying CALC on row values for further use .
Download Resource For XL Comparison Example0:02
Comparison of 2 Excel files4:15
How to compare the excel files?
Download Resource For common Trap0:01
Please download the file on your PC and refer the same file path in your test case.

Download the resources for the Project.0:07
Please download the files: an excel and a xml and save it on your PC. Later in your test case please refer the same path where the files are residing.
Understanding the Problem Statement3:12
The requirement or the problem statement discussion for the Project.
Business Logic1:53
Use this hint to get a roadmap for completion of your project test case.
Discussion 1- Creating Map5:03
Discussion 1- Getting Counts5:17
Guide For You: Splitting Values stored in the Buffer0:06
Discussion 2 - Repetition Level 16:13
Discussion 3 - While Loop Level 23:43
Discussion 4 - Repetition Level 35:08
Explore repetition level 3 in the excel engine by iterating the data sheet with a counter, deriving values, and mapping names to color buffers using a has structure.
Discussion 5 - Xml Verification5:54
Explore Xml verification in the Excel engine by validating row values against unique id and x-amount, building if-else logic, performing price, discount, tax calculations, rounding to two decimals.
Discussion 6 - Executing the project test case5:05

Introduction to Creation Of New Project2:48
Learn how to create a new Tosca project, navigate the project tab, configure repository and license settings, and start working in your workspace with available engines and databases.
Introduction To Sections In Tosca3:07
Navigate the test section to create test cases by dragging models into the test case initial structure, specify requirements, map issues, and review execution lists using the scrapbook.
Calc Operations\Calculations6:46
Master calc calculations in Tosca's Excel engine. Use left, right, and length operations with dynamic values to format numbers, text, and dates.
Shortcut for creating TestCase Folder Structure1:30
Creation of Libraries From Resuable TestStepBlock1:01
Learn to create libraries from reusable test step blocks in Tricentis Tosca’s Excel engine, using data blocks, drag-and-drop actions, and library reuse to achieve reusability across test cases.
Creation of Xml Module2:25
String Operation Module: Split Value stored in Buffer5:11
Learn to split comma-separated values stored in a buffer into two new buffers using a while loop and DS string operations with a regex pattern.

Requirements

1. You should have Tosca installed in your system.
2. You should have MS Excel installed.
3. You may have understanding on usage of Tosca Tool. Even if you don't, Don't Worry!!
4. Any knowledge in testing will help.

Description

*****************************

Course Overview:

----------------------------------

This course has been designed to help you gain practical in-depth knowledge on Excel Engine. This course consists of Theory, Practical Examples from simple to advanced, Assignments, Project and Bonus lectures. This course doesn’t talk’s about any UI automation instead it talks about excel automation.

This course consists of about 90% practical examples so that you learn while doing. In your Practical examples you will also utilize most discussed concepts like string operations, libraries, execution lists, buffers, repetition, loops, if-then-else etc and effectively use them in your test case.

So Let's begin the journey and unlock the knowledge on never discussed topic.

Course Curriculum is discussed below:
****************************************************************************************************
In section 2:
--------------
We will discuss some important qna around post installation activities and settings required for this engine. This will be covered in first 2 lessons. Then in lesson 3, we will discuss excel object model and how Tosca is using it? Once we complete this section and build our base with theory we move onto next section.

****************************************************************************************************
Section 3:
------------
In this section, We will go one by one, understanding each of the modules which are available as part of Excel Engine. We discuss their attributes and how we can use them in our test case.

****************************************************************************************************
Section 4 and 5:
-----------------
In these section, you will learn How to Create TC With\Without specifying the excel range.

****************************************************************************************************

Section 6 and 7:
----------------
In these section, you will go through advanced examples on the excel engine.

*****************************************************************************************************
In Section 8
------------
Here, we will go through some examples on troubleshooting issues or problems which you might be facing when working with excel modules related test cases.

****************************************************************************************************
In section 9:
-------------
Here, You will be part of and own the development of a mini Project in which you will solve a real
world problem. This problem statement occurs frequently in banking and finance industry. We will
first discuss the requirement and then you will build the solution around it.Don’t worry even
though if you couldn’t get to the correct solution I will be discussing the solution with you in
this section.

****************************************************************************************************
in Section 10- Additional Lectures:

You have some additional supportive lectures related to introduction to IDE, sections, creation of new projects,
CALC operations, string operations module,creation of xml module, etc that can aide in your learning path of this course.

****************************************************************************************************
Queries:

If you have any query related to course please post your questions in QnA section.

****************************************************************************************************

In this course curriculum, you have lot of practical examples to learn from and a real world problem to solve as your tiny project.
Last but not the least I believe you will enjoy the course.

Who this course is for:

Anyone can pursue this course.

Tricentis Tosca: Working with Excel Engine

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Introduction to Excel Engine5 lectures • 21min

Understanding Excel Modules9 lectures • 26min

Simple Examples - Part 17 lectures • 17min

Simple Examples - Part 27 lectures • 13min

Advanced Examples - Part 17 lectures • 24min

Advanced Examples- Part 29 lectures • 20min

Troubleshooting Issues \ Common Traps4 lectures • 11min

Project11 lectures • 42min

Additional Lectures7 lectures • 23min

Requirements

Description

Who this course is for: