Is there a way to get and display external data in to calc from a website that requires a login before it displays the info I want in a cell?
Is it a HTML website, or it uses another technologies?
The data I want is in tables. Gm$ 2530 and the Em$ balance is what I want calc to collect and display.
<table class="table wallet-spent-table">
<tbody>
<tr>
<th>Current balance</th>
<th>Total spent</th>
</tr>
<tr>
<td>Em$ 0.00</td>
<td>Em$ 12256.00</td>
</tr>
<tr>
<td>Gm$ 2530.00</td>
<td>Gm$ 93782.00</td>
</tr>
</tbody>
</table>
Screenshot of the table on the website after logging in to my account. The information I want calc to collect, use, and display is in the green boxes, I don’t need the info in the red box:
The issue is that data, that table, requires logging in to an account on the site the view it. Without logging in to an account the data I want calc to collect and use is not displayed.
How do we get calc to login to an account on a website?
Try to use some similar username+password combo in the URL:
“http://username:password@example.com”
1 Like
How would I use that with Calc?
The site is SSL (secure, it’s https). That didn’t do anything when I pressed enter in the Link to External Data dialogue.
From the menu:
Sheet - Link to external data - fill-in the url field (inside the user+pw), then hit Enter. Choose the proper table and the refresh time, OK.
Sorry, I can not help you without the specific URL and the password.
I sent you a private message with that information; the URL and a login for it.
It seems the URL what you sent me, not to be a simple HTML webpage…
What is the specific URL of the HTML table?
Click on the gm$ link at the top of the page after you login. That’s where the table I shared the (front-end) code and screenshot for is.
Or add #wallet/gms to the end of the URL in the address bar after you login.
I tried it: I can not find any way to sign-in and get the HTML table in one step (by only one URL+username+password combo) on the specific webpage.
Most sites don’t use HTTP basic authentication, so that won’t lead anywhere. If you have to enter your credentials in some fancy form there’s no way Calc can do that automatically, unless you create a program extension that scrapes the form and submits values and keeps cookies and what not.
To my knowledge passwords are an SQL database. There’s an HTTPS dialog credentials are entered in to. At least the front end looks like and it’s source is HTTPS. Of course there are cookies involved. Thanks, I didn’t think of that, and didn’t think it mattered I was thinking users can manually login when they open the document and want to use those features of it. The owners of the site I want to collect the data from are aware and don’t mind me doing this, they’re looking in to a way to provide something so calc/excel/things like this can get access to collect.