Israel Dryer israel-dryer

## docx_term_search.py
"""
    A quick and dirty search within the contents of a docx file
    Author: Israel Dryer
    Modified: 2020-07-21
"""

from zipfile import ZipFile

# file path
doc_path = 'senior_paper.docx'

## simple_clock_psg.py
"""
    A simple clock demonstration in PySimpleGUI
    >> YouTube Comments Response <<
"""

import PySimpleGUI as sg
from datetime import datetime

layout = [[sg.Text(text=datetime.now().strftime('%I:%M:%S'), key='-CLOCK-')]]

## wordwrap_example.py
import PySimpleGUI as sg

# create output element
output = sg.Output(size=(50, 15))

# button to initiate text printing
button = sg.Button('Print long text', key='-BTN-')

# set the layout
layout = [[output], [button]]

## gist:bc92cd8bd960492f2cbce617db68cf5e

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                israel-dryer
                / gist:bc92cd8bd960492f2cbce617db68cf5e
            
            
              Created
              September 7, 2020 15:10
            
              
                Find Excel table range with win32com
              
          
    Find Excel Range in Workbook

import win32com.client as client
import pathlib
Initialize the application

  
## py_list_to_html_list.py
"""
  Create a html formatted list from a python list
"""

# email template with curly braces to insert list
email_template = '''
    <p>Hello, here are the items that you ordered:<br>
    {}
    </p>
    '''

## message_finder.py
import re
import win32com.client as client

# pattern for identifying email addresses
pattern = re.compile(r'mailto:(\w+\.\w+@company.com)')

outlook = client.Dispatch('Outlook.Application')
namespace = outlook.GetNameSpace('MAPI')
inbox = namespace.Folders['Inbox']

## add_dl_members.py
"""
    Add members to an existing user distribution list in Python

    https://docs.microsoft.com/en-us/office/vba/api/outlook.mailitem.recipients
    https://docs.microsoft.com/en-us/office/vba/api/outlook.distlistitem.addmembers
    https://docs.microsoft.com/en-us/office/vba/api/outlook.oldefaultfolders
"""
import win32com.client as client

# start an instance of outlook

## wiki_homepage.txt
Welcome to a series of tutorials on how to get the most out of Microsoft Outlook using python!

<table>
<tr>
    <td>
        <ul><b>
            <li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki">Home</a></li>
            <li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/Getting-started">Getting started</a></li>
            <li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/Plain-text-email">Plain text email</a></li>
            <li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/HTML-formatted-email">HMTL formatted email</a></li>

## gist:350fe21e49bc9445f5b6827a668f247e
import csv
import requests
from bs4 import BeautifulSoup

stock = ['AMZN','AXP','AAPL','AXTA','BAC']

# create csv writer
f = open("data_file.csv", "w", newline="", encoding="utf-8")
writer = csv.writer(f)
# add header to csv file

## yt_question_find_and_break.py
search_term = "product"

for message in inbox.Items:
  if search_term in message.Subject:
    do_something()
    break  # this will break out of the loop once the item is found
	"""
	A quick and dirty search within the contents of a docx file
	Author: Israel Dryer
	Modified: 2020-07-21
	"""

	from zipfile import ZipFile

	# file path
	doc_path = 'senior_paper.docx'
	"""
	A simple clock demonstration in PySimpleGUI
	>> YouTube Comments Response <<
	"""

	import PySimpleGUI as sg
	from datetime import datetime

	layout = [[sg.Text(text=datetime.now().strftime('%I:%M:%S'), key='-CLOCK-')]]
	import PySimpleGUI as sg

	# create output element
	output = sg.Output(size=(50, 15))

	# button to initiate text printing
	button = sg.Button('Print long text', key='-BTN-')

	# set the layout
	layout = [[output], [button]]
	"""
	Create a html formatted list from a python list
	"""

	# email template with curly braces to insert list
	email_template = '''
	<p>Hello, here are the items that you ordered:<br>
	{}
	</p>
	'''
	import re
	import win32com.client as client

	# pattern for identifying email addresses
	pattern = re.compile(r'mailto:(\w+\.\w+@company.com)')

	outlook = client.Dispatch('Outlook.Application')
	namespace = outlook.GetNameSpace('MAPI')
	inbox = namespace.Folders['Inbox']
	"""
	Add members to an existing user distribution list in Python

	https://docs.microsoft.com/en-us/office/vba/api/outlook.mailitem.recipients
	https://docs.microsoft.com/en-us/office/vba/api/outlook.distlistitem.addmembers
	https://docs.microsoft.com/en-us/office/vba/api/outlook.oldefaultfolders
	"""
	import win32com.client as client

	# start an instance of outlook
	Welcome to a series of tutorials on how to get the most out of Microsoft Outlook using python!

	<table>
	<tr>
	<td>
	<ul><b>
	<li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki">Home</a></li>
	<li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/Getting-started">Getting started</a></li>
	<li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/Plain-text-email">Plain text email</a></li>
	<li><a href="https://github.com/israel-dryer/Outlook-Python-Tutorial/wiki/HTML-formatted-email">HMTL formatted email</a></li>
	import csv
	import requests
	from bs4 import BeautifulSoup

	stock = ['AMZN','AXP','AAPL','AXTA','BAC']

	# create csv writer
	f = open("data_file.csv", "w", newline="", encoding="utf-8")
	writer = csv.writer(f)
	# add header to csv file
	search_term = "product"

	for message in inbox.Items:
	if search_term in message.Subject:
	do_something()
	break # this will break out of the loop once the item is found