Jandrade2k Posted November 3, 2020 Report Share Posted November 3, 2020 Hi my name is John, and i'm working in a project where i need to get data from a table inside a website., can someone help me? Quote Link to comment Share on other sites More sharing options...
Cory Posted November 3, 2020 Report Share Posted November 3, 2020 You can copy the text to your clipboard and process it. Normally a table will come in with tabs between cells that you can parse. Though my prefered way it so use the GET command and process the data out of the HTML. Quote Link to comment Share on other sites More sharing options...
terrypin Posted November 4, 2020 Report Share Posted November 4, 2020 You might get more specific help if you tell us the site link and show us the table, plus the macro you have attempted so far. Meanwhile, following Cory’s suggestion, if you have now managed to select the entire table (of text?) and copy it to the clipboard, I’d suggest next using Variable Set String > Set Value from Clipboard Quote Link to comment Share on other sites More sharing options...
Cory Posted November 4, 2020 Report Share Posted November 4, 2020 Another thing: HTML is more complicated, but sometimes there are labels for elements that make it super simple to find what you want. Also if the web page is secure, you might not be able to do it with the GET method. Quote Link to comment Share on other sites More sharing options...
Cory Posted November 4, 2020 Report Share Posted November 4, 2020 Oh! also you can link actively to a web page in Excel. If you're planning on going to Excel with this data, this is the better option. Go to the Data section of the ribbon bar, then "from web" and follow the wizard. Quote Link to comment Share on other sites More sharing options...
Jandrade2k Posted November 4, 2020 Author Report Share Posted November 4, 2020 2 hours ago, terrypin said: You might get more specific help if you tell us the site link and show us the table, plus the macro you have attempted so far. Meanwhile, following Cory’s suggestion, if you have now managed to select the entire table (of text?) and copy it to the clipboard, I’d suggest next using Variable Set String > Set Value from Clipboard Hi terrypin, I can't show the table because it is inside Facebook ads, but it is not selectable. Quote Link to comment Share on other sites More sharing options...
acantor Posted November 5, 2020 Report Share Posted November 5, 2020 If the "HTTP Get" command doesn't work, you should be able to access some or all of a page's code via your browser. In most browsers, Ctrl + U shows the code for the page. So your script might look like this: Text Type (Simulate Keystrokes): <CONTROL>u Text Type (Simulate Keystrokes): <CONTROL>a // Select all Text Type (Simulate Keystrokes): <CONTROL>c // Copy to clipboard Variable Set String %PageCode% from the clipboard contents If Variable %PageCode% Contains "<table>" // (Rules for extracting table information) End If Quote Link to comment Share on other sites More sharing options...
Cory Posted November 5, 2020 Report Share Posted November 5, 2020 A good idea. You can also use the special "view-source" protocol in the URI. EG: https://en.wikipedia.org/wiki/Mayday is view-source:https://en.wikipedia.org/wiki/Mayday. I don't know if all browsers support it, but I know Chrome, Edge, and FireFox do. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.