# Instantiate Chrome Window
driver = webdriver.Chrome(PATH)
# Create New Workbook and open the current active window
workbook = Workbook()
sheet = workbook.active
# Open Text File of Website List
with open('websites.txt') as websiteSpreadsheet:
for line in websiteSpreadsheet: # Iterate through all lines
# Grab Website URL and Set As Source
driver.get(line)
LoadedPageSource = driver.page_source
# ReGEX find all email matches within HTML of website
FoundEmails = re.findall(r'[\w\.-]+@[\w\.-]+', LoadedPageSource)
for email in FoundEmails:
print(sheet.cell_value(email, 0))
sheet["B1"] = email
websiteSpreadsheet.write(email) + (',' (',', '|') + ',' + '\n')
print(email) # Print the Email to Terminal to Show List
# Save and Close Excel Workbook When Finished Executing
workbook.Save()
workbook.Close()
# Quit Open Sheet To Signal Execution Done
sheet.Quit()
