How do i import Excel data from password protected site
Hey Guys,
I have installed Microsoft Office 2007 on my system. I'm having an Excel 2007 spread sheet and i would like to import some financial data from various web sites. The problem is that when i try to import data it show me an error that the data cannot be transferred, its data had been given password protection. So i would like to know is there any way by which i can import my Excel data from a password protected site? Does any one have any idea that how can i do so? Any information on this would be appreciated.
Thanks in advance.
Re: How do i import Excel data from password protected site
Access To Protected Documents:-
Documents protected by basic authorization can easily be accessed like this:
Quote:
use LWP::UserAgent;
$ua = LWP::UserAgent->new;
$req = HTTP::Request->new(GET => 'http://websit name/secret/');
$req->authorization_basic('aas', 'mypassword');
print $ua->request($req)->as_string;
Hope so it may help you out.:thumbup1:
Re: How do i import Excel data from password protected site
If you have data on the web you wish to use, Dabble DB can import it for you. Click the Import data from a website button and then type or paste the URL of the web page in.
Dabble can read tables on web pages written in HTML or XHTML. It can also read “plain” tab- or comma-delimited text files served on the web. Finally, you can also directly import RSS and Atom feeds.
Once you’ve pasted data or typed a web page URL, click Continue.
Note: You can tell Dabble DB to import from password-protected URLs by including the username and password in the URL. However, any punctuation or special characters in the username or password must be URL-encoded. Read more about importing data from password-protected web sites.
Re: How do i import Excel data from password protected site
I'am aware of the age of this topic, but I have the same question.
I'm am trying to retrieve data from http://fantasy.premierleague.com with Microsoft Excel (I am using the "from Web" query).
However, with the solution presented by Milton J. I was unable to get where I wanted.
Could you help me?
Thanks in advance.