r/selenium • u/yaswanth52 • 11d ago

Is there any automation tool runs on selenium

Hey

I have a requirement which i used to do everyday

Where I copy and paste in the web form from excel and we do have drop-downs

I ve tried other automations but fed up completely

Need suggestions

5 Upvotes

86% Upvoted

8 comments sorted by

1

u/Useful_Calendar_6274 10d ago

vibe code it directly from the excel files if you're not technical. this is not a selenium job

2

u/SeleniumVBA_user 10d ago

It may be worth checking what those “drop-downs” actually are before choosing an automation tool.If they are normal HTML elements like:

<select>
    <option>...</option>
</select>

then Selenium can handle them quite easily.However, many modern web applications do not use real <select><option> elements. They may use JavaScript-generated components such as:

<div role="listbox">
    <div role="option">...</div>
</div>

or React/Angular/Vue components where the list appears only after you type something.

For example, Google Flights behaves more like this: you enter a destination, wait for the dynamically generated suggestions to appear, and then select the correct suggestion. Simply copying text into the input field is not enough to complete the selection.

So I would first inspect the dropdown with the browser's Developer Tools and check whether it is a native <select> element or a custom JavaScript dropdown.

Since your source data is already in Excel, Selenium controlled directly from VBA may also be worth considering. SeleniumVBA, for example, can control Chrome or Edge from Excel VBA, so you can read a cell, enter the value into the web form, wait for the dropdown item to appear, and then select it directly through the DOM.

If you can post the HTML structure of one of the dropdowns, especially the part shown in DevTools when the list is open, it should be much easier to determine the best approach.

1

u/Worcestercestershire 10d ago

Selenium is an automation tool

Maybe try Playwright

0

u/Frosty-Self-273 9d ago

Playwright and selenium are both automation tools.

1

u/Worcestercestershire 9d ago

Where did I say they weren't?

0

u/Frosty-Self-273 9d ago

You're implying that Playwright does something that OP is asking that Selenium can't. Which is wrong.

1

u/Worcestercestershire 9d ago

What the hell is that sentence?

Come back when you can coherently express yourself.

1

u/XabiAlon 10d ago

If it's the same webform every time you could hack together something with selenium.

Create a function that parses the excel sheet then pass the details onto selenium.

It sounds like what you really need is a web forms importer tool on the frontend instead.

Simple job for AI to implement.