I am creating a robot to input Excel values into a web application.
As shown in the attached screen, the number of rows for the input cells changes depending on the year and the person.
Is there a specified method for this?
Hello
It depends on the structure in question, but for example, you can use the table extraction feature to obtain the entire table, and then identify the number of rows and their content before entering the necessary items.
If table extraction is not possible, you’ll likely need to analyze the structure of each element manually to determine things like the number of rows.
Thank you very much.
I don’t fully understand the process from extracting the table to input, but I will look into it and give it a try.
If table extraction works well, you can obtain the total number of rows and the location of each data entry from the retrieved DataTable.
Separately, using tools like UiExplorer, you can check what attributes can be specified for the selectors of each cell in the table. For example, if the tableRow attribute seems useful, you can compare its value with the row numbers of the DataTable and offset that amount when performing the actual input.