This site requires JavaScript to be enabled

IncidentLookup using list
How can we help?

Solution Suggestions

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

Performance improvement during template instantiation with XL data source

This article describes how to use an alternative Excel interface to improve the performance of template instantiation.


When you use template instantiation you can use either a TestSheet or an ExcelSheet as your data source.
If an ExcelSheet is used, Tosca will communicate via a special interface with the locally installed MS Excel instance to retrieve data.
This approach works very well but can get very slow when the test instances defined in your excel sheet span over a larger number of rows and columns.

As a matter of fact the retrieval of data via this interface can sometimes take several minutes for large sheets which is caused by the technical nature of the interface offered by MS Excel.


If performance becomes an issue during template instantiation there is now an option to switch to a different kind of excel interface.
To switch the interface you need to open the options dialog within Tosca (Project -> Options) and check the option "Use alternative MSExcel interface"." style="height:544px; margin-bottom:0px; margin-left:0px; margin-right:0px; margin-top:0px; width:840px" />

This alternative excel interface has two major advantages:

  • It doesn’t require an installed instance of MS Excel.
  • It is much faster than the other interface.

But it also comes with two drawbacks:

  • If your excel sheet contains HLOOKUP and VLOOKUP cells those values will not be supported.
    It is suggested that you copy/past your sheet and resolve those formulas so the cells just contain values.
  • This new interface only works for excel files in the OpenXML format (*.xlsx)