Get XPATH for selenium VBA

Question

I am struggling with a web page on a secure website. I will put a snapshot of what I am working on. The XPATH that has the rows of a table (equals to 13 rows) is that

//div[@id='Section3']

But the data is not inside that XPATH but after it in 9 columns.

How can I refer to those children or ancestors ( I don't know the exact term)?

Here's the HTML for that page ( I couldn't include it in the question)

https://pastebin.com/hEq8K75C

Here's the snapshot (may clarify the issue well)

How to implement the variable j in such lines?

Dim x As Long, i As Long, j As Long
x = .FindElementsByXPath("//div[@id='Section3']")
For i = 1 To x
    For j = 1 To 9
       Cells(i, j).Value = .FindElementByXPath("//div[@id='Section3']/following-sibling::div[following-sibling::div[@id='Section3'][count(preceding-sibling::div[@id='Section3'])=" & i & " and count(following-sibling::div[@id='Section3'])=" & x - (i + 1) & "]][" & j & "]").Text
    Next j
Next i

Answer 1

Try to use below code:

counter = len(driver.find_elements_by_id("Section3"))

xpath = "//div[@id='Section3']/following-sibling::div[count(preceding-sibling::div[@id='Section3'])={0} and count(following-sibling::div[@id='Section3'])={1}]"

for i in range(counter):
    print('\nRow #{} \n'.format(i + 1))
    _xpath = xpath.format(i + 1, counter - (i + 1))
    cells = driver.find_elements_by_xpath(_xpath)
    for cell in cells:
         value = cell.find_element_by_xpath(".//td").text
         print(value)