View original (French)

Copy the screen of a protected site

dadacourse Posted messages 143 Status Member -  
[Dal] Posted messages 6122 Registration date   Status Contributor Last intervention   -
Bonjour,
A question: a website prevents the selection of its pages on the screen (to then copy them to Excel). Is there a way to lift this restriction?
Thank you.

5 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,
    What do you use for copying?
    0
  2. dadacourse Posted messages 143 Status Member 3
     
    Hello,
    With Excel 2007 and IE11
    Have a nice day
    0
    1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
       
      Hello,
      Here, you provide me with the explorer and the software where you "paste" the screenshot.
      What did you use to obtain your screenshot: the Print Screen key, selection with the mouse, or ...?
      0
  3. dadacourse Posted messages 143 Status Member 3
     
    re...
    press ctrl a then ctrl c (automatically by excel macro)
    0
    1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
       
      Hello,
      Try using alt+print screen manually to see, it's an image not text
      Otherwise, it's not easy to program, look at this:
      https://www.youtube.com/watch?v=AgpJ-wLaQmw
      0
  4. [Dal] Posted messages 6122 Registration date   Status Contributor Last intervention   1 108
     
    Hello dadacourse,

    By doing some research, we can see that with an Excel macro, we can retrieve the HTML page corresponding to a URL and parse it. Check out what comes out of this:

    https://www.google.fr/search?q=VBA+get+URL

    Of course, this should not be used to bombard a site with requests, or to use content in an illegal or unauthorized manner, as with all scraping tools, by the way.

    Dal
    0
  6. dadacourse Posted messages 143 Status Member 3
     
    Thank you fb89400009, but a photo is not the solution. As for Dal, I am already retrieving the HTML page from a URL without problem, except that now I would like to do the same thing except that the site prohibits selection (ctrl+a). It is this blockage that I would like to "unlock".
    Every day I retrieve information from this site for personal use (a site that provides statistics on horse races) and I spend a lot of time there. Not so much the time spent, but the daily manual repetition that I would like to avoid.
    Just unlock the prohibition on copying the screen.
    Have a good end of the day.
    0
    1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
       
      Re,
      Give the link to the site!

      It's this blockage that I would like to "unlock".
      Normally, it's not possible.....
      0
    2. [Dal] Posted messages 6122 Registration date   Status Contributor Last intervention   1 108
       
      It is really stupid to block a basic feature of a browser like copy-paste, knowing that simply visiting a webpage already stores all the page's content on the disk and that everything is already sent by the server.

      If you access the HTML, you have all the content, and you can process it without needing to do any copy-pasting.

      If you want to be able to select and copy-paste, you will need to modify the DOM on-the-fly. You can do this with the "developer" features of Firefox or Chrome.

      Once you know how to do it, you can, with Firefox and Grease Monkey https://addons.mozilla.org/en-US/firefox/addon/greasemonkey/ ensure that your changes are applied to each visit of this URL.

      You have to get your hands dirty, but it is not impossible :-)

      This will only modify your private way of viewing this page on your browser for your purposes of interoperability.
      0