Version 0.3.8

[AccRPA]

Hi!, thank you so much for this library, but the 0.3.8 version is not in maven repository. Please can you add this version to maven repository? With the version 0.3.7, this example doesn't work: AutomationDataGrid grid = window.getDataGrid(0); AutomationDataGridItem item = grid.getCell(0,0); String itemName = item.name();

This is because the AutomationDataGridItem class is not present in the 0.3.7 version.

Thank you.

[mmarquee]

Hi, the 0.3.8 version was deployed this afternoon (just after 12:00 GMT), I can see it is https://oss.sonatype.org/#nexus-search;quick~ui-automation, so maybe it is taking a while to work it's way through the system.  I'll investigate the other (AutomationDataGrid) issue

[AccRPA]

Hi, thank you. I would like to get cells from Excel file, and I think that lines of code can help me. I'll check the maven repository.

[AccRPA]

Hi! I would like to ask you if you have some examples with Excel, like select a sheet, select some cells. I'm trying to do that with your library, but I have some problems like this:

mmarquee.automation.ElementNotFoundException at mmarquee.automation.AutomationElement.findFirst(AutomationElement.java:265)

I think it's because I use Visual UI Automation to get the ID or name of the elements, but some elements (for example Pane element) don't have AutomationID or Name. In this case how can I get the sheet or cell?

Thank you! Regards.

[mmarquee]

I don't have any Excel examples yet. But it might what you say about names and its. I see whether I can get excel examples coded

[mmarquee]

OK, looks like excel cells have the same name as the cell coordinates. I'll try and get an example worked up in the next couple of days.

[mmarquee]

Do you still have your initial issues?

[AccRPA]

Well, I can't use AutomationDataGridItem until the new version is in the maven repository and I don't know how to get cells and select sheet. I'll appreciate the examples. Thank you.

[mmarquee]

Hi, I have written an example that access Excel - I've added it to the wiki. In doing this I corrected the documentation which was out of date - it should have said 'AutomationDataGridCell' rather than 'AutomationDataGridItem'. There were also issues with the way that data and values were being retrieved from the Grid in Excel. I've made new release 0.3.9, which should be available via oss.sonatype.net. Thanks for reporting this, and hopefully these fixes and examples will allow you to control Excel as you require. Thanks

[AccRPA]

Hi!, thank you so much for the new version and examples. Awesome, I can get the cells. I have another question: I want to select some cells, so my way is click on the first cell, press and hold SHIFT Key and then click on the destination cell, Is it possible to do this with your library? I'm reviewing the api and the examples.

Regards

[mmarquee]

It isn't possible to select the cells in the current code, but if the underlying cells implement the SelectItem pattern, then it should be possible. I am doing further work on the Excel examples (as they don't seem to work consistently with different versions of Excel), so will look at adding the selection mechanism for cells.

[mmarquee]

I've had a look at the patterns that the cells have, and it looks like they implement ISelectionItem, which as select and addtoselection - at least in Excel 2015, which I am using at the moment. I will look to implement these.