+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Web Scraping & Web Development (https://python-forum.io/forum-13.html)
+--- Thread: Email extraction from websites (/thread-4393.html)
Pages:
1
2
Email extraction from websites - stefanoste78 - Aug-13-2017
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
RE: Email extraction from websites - nilamo - Aug-13-2017
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
RE: Email extraction from websites - stefanoste78 - Aug-13-2017
(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
RE: Email extraction from websites - nilamo - Aug-17-2017
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.
RE: Email extraction from websites - stefanoste78 - Aug-17-2017
(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 ..
RE: Email extraction from websites - nilamo - Aug-17-2017
(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.
RE: Email extraction from websites - stefanoste78 - Aug-17-2017
(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?
RE: Email extraction from websites - nilamo - Aug-17-2017
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.
RE: Email extraction from websites - stefanoste78 - Aug-17-2017
(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
RE: Email extraction from websites - wavic - Aug-18-2017
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.