This site requires JavaScript to be enabled
IE BUMPER

Product
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 find the number of rows and columns for the Excel Table

This article describes how to find the number of rows and columns for the Excel Table.


Situation

I want to find the number of rows and columns for the Excel Table.

Solution

Please refer the below screenshot to find the number of rows and columns for Excel Table.

Tosca 12.0 and below (Classic Excel Engine):

Here .rowcount will give the total number of rows in the table along with the Header of the table and .colcount will give the total number of columns in the table.

In the above case, we have 2 extra rows as below.

  1. Header of the Sheet.
  2. Header of the Table.

 

 

Tosca 12.1 (TBox Excel Engine 3.0 ):

 

You need to define excel range by using the TBox Define Excel Range module prior to have the row count or the column count.

As the names indicate RowCount will give you the total number of rows present on the Excel range that you are defining and the same with ColumnCount as well.

Reference

Classic Excel Engine:

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=11.3.0&url=classic_engines/excel/installation.htm

TBox Excel Engine: 

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=12.1.0&url=engines_3.0/excel/excel_engine.htm

0 0

Ryan Burlage

Created: 2019-10-15 22:20:44

For the TOSCA 12.1 (TBOX EXCEL ENGINE 3.0 ):

This example seems not right.
Since you are input the Start Cell and End Cell A2: D6, you are basically telling it what you already know.
CC = 4
RC = 5

The solution we are looking for is for it to count rows with data from a row perspective, as well as how many columns.  Because then we would want to compare those buffers with another excel file.

4 0

Ryan Burlage

Created: 2019-10-15 23:30:01 , Updates: 1, Last Update: 2019-10-15 23:45:55

I figured out what was missing from reading the following KB article.
https://support.tricentis.com/community/article.do?number=KB0014963

This is how I set it up on my machine with 12.3.  

Important Note:  I would not use a Large End Cell as this will increase run time.  What I have set took 4 minutes to run.
I disabled the Row count as I use a different module that runs much faster, and use this only for Column count.

0 0

Karthick Kutti Thirumoorthy

Created: 2020-01-09 12:53:30

Could you please elaborate what is happening at the line of column count.

#last..

and why we use contraint with !=