LinkBack URL
About LinkBacks
Question: Excel Auto HTML Render
I have a html/ajax script that pulls a search result from omdbapi.com. When I use script in internet Explorer it works fine but excel doesn't seem to have permission to pull a external request. Even if I try Data -> From Web (the browser shows the local version and not the correct version. Is there any way to make excel properly show/render the script?
HTML FILE:
<!doctype html>
<html ng-app>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.6/angular.min.js"></script>
<script>
function ActivitiesListCtrl($scope, $http) {
$http.get('http://www.omdbapi.com/?t=the%20shawshank%20redemption').success(function (data) {
$scope.mydata = data;
});
}
</script>
</head>
<body ng-controller="ActivitiesListCtrl">
<h1>Movie Name</h1>
{{mydata.Poster}}
</body>
</html>
This is how it should display in a real browser. badpvp.com/testing.html
I can not do this by hand because I have 3,000 omdbapi movies I need to pull the poster from. Posting html for each link in excel seemed to be a easy way to pull data.
-Thanks for reading.
Register To Reply
Bookmarks