How to get coordinates of an element in the whole monitor screen - selenium VBA excel

Question

0.00/5 (No votes)

See more:

Excel-2016

Hello guys
I used this code in VBA Excel to find the top left node of the element in Selenium in VBA Excel:

VB

Debug.Print "Location of X,Y = " & driver.FindElementByCss("#logo > a > img").Location.X & " , " & driver.FindElementByCss("#logo > a > img").Location.Y

After run, it Shows me:

Location of X,Y = 1203 , 653

But when i take a screenshot from the page and open it in Photoshop, the location is different. I mean when I locate the top left ofthe picture of the element in Photoshop, I see the numbers of X and Y are totally different.
I should add that the resolution of my system is 1920x1080 and 72 dpi.

So it seems the numbers in the code are in another unit and are not in pixel. So how can I have the coordinates in pixel unit?

Any ideas?

What I have tried:

The above code is what I have tried.

Posted 11-Apr-23 22:43pm

Sh.H.

Updated 19-Apr-23 4:55am

v2

Add a Solution

Comments

Dave Kreskowiak 12-Apr-23 10:12am

I've never had the need to look at the coords of HTML elements, but I would expect the coordinates of the element will be relative to the top left corner of the page, not the screen. Is this what you're possibly seeing?

Sh.H. 12-Apr-23 16:46pm

Well you are right. But I need to compare it as a picture of screenshot in photoshop. html uses Point, and photoshop uses Pixel. So I need to know how can I convert point to pixel, so then I use it in the screenshot in photoshop.

Dave Kreskowiak 12-Apr-23 17:59pm

You don't. There is no conversion from pixels in the page to pixels in screen coordinates. The page can be many times longer than the screen, plus you have to take into account the browser window size, it's position, the page window and it's position, the non-client area of the browser, the menu size of the browser, and button and address bars. There is no easy conversion for this at all. Oh, and how far the page has been scrolled is going to screw all this up too.

Sh.H. 14-Apr-23 6:36am

So why the result is different from the result in Photoshop???

Dave Kreskowiak 14-Apr-23 8:53am

I already told you!

The coordinates you get from your code are the coordinates relative to the top left OF THE WEB PAGE, NOT THE SCREEN!

Sh.H. 14-Apr-23 13:39pm

NO! BUT ... even if it is, the numbers are not also the same with in Photoshop. I mean I checked as you said in Photoshop. I mean I took a picture and checked the distance of top left of element to top left of web page. It was not equal to above numbers yet!
It seems the numbers are in Point unit and not in Pixel unit. But I don't know how I should convert.

Dave Kreskowiak 14-Apr-23 14:23pm

There is no conversion from web page points to screen coordinates.

Sh.H. 14-Apr-23 16:36pm

So how can I understand the location of an element in the screen (or the web page as you said)? Any ideas?

Dave Kreskowiak 14-Apr-23 17:15pm

What do you mean by "understand" and what are you doing with the coordinates of a control and how does Photoshop fit into all this?

Nobody has any idea what you're doing, and what does Excel VBA have anything to do with this?

Sh.H. 15-Apr-23 2:35am

Ok let me explain better. The element in the page has a coordinate in the screen. I use Photoshop to check the X and Y of the top left of the element. Do not stuck on Photoshop, because you can do it with any painting software. What I meant by "understand" is that finding the exact location of the element. I tried to explain better. I need to findout the exact location of the element in my screen (or webpage). But the code I wrote above leaves me wrong numbers.

Dave Kreskowiak 15-Apr-23 9:59am

I still have no idea why you're even doing this.

Sh.H. 15-Apr-23 11:34am

The reason is to have a reference point. So from this reference, I can offset to the other elements by value.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-04-15T04:43:00

Solution 1

It turns out that you CAN get some of the data you need, like the nonviewport height of the browser window and it's position on screen. It helps to go back and re-read the documenation I haven't read in the last decade.

HTML

<html>
<head>
	<title>Screen Coord Test</title>
	<style>
	button {
		margin-left: 100;
	}
	</style>
</head>
<body>
<h1>Script Test</h1>

<button id="testId" type="button">Test Button</button>

<script type="text/javascript">
var element = document.getElementById('testId');
var position = element.getBoundingClientRect();
var buttonX = position.left;
var buttonY = position.top;

var windowX = window.screenX;
var windowY = window.screenY;
var nonViewportHeight = window.outerHeight - window.innerHeight;

console.log('Window coords: ', windowX,',', windowY);
console.log('NonViewport Height: ', nonViewportHeight);
console.log('Button CSS coords: ', buttonX,',', buttonY);
console.log('Button screen coords: ', (buttonX + windowX) ,',', (buttonY + windowY + nonViewportHeight));
</script>
</body>
</html>

Posted 15-Apr-23 4:43am

Dave Kreskowiak

Comments

Sh.H. 15-Apr-23 11:35am

Thanks.
But the problem is there yet!
Please kindly see the result in the picture I attached here.
https://i.postimg.cc/sxfLD5JS/ScnSht.jpg

Dave Kreskowiak 15-Apr-23 11:37am

You have a place to start. The rest of the research is up to you.

Sh.H. 15-Apr-23 12:03pm

Thanks but not yet a place to start! Because the numbers are different yet! I don't know the reason. But I really need to have equal numbers. :-(

Dave Kreskowiak 15-Apr-23 13:27pm

Neither do I and I'm not hear to do your research for you. You learn nothing that way.

Welcome to the other half of writing code! DOING RESEARCH AND EXPERIMENTATION.

Here's the starting point: https://developer.mozilla.org/en-US/docs/Web/API/Window

Sh.H. 16-Apr-23 1:07am

Look buddy! Please pay attension to the result. It says (108 , 137). BUT IT IS NOT! Kindly please check! You will see. :-(

Dave Kreskowiak 16-Apr-23 9:03am

Have a nice life!

Sh.H. 19-Apr-23 2:51am

After a lot of research and testing, I found out that we should not using innerHeight and outerHeight.
I mean we should do other ways to find out the height of upper bar of browser.
So how can we find out the height of upper bar of browser?

Dave Kreskowiak 19-Apr-23 8:18am

I hate repeating myself.

Here's the starting point: https://developer.mozilla.org/en-US/docs/Web/API/Window

Sh.H. 19-Apr-23 10:23am

Thanks Dave. I've read that URL. Nothing found there! Please do not mad at me!

Dave Kreskowiak 19-Apr-23 10:25am

Really? Did you bother clicking each of the properties of the window documentation? The information you seek is there.

Sh.H. 21-Apr-23 6:52am

Are we fighting? Or discussing about coding? :-)
Please kindly do not mad at me. I am not here to bothering you or myself.
I am honest. I really really didn't find anything there which helps this article.

Dave Kreskowiak 21-Apr-23 15:55pm

Yeah, we're fighting, because you're not listening. You want this hard answer to a very specific question and that answer doesn't exist.

I, and nobody else, is going to do your research for you. Doing research is time consuming, and part of your job.

You're not writing my code, so I'm not going to write yours.

Sh.H. 21-Apr-23 17:10pm

May peace be with you and me.
God bless you.

Maciej Los 19-Apr-23 10:55am

5ed!

Sh.H. 21-Apr-23 6:52am

What is that mean?

Maciej Los · Answer 2 · 2023-04-19T04:55:00

I have never used Selenium webdriver in Excel VBA, but i have found very interesting article: How to get X Y coordinates of element in Selenium WebDriver – Maisa Solutions Blog[^]

Quote:
Any web element has Its own position on page and generally it is measured In x and y pixels and known as x y coordinates of element. X pixels means horizontal position on page from left side and Y pixels means vertical position on page from top side. You can find x y coordinates of any element.

So, if you want to get coordinates of element to the left top-corner of screen, you need to use different method. For example:
Visual Basic Procedure to Get/Set Cursor Position - Microsoft Support[^]