NewTube

NewTube

Sign In

-30  

-15  

-5  

-1  

+1  

+5  

+15  

+30  




Mathematical Software Inc

16

1

How to Copy Table Data from Difficult Web Pages

  - 18:47

Short video on how to copy table data from a difficult web page where normal table data selection in the web browser (Firefox in our example) fails. Shows how to export a PDF copy of the page using Microsoft Print to PDF in Firefox, how to extract the tables quickly from the PDF file into CSV or other disk files, how to quickly copy the CSV file data in the Windows clipboard using the Windows/DOS CLIP command, and finally how to paste the clipboard CSV data into the LibreOffice Calc spreadsheet. LibreOffice is a free open-source program largely compatible (a "clone") with MS Office. Calc is similar to MS Excel although there are some differences. Quick summary of Windows/DOS commands used: DOS> camelot -p all - f csv -o polling.csv stream "Polling Report March 27 2022 Table.pdf" DOS> clip < polling-page-1-table-1.csv DOS> clip < polling-page-2-table-1.csv DOS> clip < polling-page-3-table-1.csv Camelot PDF Table Extraction: https://camelot-py.readthedocs.io/en/master/index.html The difficult web page shown: https://www.pollingreport.com/biden_job.htm CORRECTION: I mispoke at about 15:00 minutes into the video, saying LEFT CLICK on the mouse when I meant RIGHT CLICK. Most popup menus in LibreOffice Calc are brought up by right clicking with the mouse or trackball as in other programs. There is a correction subtitle in the video as well. About Us: Main Web Site: https://mathematical-software.com/ Censored Search: https://censored-search.com/ A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests! Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/ Legal Disclaimers: http://wordpress.jmcgowan.com/wp/


0

0

0

0

0

Share on TwitterShare on Twitter


196 Views

Uploaded 2 years ago  

March 28th 2022  

File Size: 151 MB

Category: Technology & Science







No Comments Yet