Python Forum
Web scraping with list from Excel - HELP
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Web scraping with list from Excel - HELP
#1
Hi everybody,

I need to use Python to do a task for my boss. Only one problem; I have never used Python before! So I desperatly need your help.

Problem:
I have a list of numbers in Excel (1*N list with colum name "IMO" and N numbers (like 9390185)). I want to paste all these numbers into the search engine on this page (https://www.norclub.no/casualty-response/vessels/) and if there is a hit (the number from the list is found on the web page) the result on the page is stored. When the code has gone through all the numbers the code output all the result in an Excel file.

Can anybody help me? It would be most appreciated.

Best regard, Magnus
Reply
#2
This would involve web scraping, and perhaps expect or similar package, see
see: Web-Scraping part-1
and: Web-Scraping part-2

for expect, or similar package, see: https://pypi.python.org/pypi?%3Aaction=s...mit=search
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Search Excel File with a list of values huzzug 4 1,216 Nov-03-2023, 05:35 PM
Last Post: huzzug
  trouble reading string/module from excel as a list popular_dog 0 416 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  list from excel devilonline 4 1,365 Jun-22-2022, 11:00 PM
Last Post: devilonline
  Compare two Excel sheets with Python and list diffenrences dmkfon 1 14,607 Oct-09-2021, 03:30 PM
Last Post: Larz60+
Question How to make a 3D List of Excel Spreadsheets? chatguy 4 2,739 Jan-24-2021, 05:24 AM
Last Post: buran
  Convert Excel to complex list and2handles 1 2,032 Jun-23-2020, 01:51 PM
Last Post: DPaul
  Trying to color an excel row based on list curranjohn46 2 6,549 May-19-2020, 10:35 AM
Last Post: KavyaL
  How to list out specific excel files ajay_pal7 2 2,811 Mar-10-2020, 05:43 AM
Last Post: Larz60+
  Exporting list with dictionary to Excel veromi22 0 3,040 Oct-15-2019, 12:54 AM
Last Post: veromi22
  Is it possible to access and list all macro names in an excel file? kwfine 0 2,443 Feb-07-2018, 04:21 PM
Last Post: kwfine

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020