I am working with a big data base which has a lot of information about firms and businesses. I have successfully extracted the data required into an Excel spreedsheet and saved the data into a data table called dt.
I now want to go into a website and enter every single element of my dt into the search bar on the website.
For simplicity, you may assume my dt is a 3x3 excel spreedsheet. You may also assume, that I have made a process that goes into the correct website (url). You may also assume that I have reached the point where the search bar is and automated the clicking process. Finally, you may also assume the data table is the amount of cells (3x3).
The problem I am facing is converting the indexes of dt into a string. For example, when manually doing dt(1).ToString I would expect the process to write 123456789 into the search bar on the website, but it does not. In return, it writes system.data.datarow which is not my desired output I am looking for.
Below are some posts which are similiar to my problem, but does not fix my issue. I want my process to sucessfully go through all of the elements inside the data table dt, convert them to string and then write every single element into the searchbar on the website as a string allowing the website to successfully look up the companies.
I have also posted some snippets of my workflow for anyone curious.