Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I suppose you know how to extract the data from the excel that you post in your code above.</p> <p>For the part of find the text box in the page using XPath, I think is more easy if you user CSS-Selectors instead of XPath because XPath its a little difficult for newbies in this fields and tends to change. </p> <p>If we take the text box that appears in the upper right corner of the page of StackOverflow that executes a search of example , the HTML code in the page its the following :</p> <pre><code>&lt;input class="textbox" type="text" value="" size="28" maxlength="240" tabindex="1" placeholder="search" name="q" autocomplete="off"&gt;&lt;/input&gt; </code></pre> <p>My suggestion is use the following code :</p> <pre><code>Cell cells = null; Cell idcell=null; if (checking.equalsIgnoreCase("xxxxxxxxxxxxx")) { System.out.println("Checking xxxxxxxxxxxx"); if (checking.equalsIgnoreCase("yyyyyyyyyyyy")){ for (int cols = 0; cols &lt; sheet.getColumns(); cols++) { cells = sheet.getCell(cols, rows); idcell = sheet.getCell(cols,rows); WebElement element_BuyCategory = driver.findElement( By.cssSelector( "#search div input.textbox "); /* Other way is find the element by its name, if its have a name */ WebElement element_BuyCategory_by_Name = driver.findElement( By.name("q"); element_BuyCategory.sendKeys(cells.getContents()); System.out.println("xpath ok"); } } </code></pre> <p>If for some case you want to use XPath the you need to substitute the line of find the element with the next line :</p> <pre><code>/* If it's the only text box with this class or it's the first, I repeat this is a example */ WebElement element_BuyCategory = driver.findElement By.xpath("//input[contains(@class,'textbox')")); </code></pre> <p>I hope that the examples explained above can help you.</p>
    singulars
    1. This table or related slice is empty.
    1. POSelenium-How to get data from excel sheet and write that to webpage?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USVictor Sigler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSelenium-How to get data from excel sheet and write that to webpage?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHi Vkt0r, Thanks for your response its really help full. but the point here is i want that loop statement to identify number of xpaths which is there in excel sheet and then i want the web browser to find the web element and then in the next line i should enter the values to that web element accordingly which is also present in the excel sheet. I know it would be little confusing please try if it is possible. i think nobody would have tried this way.. it reduces huge amount of coding.
      singulars
      1. PO
      1. USshadab Oz
    2. COI don't understand very well what do you want exactly. Look if you have trouble with the translation of XPath to CSS Selectors I recommend you a simple translator located in [link](https://github.com/santiycr/cssify), is really very useful
      singulars
      1. PO
      1. USVictor Sigler
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload