Hello,
I have a problem getting data from company web page that requires login. Data is in the form of the table. I would like to Get the data and to be able to refresh the Excel table data with "Refresh all" when I need it.
The main hyperlink is in this form:
When I click on it the link changes as follows and I am presented with login page:
When I successfully login link changes and that is the page where table is located:
(llast part is session number which changes with every login. Session lasts 30 min)
1. If I use Get Data - From other sources - From Web
enter hyperlink https://linktowebpage:8443/ords/f?p=101:1248
I am able only to reach login page. How to tell Excel to use credentials to login to page?
2. If I use Get Data - Legacy wizzard - From Web (Legacy)
enter hyperlink https://linktowebpage:8443/ords/f?p=101:1248
I manually enter password on Web wizzard
I am able to reach the table and import it in Excel.
Problem is that full link is saved in Excel connection including session part of the link. As session lasts only 30min, after that new login is required and session number changes.
Here, again, I don't know how to input username and password into Excel to login automatically and not be bound with fixed session number.
Does anyone have some advice?
I have a problem getting data from company web page that requires login. Data is in the form of the table. I would like to Get the data and to be able to refresh the Excel table data with "Refresh all" when I need it.
The main hyperlink is in this form:
When I click on it the link changes as follows and I am presented with login page:
When I successfully login link changes and that is the page where table is located:
(llast part is session number which changes with every login. Session lasts 30 min)
1. If I use Get Data - From other sources - From Web
enter hyperlink https://linktowebpage:8443/ords/f?p=101:1248
I am able only to reach login page. How to tell Excel to use credentials to login to page?
2. If I use Get Data - Legacy wizzard - From Web (Legacy)
enter hyperlink https://linktowebpage:8443/ords/f?p=101:1248
I manually enter password on Web wizzard
I am able to reach the table and import it in Excel.
Problem is that full link is saved in Excel connection including session part of the link. As session lasts only 30min, after that new login is required and session number changes.
Here, again, I don't know how to input username and password into Excel to login automatically and not be bound with fixed session number.
Does anyone have some advice?