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 get the row number of a cell from excel sheet

I have a report in excel sheet. I have searched for a particular ID with the help of Excel Range Manipulation module by giving condition in Row value.
Now I want to get that particular row number from excel sheet , so that I can verify my result in the row above and below that particular row.

Attachments
0 0

Pugazhvanan Ganapathy

Created: 2017-05-23 23:31:18

Hi Teharim,

I would use looping statement and navigate to the cells one by one on the column 'CID' and verify which cell is having ID 102567 and buffer the row and column when it found.

Give it a try!

Thanks,

Pugal

0 0

Teharim Shaikh

Created: 2017-05-24 07:40:43

Thanks Phugazhvanan .

I will give a try for the above method.

Actually the report which I posted is just a sample report. My original report is very huge.

Is this the only way we can get the row number?

Do we have anything from Excel Engine which can get the row number.

0 0

Pugazhvanan Ganapathy

Created: 2017-05-24 19:48:52 , Updates: 3, Last Update: 2017-05-25 16:03:08

I read the documentation, but I cannot find one. Can you please check with the support?

If there is not anything existing available then you may need to create a keyword or a custom control for this item. If you created one, please don't forget to share here:)

Thanks,

Pugal

0 0

David Klien

Created: 2017-05-26 21:05:50

As discussed in the support incidents:

when buffering a cell, the LastOperatedTableRow buffer will get updated with the current row number. This buffer can then be used in other TestSteps. 

Kind regards,

David

0 0

Pugazhvanan Ganapathy

Created: 2017-05-31 23:37:42

https://support.tricentis.com/community/article.do?number=KB0010789 This article does not help with excel or csv files. David, Can you provide the solution tce file if this works for you?

1 0

Pugazhvanan Ganapathy

Created: 2017-06-01 21:44:08 , Updates: 2, Last Update: 2017-06-01 21:46:52

I wish this could help someone else also on this forum.

I have created a Keyword to do what you are trying to do, but for a csv format. I will attach the tce file so you can modify as per your requirements.

Short Description:

This keyword/module will search the csv file and find the row number of the first occurance of the value through buffer.

 

 

 

Limitations:

1. If you have the value appearing in multiple rows it won't show that has multiple occurance. You may need to modify the scripting in keyworked which is embedded to the module.

2. You can use only csv files. If you want to use it with excel you can first convert your excel to csv and use it without changes. If you are interested you can modify the code to read excel files.

Thank you,

Pugal

https://www.linkedin.com/groups/12044793

 

Attachments
0 0

Venkatesh Gopal

Created: 2018-12-05 10:24:22

Hello!!

How to pass buffer value in "SearchString" module ? It accepts only String value..

0 0

Venkatesh Gopal

Created: 2018-12-05 10:24:23

Hello!!

How to pass buffer value in "SearchString" module ? It accepts only String value..

0 0

Venkatesh Gopal

Created: 2018-12-05 10:24:27

Hello!!

How to pass buffer value in "SearchString" module ? It accepts only String value..

0 0

Karlo Angelo Imbat

Created: 2019-03-06 09:11:39

How to remove entire row in an excel sheet?

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial