Hello Ankit,

Thank you for contacting Infragistics.

If you modify the worksheet so the data you want to display is in a named table, you will be able to access the indices of the first and last rows of the table and the first and last columns of the table.

For example, if you named your table "Table1", you would use a line of code similar to the following to get the index of the last row.

workbook1.Worksheets[0].Tables["Table1"].WholeTableRegion.LastRow;

The other three properties off the region are FirstRow, FirstColumn, and LastColumn.

Please let me know if you have any other questions about this.

Hello Ramrati,

Thank you for your response.

Unspecified Error could mean just about anything.  The first thing to do is to see if the error is caused by the AUT, by UFT, or by TestAdvantage.  First, perform the actions that caused the error manually without using UFT or TestAdvantage.  If the error does not occur, perform the actions through UFT without TestAdvantage enabled.  If the error still does not occur, the issue has something to do with TestAdvantage.  In that case, take a screenshot of the error and post it here if possible.

Hello Ramrati,

Thank you for your response.

As I mentioned in my previous response, you should verify the version of the .NET Framework you have installed and make sure you have Service Pack 3 for UFT 11.5 installed if you need it.  Also, the version of TestAdvantage you use must match the version of NetAdvantage your AUT uses.

Hello Ramrati,

Thank you for your response.

You should have installed the patch for UFT first, but I don't think it makes that much of a difference.  However, I do know that UFT 11.51 does not work correctly with .NET 4.5.  If you have .NET 4.5 installed, you will need to either downgrade to .NET 4.0 or install Service Pack 3 for UFT 11.5.

Hello Shirkaan,

I created CAS-86241-K7XT7G to assist you with this.

Hello Brian,

The ClickMenuTool function takes two parameters; this is why you are seeing the comma you highlighted in your last update.  The string delimited by the first set of quotes identifies the menu which contains the tool that you want clicked.  The second string identifies the tool itself.  In order for the ClickMenuTool function to work properly, you need to pass two strings to it.  What you've been trying to do is pass just one string to it.  Try passing two strings in the same way that it gets recorded and see if it works.

Hello Brian,

In order for me to really be able to help you with this, I would need a sample application and script which reproduces the issue.  Once you have everything in one ZIP file, you can attach it to a post by selecting the Options tab before submitting your post.