Python Forum
Thread Rating:
  • 1 Vote(s) - 2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Email extraction from websites
#1
Good morning.

Is it possible to extract all of the emails from a list of links in an excel file column? Once extracted, put them in the cell next to the link.

Thank you
Reply
#2
Yep.  Which module you'd use depends on which version of excel document it is (2003 and earlier was a proprietary binary format, after 2003, excel documents were xml).  Here's one: https://bitbucket.org/openpyxl/openpyxl
Reply
#3
(Aug-13-2017, 05:07 PM)nilamo Wrote: Yep.  Which module you'd use depends on which version of excel document it is (2003 and earlier was a proprietary binary format, after 2003, excel documents were xml).  Here's one: https://bitbucket.org/openpyxl/openpyxl


Hello. I thank you for the answer.
I'm Italian for which I use the google translator that does not always translate well.
I'm not a programmer .. I know in excel to enter the code just click alt f11 and paste it into a module.
For python how do i enter the code? Can i also enter it in excel?
thank you
Reply
#4
Please don't pm people questions related to the thread.  The whole point about being open, is if someone else has a similar issue later on, this conversation might be able to help them, as well.

pm Wrote:Hello.
Did you get my message in response to yours?
I would need help ... i would like to build a project.
thank you

https://python-forum.io/Thread-Email-ext...8#pid22828

I don't really know excel very well.  I'm not sure what hitting f11 does, but my guess would be that that only works for vb.net code.  I'm pretty sure that you can't enter python into excel and have excel run it for you.
Reply
#5
(Aug-17-2017, 01:41 PM)nilamo Wrote: Please don't pm people questions related to the thread.  The whole point about being open, is if someone else has a similar issue later on, this conversation might be able to help them, as well.

pm Wrote:Hello.
Did you get my message in response to yours?
I would need help ... i would like to build a project.
thank you

https://python-forum.io/Thread-Email-ext...8#pid22828

I don't really know excel very well.  I'm not sure what hitting f11 does, but my guess would be that that only works for vb.net code.  I'm pretty sure that you can't enter python into excel and have excel run it for you.


If it is possible to extract all the emails only with python I go more than fine. I'm interested in the end result ..
Reply
#6
(Aug-17-2017, 06:19 PM)stefanoste78 Wrote: If it is possible to extract all the emails only with python I go more than fine.

python is turing complete, so you should be able to do anything with python that you can do with any other language, including extracting text from something.
Reply
#7
(Aug-17-2017, 06:32 PM)nilamo Wrote:
(Aug-17-2017, 06:19 PM)stefanoste78 Wrote: If it is possible to extract all the emails only with python I go more than fine.

python is turing complete, so you should be able to do anything with python that you can do with any other language, including extracting text from something.

With vba you can not extract all emails from a list as links.
Could you help me?
Reply
#8
Sure :)
Show some code, and we'll be more than happy to help you with any issues.

But no, I'm not going to write it for you.  You won't learn python that way.
Reply
#9
(Aug-17-2017, 07:00 PM)nilamo Wrote: Sure :)
Show some code, and we'll be more than happy to help you with any issues.

But no, I'm not going to write it for you.  You won't learn python that way.

You have the right spirit to teach. But I'm graduating in economics. I do not know any programming language. Thank you for the messages. One day, if I can retrieve the contacts and I can have positive feedback, use the forum again to find people interested in creating a website.
thank you
Reply
#10
If you have an Excel document you can get all you want with Pandas or some of the xls modules - Openpyxl for example. Can't provide a code example because I never needed to use this.
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Webscrapping sport betting websites KoinKoin 3 5,337 Nov-08-2023, 03:00 PM
Last Post: LoriBrown
  Web Scraping Sportsbook Websites Khuber79 17 255,998 Mar-17-2021, 12:06 AM
Last Post: Whitesox1
Thumbs Up Issue facing while scraping the data from different websites in single script. Balamani 1 2,075 Oct-20-2020, 09:56 AM
Last Post: Larz60+
  Django send email - email form Remek953 2 2,247 Sep-18-2020, 07:07 AM
Last Post: Remek953
  Python Scrapy Date Extraction Issue tr8585 1 3,236 Aug-05-2020, 04:32 AM
Last Post: tr8585
  Can urlopen be blocked by websites? peterjv26 2 3,322 Jul-26-2020, 06:45 PM
Last Post: peterjv26
  Article Extraction - Wordpress svzekio 7 5,206 Jul-10-2020, 10:18 PM
Last Post: steve_shambles
  Python program to write into websites for you pythonDEV333 3 2,449 Jun-08-2020, 12:06 PM
Last Post: pythonDEV333
  Follow Up: Web Calendar based Extraction AgileAVS 0 1,469 Feb-23-2020, 05:39 AM
Last Post: AgileAVS
  Scraping Websites to post on Telegram kobryan 1 2,591 Oct-19-2019, 07:03 AM
Last Post: metulburr

Forum Jump:

User Panel Messages

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