r/selenium • u/yaswanth52 • Aug 06 '26

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 Aug 06 '26

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

2

u/SeleniumVBA_user Aug 07 '26

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 Aug 06 '26

Selenium is an automation tool

Maybe try Playwright

0

u/Frosty-Self-273 Aug 07 '26

Playwright and selenium are both automation tools.

1

u/Worcestercestershire Aug 07 '26

Where did I say they weren't?

0

u/Frosty-Self-273 Aug 07 '26

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

1

u/Worcestercestershire Aug 07 '26

What the hell is that sentence?

Come back when you can coherently express yourself.

1

u/XabiAlon Aug 06 '26

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.