Accessing/editing cells or rows of workbooks within a .JNLP file

Help Test Cloud
,
1

I am trying to test the functionality of performing operations in cells present in a workbook based on test cases specified by customer.
The operation could include editing a cell or range of cells corresponding to a specific row or column.

The problem is with the format of the workbook. This workbook is present in an application that is accessed as a jnlp file. When I use click option to indicate element , the whole sheet gets selected as Target as shown in the attachment.

Unable to get cell level access to the workbook.

Please suggest.

whole sheet gets selected
whole sheet gets selected1503×461 75.1 KB

2

@Muralidharan_Revathi

Welcome to our UiPath community.

If possible can you please try with Computer Vision activities and check it once.

3

check if installing the java extension (also try different UiFrameworks) will have a different result and will get the selectors

4

What is the selector of that element, if you use the UiExplorer over it?

6 
fuzzy selector : "<java role='page tab list' /><java name='ABC Consensus Demand Planning ' role='page tab' /><java role='page tab list' /><java name='Consensus Demand Plan - Units Summary Weekly' role='page tab' /><java cls='JGrid' role='AWT component' />"

selector : "<java role='page tab list' /><java name='ABC Consensus Demand Planning ' role='page tab' /><java role='page tab list' /><java name='Consensus Demand Plan - Units Summary Weekly' role='page tab' /><java cls='JGrid' role='AWT component' />"

window selector : "<wnd app='jp2launcher.exe' cls='SunAwtFrame' title='ABC' />"
7

Then your problem is not an extension problem. The library used to build the app is a custom one, written on top of Swing. That JGrid element is the one with the problems.

Can you use the UiExplorer and indicate the element again?
Can the node from the UiExplorer tree be expanded? Does it have any children? (screenshot would help)
Also, is there any fullClassName property in the property explorer section of UiExplorer?

8

uiexplorer shot
uiexplorer shot1920×1080 125 KB

Is this the screenshot that you are looking for ? Please let me know if any further details are required.
fullclassname
fullclassname684×939 30.7 KB

9

Yes, the images are good.

That JGrid element is a custom element built on top of a standard JTabbedPane (most probably) from Swing. Somehow, it overrides the default behavior when reporting dimensions of itself and of its children.

I will send you a private message.

10

Can you please give some more details? I have a similar issue, UiExplorer says

image
image854×40 1.33 KB

11

HI @TP2B,

In your case, Studio uses AA framework with ctrl selectors to identify elements, not the Java extension. If switching the UI framework using F4 does not help identify the elements better, then CV is the only solution left.

12

Thanks for your support !